Five Free SQL Server Tools You Need Now

Developers have a love/hate relationship with databases; we love to hate them. But we do have to work with them. In this presentation, I'll show you five tools that will help you as a developer uses SQL Server efficiently.

Transcript

1. Richie Rump @Jorriss
2. • SQL Server health check • Assesses: – Configuration – Security – Health – Performance • http://brentozar.com/go/blitz
3. • Intellisense for SSMS • Works on SQL Server 2000 & 2005 • T-SQL formatting capabilities • Magic keyboard shortcut – CTRL+SHIFT+E
4. • 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.
5. • Searches SQL text within stored procedures, functions, tables, views, etc. • Can navigate quickly to objects • Shows Procedure and Text information • Saves mucho time.
6. • SQL Snippets • Window Connection Coloring • Histories • CRUD Stored Proc generation • Query Templates • Generate Insert statements