Welcome to my box of tricks (SQL scripts) for Microsoft SQL Server instance and database administration! I've put considerable effort, over many years, into creating my own scripts, as well as ...

SQL, or the structured query language, is a specialized programming language designed for working with databases. There are a few different variations of SQL from different organizations and projects, ...

Drive insights in near real time by breaking the wall between operational and analytical stores. Analyze all your data using both Spark and SQL runtimes in the cloud with Azure Synapse Link. Manage ...

This script identifies job step failures within SQL Server Agent jobs. This alert ensures timely detection and resolution of failures, even when the overall job status indicates success. Will not work ...

The most Azure-enabled release yet, with continued performance, security, and availability innovation. Drive insights in near real time by breaking the wall between operational and analytical stores.