The SQL sheet started with the sheet created by Pinal Dave at SQL Authority.
Other cheet sheets:
Interview Cram Sheets:
3rd Party Script Downloads
Here are some stored procedures written and maintained by the SQL community that I’ve found very useful.
1)The first is sp_whoisactive, written by Adam Machanic. It is a great proc to monitor activity on a SQL Server instance to gather data to diagnose many kinds of performance issues.
The procedure can be downloaded from:
2) The second is from Brent Ozar, the sp_blitz procedure. This is very useful to return information for the administration of a SQL Server instance. Running the procedure will (among other things) let you know if there are databases that haven’t been recently backed up, a database with untrusted foreign keys, potential security issues, and the list goes on.
The procedure can be downloaded at:
A cool feature is that when an issue is discovered, the results will return a URL to Brent’s site to give more detail on the issue and steps to resolve it.
3) Ola Hallengren has a great set of database maintenance scripts.
4) Glenn Berry has a set of diagnostic SQL scripts.
5) Greg Low of the SQL Down Under podcast has released a set of diagnostic and utility scripts:
6) Kimberly Tripp: sp_helpindex
Best Practices Analyzer: No version available for 2014 or 2016 as of now.
2012 Feature Pack: Command line utilities, drivers and other utilities.
Data Migration Assistant: Replaces the Upgrade Advisor.
Links to some development tools that I’ve found useful. Most are free, and some have a pay version for sale.
Chocolatey(free): Package manager, similar to NuGet in Visual Studio. After installing Chocolatey, you’re able to download and install programs with one line of code.
CodeMaid(free): Visual Studio extension for cleaning and re-formatting code.
Gliffy(free): Browser app to create diagrams and flowcharts
Notepad++(free): A Notepad replacement and a source code editor, with built-in support for dozens of languages. I like the ‘XML Tools’ plugin which allows for formatting XML files with its ‘Pretty Print’ feature. The ‘JSON Viewer’ plugin can format JSON, as well.
Postman: Great tool for calling and testing APIs.
SQL Sentry Plan Explorer: Tool to view execution plans with many improvements over SSMS.
TortoiseSVN(free): Integrates Subversion versioning control into Windows Explorer.
Vertabelo(pay): Online data modeling tool. Free trial, with subscriptions or per-day usage available.
WinMerge(free): Tool to compare directories or to compare files. Differences can be merged from one file to another. I use this tool within Subversion to view diffs in file versions.
Scott Hanselman posts a list of his favorite tools periodically on his site.