Description:

Title: The Ultimate DBA Toolkit

Level: 200

Abstract: Microsoft SQL Server has always shipped with some of the best database tools of any database platform. But Microsoft and many talented DBAs and developers also publicly release additional tools for SQL Server that, while supported and very useful, remain virtually unknown to the average SQL Server DBA and Developer This session will detail and demonstrate:

• The Microsoft SQL2H performance analysis tool
  

• The Microsoft SQLIOSIM disk i/o load testing tool
  

• The Microsoft SQL Server 2005 Performance Dashboard
  

• SQLDiag and SQLNexus
  

• Tools and sample code from the CodePlex community
  

• Tools and sample code from the SQL Server MVP community
  

These tools can make your long days shorter and make difficult chores much easier. They augment a variety of capabilities within SQL Server, covering everything from Reporting Services and Integration Services to administrative and security tools. You’ll be able to get much more work done in your limited work day by learning about the tools I present in this session.

Prerequisites: Intermediate database administration and development skills on SQL Server 2000 and 2005

Note: No ISV tools are mentioned in this session. This session covers only ‘public domain’ tools and code, most of which are drawn from my Tool Time column in SQL Server Magazine.