In this session, Paul and Kimberly will run you through their top-ten database maintenance recommendations, with a lot of tips and tricks along the way. These are distilled from almost 30 years combined experience working with SQL Server customers and are geared towards making your databases more performant, more available, and more easily managed (to save you time!). Everything in this session will be practical and applicable to a wide variety of databases. Topics covered and myths debunked include: backups, shrinks, fragmentation, statistics, and much more! Focus will be on 2005 but we'll explain some of the key differences for 2000 and 2008 as well.
Download related files
About SQL SIG
The SQL Server Special Interest Group (SQL SIG) was founded in a partnership between Bennett Adelson and Microsoft. The SQL SIG has become the forum for SQL Server collaboration and instruction from some of the brightest minds in the region. The organization was founded to provide enterprise SQL developers and DBA's the opportunity to collaborate and listen to leading experts discuss various topics within SQL Server. Members include a broad range of disciplines and experiences, from the experienced SQL DBA or developer to a novice on the Microsoft platform.