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

SQL Server Maintenance Solution

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

sp_whoisactive

Open source SQL Server troubleshooting: sp_PressureDetector, sp_QuickieStore, sp_HumanEvents, and other SQL Server scripts for performance troubleshooting

Pssdiag/Sqldiag Manager is a graphic interface that provides customization capabilities to collect data for SQL Server using sqldiag collector engine. The data collected can be used by SQL Nexus to…

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

A practical sample of RAG pattern applied to a real-world use case: make finding samples using Azure SQL easier and more efficient!