Useful Free Tools and Books

Useful Free Tools Download Links
Wonderful Microsoft utilities PerfMon , Profiler ,  Dynamic Management Views and System Tables should provide lot of insights and help in diagnosing and troubleshooting issues. These free tools are nice add-ons and improves the productivity.


Download SQL Server Management Studio (SSMS) :

Download SQL Server 2016 Developer :
Release date 6/1/2016
Blog Post :

Download CodePlex SQL Database Migration Wizard :
Download MySQL WorkBench :

Download MySQL Community Server:

Download S3 Browser: 
Free Windows Client for Amazon S3 and CloudFront

Download AWS CLI - Command line Interface 
Download the AWS CLI MSI installer for Windows (64-bit)
Download the AWS CLI MSI installer for Windows (32-bit)

Download Virtual Box:

ClearTrace Download
ClearTrace cleanly summarizes the query performance data collected through traces.

SQL Sentry Plan Explorer
This is fairly effective tool for deciphering SQL Server execution plan details.

RedGate SQL Search
Find fragments of SQL in tables, views, stored procedures, functions, views, jobs, and more

Glenn Berry's Diagnostic Queries
Glenn Berry got quite a few wonderful videos on pluralsight and these are extremely handy scripts to diagnose and troubleshoot any SQL Server related issues.

SQL Server Maintenance Solution by Ola Hallengren
I have seen numerous companies including ours use Ola Hallengren maintenance solution for automating all maintenance related Jobs. Simplicity in setting up SQL Agent Jobs is wonderful.

You can use this tool to perform reliability and integrity tests on disk subsystems.
These tests simulate read, write, checkpoint, backup, sort, and read-ahead activities for Microsoft SQL Server.

Leave a Reply

Your email address will not be published. Required fields are marked *