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
White Papers and Books
https://mva.microsoft.com/ebooks?lng=en-US
Microsoft eBook Migrating SQLServer Databases Azure
Microsoft Enterprise Cloud Strategy PDF
Microsoft Security Development Lifecycle PDF
Multi-Tenant Data Architecture
Optimizing Databasae Storage Performance
Secure ! Secure! Security Links
Security Related white Papers from Microsoft
References:
http://sqlmag.com/database-performance-tuning/mega-guide-free-sql-server-tools
http://sqlmag.com/sql-server-2012/8-free-sql-server-tools
https://www.brentozar.com/archive/2011/02/my-favorite-free-sql-server-downloads/
http://www.sqlskills.com/blogs/erin/the-accidental-dba-tools-for-on-going-monitoring/
Leave a Reply