Useful Tools

 
As I mentioned in one of my last blog posts, every DBA need the right tool for the job. So from now on, if I find a useful tool, I will add it to this list. If you have any tools I need to add to my list, let me know!

 
Development environment
SQL Server Management Studio (SSMS) for SQL Server 2012

 
SSMS add-ins
SSMS Toolspack (paid if you use SSMS 2012 or higher)
SSMS Boost
Red Gate’s SQL Search
Red Gate’s SQL Prompt (paid, but free trial available)

 
Code formatting
Red Gate’s Format SQL

 
Performance Tuning
SQL Sentry Plan Explorer
Statistics IO Parser

 
Server Health
sp_Blitz (script)
sp_WhoIsActive (script)
SQLCop (tool)

 
Monitoring tools
SQL Monitor (paid, but free trial available)
SQLjobvis

 
Modelling tools
draw.io

 
Spatial data
Shape2SQL
FME Desktop (a.k.a. FME Workbench)

 
Server administration
Royal TS
Microsoft’s Remote Desktop Connection Manager
Red Gate’s SQL Compare

 
Server Maintenance
Ola Hallengren’s Maintenance Solution

 
SSRS
Report Builder 3.0
Reporting Services Scripter (mirror)

 
SSAS
Analysis Services Activity Viewer

 
PowerShell
ExportSQLDeadlockGraphs
SQL Power Doc

 
Other
Notepad++
Notepad++ Compare
SequoiaView (mirror)
ZoomIt

 
 
 
 
 
Change list:
2013-05-07 Initial List
2013-05-08 Added: ExportSQLDeadlockGraphs, SQLPowerDoc
2013-06-26 Added: Maintenance Solution, SSAS Activity Viewer, Statistics IO Parser
2013-09-25 Added: RDCM, Notepad++, N++ Compare, RG Format SQL / SQL Search / SQL Prompt, SequoiaView, ZoomIt
2014-03-06 Added: RG SQL Compare

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 53 other followers

%d bloggers like this: