Awesome SQL

A curated list of sweet SQL Server & Azure SQL Database tools, scripts, and resources.

Contents

Development Environments (IDEs)
Management Tools
T-SQL Code Generators
Query Tuning
Documentation
Scripts and Stored Procedures

Development Environments

Azure Data Studio - Azure Data Studio is a cross-platform database tool for Windows, MacOS, and Linux. Now has an official Extension with support for SSDT Database Projects!

Management Tools

SQL Server Management Studio (SSMS) - SQL Server Management Studio (SSMS) is an integrated environment for managing SQL Server and Azure SQL Database.

T-SQL Code Generators

SCD-Merge-Wizard - SCD Merge Wizard is an application which will help you generate T-SQL merge statements for implementing Slowly Changing Dimensions in your data warehouse.

Query Tuning

SentryOne Plan Explorer - A standalone Windows application and SQL Server Management Studio (SSMS) add-in that allows you to view SQL Server query execution plans, and provides a lot of additonal info not available in SSMS's execution plan view.

Documentation

Docs - Learn how to use Azure SQL Services and SQL Server to manage your database needs, both on-premises and in the cloud.

Scripts and Stored Procedures

Backup

Restore

Index Optimization