Free Scripts


Here is a list of some of the most popular (and useful) free scripts and queries I’ve seen around the interweb. There are lot’s more and I’ll be adding them as I’m reminded of them.

Tools list by David Peter Hansen

On a request from twitter David created a list of the tools and scripts he uses as a PFE (Premier Field Engineer for Microsoft). This is an awesome list and I highly recommend taking a look!

Brent Ozar Unlimited

These guys seem to be putting out a script a week these days but they are still some of the highest quality and amazingly useful.  They are now open sourced!

  • sp_Blitz A general health check of your instance.
  • sp_BlitzIndex All you ever wanted to know about your indexes.
  • sp_BlitzFirst Troubleshoot your slow server.
  • There are probably a dozen of them now.  You can go to the GITHUB page above to see the list!
  • Paste the Plan Need to upload a plan to share with others? This is where you want to go.

Adam Machanic

  • sp_WhoIsActive Want to know who working on your instance at the moment? This is it.

Midnight DBAs

  • Minionware The Midnight DBAs are producing an ever expanding set of DBA tools that are truly amazing. These tools are simple to install and configure but are extremely versatile. And best of all free! But be forewarned, they really like documentation. Hour after hour of video and hundreds of pages of documentation are available (so far).Thus far they have:
    • Minion Reindex
    • Minion Backup
    • Minion Enterprise – This one isn’t free but I’ll mention it anyway because it’s part of the set.
    • Minion CHECKDB

Ola Hallengren

Paul Randal

Dave Wentzel

Richie Rump

  • Statistics Parser This is a nice web based parser for the output of STATISTICS IO and STATISTICS TIME.
  • SQL Generator Another great web tool from Richie, this one will help you build your PIVOT query for you. And if PIVOTs aren’t something that come naturally to you (they don’t for me) this can really save your bacon.

Paul Brewer

  • sp_RestoreScriptGenie This is a very nice restore script generator. There is a T-SQL version and a PoSH version.
    Note: It pulls the data from msdb so may not work in a DR situation.

Daniel Mellor

Wayne Sheffield

  • Shred the deadlock graph! – If you have to deal with deadlocks this script is a must.  It shreds the graph into a table and can take inputs from a trace file, deadlock file, the system_health XE file target, a SQL Sentry deadlock collection or even the ring buffer.

SQL Professionals

Daniel Janik

Default Trace Queries
The default trace is running anyway, might as well make use of it. Just remember that it does overwrite itself over time (first in first out) so grab the data while it’s there.



5 thoughts on “Free Scripts

  1. mark says:

    Under Categories i was wondering why you don’t have a PowerShell category?

  2. […] Berry’s DMV Queries (I know there not procs, but i use them al lthe time so had to add um! sqlstudent’s handy Permissions stored procs sp_WhoIsActive Adam Machanic beasty upgrade to sp_who Jason Strates Index Analysis Kimberly Tripps […]

  3. Chad Estes says:

    Why don’t you provide links to your github repositories here since you are no longer hosting your SRVPermissions and DBPermissions scripts?

Leave a Reply

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

You are commenting using your 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: