Useful links, scripts, tools and best practice for Microsoft SQL Server Database
- Updated
Oct 27, 2025 - TSQL
Useful links, scripts, tools and best practice for Microsoft SQL Server Database
Open source SQL Server troubleshooting: sp_PressureDetector, sp_QuickieStore, sp_HumanEvents, and other SQL Server scripts for performance troubleshooting
A box of tricks (SQL scripts) that I've built up over many years for Microsoft SQL Server instance and database administration, and general working-with-data.
SQL Server の各種情報を取得するためのユーティリティ
The sp_who3 stored procedure is a custom and open source alternative to the sp_who system stored procedures available in SQL Server.
Transact-SQL scripts and gists
This repo is the home of various SQL-Server-Tools
A collection of scripts for gathering metrics from SQL Server's underlying DMO's.
Open-source Repository of Useful Scripts and Solutions for Microsoft Database Administrators
sp_Develop can be used by database developers, software developers and for performing database code (smell) reviews.
🚀 A curated collection of SQL mini challenges designed to strengthen your database querying skills. This repository includes weekly exercises focused on real-world scenarios, ideal for beginners and intermediate learners aiming to master SQL through hands-on practice.
A collection of scripts to use with indexes in SQL Server
A set of scripts for managing logins and permissions on SQL Server databases.
💾 📚 📂 Sample Querying , Data and Training Materials with Transact-SQL
Data Lineage for Microsoft SQL Server, Azure SQL Server and Azure Synapse
In this repository, you can find some stored procedures, triggers, views and t-sql examples with both their explanations and implementations.
Working with the Yelp Dataset in Azure SQL and SQL Server
Sources for YourSqlDba : Database maintenance solution that installs as a single SQL script
This repository contains solutions to properly control and maintain scheduled jobs on SQL Servers with either Availability Groups or Database Mirroring
Add a description, image, and links to the t-sql topic page so that developers can more easily learn about it.
To associate your repository with the t-sql topic, visit your repo's landing page and select "manage topics."