This lesson introduces you to Microsoft SQL Server 2008 and SQL Management Studio. You will learn how to create a database, add tables to it, and populate it with data. You will then use that data and bind it to a template control. Download source code
Hear best practices for getting the fastest query processing for general-purpose applications, including logical and physical database design, statistics management, query design, query tuning, problems areas to avoid, and more. Learn which query constructs cause the query optimizer to rely on guesses rather than accurate statistical estimates for the number …
SQL Azure provides a fully relational database service that is based on Microsoft SQL Server and familiar concepts such as T-SQL, schema-based tables, and stored procedures. Learn patterns and best practices for developing resilient applications that allow you to take full advantage of the scale and elasticity of SQL Azure …
SQL Server expert Eric Johnson teaches “Accidental DBAs” the basic building blocks of SQL Server maintenance in a no-nonsense, approachable way. Topics include installation, database overview, backing up and restoring databases and more.
Amit Goyal interviews author Michael Lisin about his new book, Microsoft SQL Server 2008 Reporting Services, the comprehensive guide to SQL Server 2008 Reporting Services.
