Transcript Slide 1

Free Sql Server Tools
Every Dev Should Have
Dave Gorman
MCSD,MCDBA

Sql Server Mag : Dec 2010
◦ Top Products issue

http://www.sqlservercentral.com/articles/
Tools/64908/

weblogs.sqlteam.com/mladenp:
◦ Free SQL Server tools that might make your
life a little easier
Tons of tools

Free add on to SSMS to aide in ongoing
development
◦ http://www.ssmstoolspack.com/

Troubleshooting Performance Problems

Keep DB optimized
◦ sp_whoisactive
◦ http://www.ignitefree.com/
◦ Atlantis Data Space Analyzer
◦ http://ola.hallengren.com/
Agenda
<demo SSMS Tools Pack>
 http://www.ssmstoolspack.com/Download
.aspx
 http://blogs.lessthandot.com/index.php/D
ataMgmt/DBProgramming/ssms-toolspack-something-every-sql-serv-2


Snippets, Query History, Gen Inserts,
Search DB content
During Development

<demo sp_whoisactive>

sp_whoisactive
◦ Replaces sp_who2 and dbcc inputbuffer(xx)
◦ @help=1 for extensive help
◦ http://sqlblog.com/blogs/adam_machanic/archive/2010/10/
21/who-is-active-v10-00-dmv-monitoring-made-easy.aspx
◦ How To:
 http://www.brentozar.com/archive/2010/09/sql-server-dbascripts-how-to-find-slow-sql-server-queries/
 http://www.sqlmag.com/article/sql-server/SP_WhoIsActive.aspx
Troubleshooting

Index Health
◦ Rebuilding vs Reorganizing

<demo ola.hallengren.com>
http://ola.hallengren.com/Documentation.html#
GettingStarted
Maintenance

Other Free software:
◦ Tableau Software
◦ Quest’s Toad Data Modeler
◦ LessThanDot’s SQLCop

Useful links:
◦
◦
◦
◦
◦
http://sqlcat.com/
http://www.sqlservercentral.com/
http://sqlserverpedia.com/
http://www.sqlteam.com/
http://sqlblog.com/
Questions?