Videos tagged with MSSQL


SQL Server 2005: Creating and Using Stored Procedures

SQL Server 2005: Creating and Using Stored Procedures

Posted in Frameworks, Databases, Companies, Development

This video expands on the topic of Stored Procedures which was introduced several lessons ago. In this video we explain the basic syntax to create and update stored procedures, using input and output parameters, return values, declaring variables and adding other T-SQL programming elements into you stored procedures, how to execute your stored procedures from the query window, and finally ...

Tags: Frameworks, Databases, Microsoft, MSSQL, ASP.NET, C#, .NET Framework, VB.NET, SQL Server 2005 for Beginners



SQL Server 2005: Building and Customizing Reports in Business Intelligence Development Studio

SQL Server 2005: Building and Customizing Reports in Business Intelligence Development Studio

Posted in Frameworks, Databases, Companies, Development

Building on the previous lesson, we dive into building reports from scratch and modifying the reports that were created using the wizards and designers. We also demonstrate how to embed your reports into your ASP.NET Web Form applications. Date: 22 October 2006

Tags: Frameworks, Databases, Microsoft, MSSQL, ASP.NET, .NET Framework, SQL Server 2005 for Beginners


SQL Server 2005: Getting Started with Reporting Services

SQL Server 2005: Getting Started with Reporting Services

Posted in Frameworks, Databases, Companies, Development

SQL Server Reporting Services allows you to design and deploy nicely formatted and interactive reports representative of your data. Suitable for print or online distribution, these reports and it allows you to get professional results very quickly. This video demonstrates how to set up Reporting Services and the Business Intelligence Development Studio to build reports using the wizards and des...

Tags: Frameworks, Databases, Microsoft, MSSQL, ASP.NET, .NET Framework, Reporting Services, SQL Server 2005 for Beginners


SQL Server 2005: Using SQL Server Management Studio

SQL Server 2005: Using SQL Server Management Studio

Posted in Frameworks, Databases, Companies, Development

SQL Server Management Studio Express will typically be your main interface into SQL Server Express. This lesson demonstrates the essential techniques and skills you’ll need to successfully connect to database instances, navigate the query window and scripting database objects, attaching, detaching and backing up databases, and much more. Date: 23 October 2006

Tags: Frameworks, Databases, Microsoft, MSSQL, ASP.NET, .NET Framework, SQL Server 2005 for Beginners




SQL Server 2005: Understanding Security and Network Connectivity

SQL Server 2005: Understanding Security and Network Connectivity

Posted in Frameworks, Databases, Companies, Security, Development

SQL Server beginners will learn to differentiate between SQL Server database files and SQL Server processes. Explore scenarios for connecting to SQL Server Express databases, enabling and disabling user instances, login permissions, and other security precautions. Date: 20 March 2006

Tags: Frameworks, Databases, Microsoft, MSSQL, Security, ASP.NET, .NET Framework, SQL Server 2005 for Beginners