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) : 
https://msdn.microsoft.com/en-us/library/mt238290.aspx

Download SQL Server 2016 Developer :
Release date 6/1/2016
https://myprodscussu1.app.vssubscriptions.visualstudio.com/Downloads?PId=2057
Blog Post :
https://blogs.technet.microsoft.com/dataplatforminsider/2016/03/31/microsoft-sql-server-developer-edition-is-now-free/

Download CodePlex SQL Database Migration Wizard : 
https://sqlazuremw.codeplex.com/
Download MySQL WorkBench : 
https://dev.mysql.com/downloads/workbench/5.2.html

Download MySQL Community Server: 
http://dev.mysql.com/downloads/mysql/

Download S3 Browser: 
Free Windows Client for Amazon S3 and CloudFront
http://s3browser.com/download.aspx

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: 
https://www.virtualbox.org/wiki/Downloads

ClearTrace Download
http://www.scalesql.com/cleartrace/download.html
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.
http://downloads.sqlsentry.com/downloads/sqlsentryplanexplorer/x64/PlanExplorerInstaller.exe
http://downloads.sqlsentry.com/downloads/sqlsentryplanexplorer/x86/PlanExplorerInstaller.exe

RedGate SQL Search
Find fragments of SQL in tables, views, stored procedures, functions, views, jobs, and more
http://www.red-gate.com/products/sql-development/sql-search/

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.
https://sqlserverperformance.wordpress.com/2012/07/08/sql-server-2012-diagnostic-information-queries-july-2012/

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.
https://ola.hallengren.com/

SQLIOSim
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.
https://support.microsoft.com/en-us/kb/231619

Leave a Reply

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

*