• SQL Server health check
• Assesses:
– Configuration
– Security
– Health
– Performance
• http://brentozar.com/go/blitz
Slide 3
Slide 3 text
• Intellisense for SSMS
• Works on SQL Server 2000 & 2005
• T-SQL formatting capabilities
• Magic keyboard shortcut
– CTRL+SHIFT+E
Slide 4
Slide 4 text
• The best tool for query plan analysis
• Optimizes layout
• Highlights slow tasks
• Statement tree
• More information than you’ve ever
wanted to know about a query.
Slide 5
Slide 5 text
• Searches SQL text within stored
procedures, functions, tables, views, etc.
• Can navigate quickly to objects
• Shows Procedure and Text information
• Saves mucho time.
