Downloads/3rd Party Tools

Cheat Sheets:

SQL Server T-SQL Cheat Sheet

Powershell Cheat Sheet

Python Cheat Sheet

The SQL sheet started with the sheet created by Pinal Dave at SQL Authority.

Other cheet sheets:

Added Bytes

Refcardz

Interview Cram Sheets:

I also put together some cram sheets to help refresh my memory before an interview, one on Database and BI, and another on developer and .Net facts.

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:
SQLBlog.com

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:
Brent Ozar

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.

Ola Hallengren

They are also available on GitHub

4) Glenn Berry has a set of diagnostic SQL scripts.

Glenn Berry

5) Greg Low of the SQL Down Under podcast has released a set of diagnostic and utility scripts:

SDU Tools

6) Kimberly Tripp: sp_helpindex

7) List Of Tools And Utilities

Other Downloads

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.

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