sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.

Useful links, scripts, tools and best practice for Microsoft SQL Server Database

Welcome to my GitHub repository. I hope you enjoy solving these puzzles as much as I have enjoyed creating them.

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

Database Project with generic procedures to consume API through GET/POST methods.

Database containing DBA helper code and open source software.

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.

💾 List of Database notes and exercises from Datacamp, CMU, and others.

🐸 Various scripts I use for SQL Server databases. These include Reporting Services, Primavera P6, and general administration T-SQL backup and restore, etc.

A collection of cool and useful tools, procedures and scripts for the discerning DBA

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

a PowerShell-based tool that outputs SQL Server health and performance diagnostics data to either Excel or HTML, and saves execution plans and deadlock graphs as .sqlplan and .xdl files.

网站设计一类源码仓库

sp_CRUDGen is a free open-source SQL Server stored procedure that generates stored procedures for you based on your tables and metadata like foreign keys and data types. The generated stored procedure code utilizes the SQL Server community best practices.

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

A project template aiming for easy Continuous Deployment of SSDT projects.

The CEDS Integrated Data Store factors the entities and attributes of the CEDS Domain Entity Schema (DES) with standard technical syntax and 3rd normal form database normalization. The IDS Logical Model provides a standard framework for integration of P-20 data systems through a well-normalized “operational data store”. In a P-20 data system, th…

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

SQL Server and Azure SQL sample project for trying out the Dev Containers extension