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
8) SQL Cop: tSQLt tests to highlight potential problems in your database
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. Tools have a free community version available unless otherwise noted.
Chocolatey: Package manager, similar to NuGet in Visual Studio. After installing Chocolatey, you’re able to download and install programs with one line of code.
Diagrams.Net : Diagramming and flowchart tool – Web app or desktop app.
Notepad++: 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.
Vertabelo: Online data modeling tool. Free trial, with subscriptions or per-day usage available.
WinMerge: Tool to compare directories or to compare files. Differences can be merged from one file to another.
Windows Terminal: Run multiple shells (like Powershell and command). I like having access to these in one place, plus the multiple tabs feature.
Scott Hanselman posts a list of his favorite tools periodically on his site.