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

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

This repository provides a set of T-SQL and Pandas coding exercises along with their solutions, designed for practicing SQL and Pandas skills in preparation for coding interviews. These exercises use ...

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.