Free Tools
I use the following tools on a regular basis. These are scripts, applications, or SSMS add-ins that are put out by the SQL Server Community and vendors:
Scripts
- Ola Hallengren’s Maintenance Solution
- Adam Machanic’s sp_WhoIsActive
- Paul Randal’s Wait Statistics query
- Paul Randal’s Latch Statistics query
- Glen Berry’s Diagnostic Scripts
- Niko Neugebauer’s Columnstore Indexes Script Library
- Denny Cherry and Associates Github Repository
- Brent Ozar Unlimited’s scripts
- MSSQL Tiger Team Github Repository
- DBA Tools Powershell Scripts
- SQL3D Github Repository (personal script repository)
Applications
- Sentry One Plan Explorer
- SQL Query Stress
- Statistics Parser (web site)
- CPU-Z
- DiskSpd
- CrystalDiskMark
- SQL Server Migration Assistant for Oracle
- SQL Server Data Migration Assistant
- SQL Server Management Studio (SSMS)
- SQL Server Data Tools (SSDT)
- Azure Data Studio
- Pssdiag/Sqldiag Manager
- SQL Nexus Tool
- SQL Setup Tools
- Microsoft Kerberos Configuration Manager for SQL Server
- Visual Studio Dev Essentials Program (SQL Server Developer Edition download)
- Power BI Desktop
- SQL Server Docker Hub
- Availability Group Failover Detection Utility
SSMS Add-Ins
Leave a Reply