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.

dbt adapter for SQL Server and Azure SQL

A set of F# Type Providers for statically typed access to MS SQL database

:closed_book: Various example reports I use for Microsoft Report Server (SSRS & PBIRS) as well as documents for unit testing, requirements and a style guide template.

:hammer_and_wrench: T-SQL scripts for the long haul: optimizing storage, on-the-fly documentation, and general administrative needs.

:memo: This VSTO Add-In is used for cleaning & creating a script for batch loading records into SQL Server, Oracle, Documentum, Markup or Markdown Languages. The functionality within the ribbon allows a quick way of preparing a bulk data load. Otherwise, the requests can be both time-consuming and error prone. It is written in 3 different versions as a VSTO Add-In in C# and VB.NET as well as a VBA Add-In. The most complete version is C#.

Questions, Solutions & Labs of Microsoft's Official Power BI Certification.

This tool transpiles openCypher graph query language to a relational database query language. This project publishes a T-SQL for Microsoft SQL Server as the target query language.

Banco de Dados para Estudo

SQL Server の各種情報を取得するためのユーティリティ

TOP 200 #Dev 🏆 LeetCode, Solutions in  Swift, Shell, Database (T-SQL, PL/SQL, MySQL), Concurrency (Python3). @ S. Leschev. Google Engineering Level: L6+

Samples showing how to use Microsoft.SqlServer.TransactSql.ScriptDom classes

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

Interract with Microsoft SQL Server (MS SQL | MSSQL) servers and their linked instances in restricted environments, without the need for complex T-SQL queries.

Open-source Repository of Useful Scripts and Solutions for Microsoft Database Administrators

This repo is the home of various SQL-Server-Tools

A collection of scripts for gathering metrics from SQL Server's underlying DMO's.

sp_Develop can be used by database developers, software developers and for performing database code (smell) reviews.

Using Python Pandas dataframe to read and insert data to Microsoft SQL Server

A collection of scripts to use with indexes in SQL Server

🚀 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.

Simple SQL query builder for .NET

Official T-SQL port of Sqids. Generate short unique IDs from numbers.

A set of scripts for managing logins and permissions on SQL Server databases.

Unified Data Foundation with Microsoft Fabric with Options to Integrate with Azure Databricks and Microsoft Purview

💾 📚 📂 Sample Querying , Data and Training Materials with Transact-SQL

Useful T-SQL container