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
  • Backup
  • Restore
  • Index Optimization

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