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. [youtube pfCKjUwWYGs]
PowerShell can change the way you work with SQL Server forever. This webcast is the first of a series designed to take DBAs with no knowledge of PowerShell and give them what they need to use this new scripting language. In this first one-hour session, Sean McCown provides a general …
