Free and open-source database diagrams editor, visualize and design your DB with a single query.

Various SQL stuff I'm working on...tools, scripts, etc

This project provides a solution for automatically restoring SQL Server transaction log backups. Designed for scale. Works directly with backups in Azure blob or UNC path

PowerShell to create a DSC template for TempDB in AzureVMs. Uses DBATools for TempDB config, and creates a scheduled task for the job

Use SQL Server database tables to manage and configure Transactional Replication, and set it up easily between publishers and subscribers using stored procedures

Tools for management of SQL Server's Query Store data

Generate SQL MERGE statements with Table data

Automatic SQL injection and database takeover tool

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.

Performance Collector Checker.

DBA Dash - SQL Server Monitoring Tool

Restore automation engine for SQL Server (On-Prem)

Azure SQL Managed Instance scripts & tools

SQL scripts for the SentryOne database.

sp_whoisactive

A repository for open sourcing a solution for Data Saturdays

A T-SQL script for improving database configuration and design in Azure SQL DB.

Supporting files for the main SQLCallStackResolver sample tool (https://aka.ms/SQLStack)

PowerShell to assemble a timeline combining salient events from multiple Windows Event Log sources.

SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQL LogScout, SQLDiag or PSSDiag. It can dramaticall…

Asynchronous T-SQL procedure execution

Contains SentryOne published Advisory Conditions as well as S1-team submitted conditions for the SentryOne platform.

GitHub repository for sysadmin related scripts