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

Productivity Tools

JSON To CSV Converters
https://konklone.io/json/

JSON Parser
http://json.parser.online.fr/

JSON Parser with Search functionality.. Really useful
https://jqplay.org/

HTML to CSV
http://www.convertcsv.com/html-table-to-csv.htm

WegPage Test
https://www.webpagetest.org

PageSpeed Insights
https://developers.google.com/speed/pagespeed/insights/

Stat Counter
http://statcounter.com/

Subnet Calculator
http://www.subnet-calculator.com/

Useful WordPress Plugins
https://premium.wpmudev.org/blog/essential-wordpress-plugins/

Password Generator
http://passwordsgenerator.net/

Website Penetration Testing
https://pentest-tools.com/home