In this directory, you will find my collection of SQL scripts to solve various challenges using recursion. 👓 I am always on the lookout for puzzles that can be solved using recursion. If you have any ...

Microsoft recently updated its All-In-One Script Framework, which features SQL Server (and other) scripts designed to address common problems reported by users in forums, support incidents and online ...

This article provides an overview of the SQL Server Agent, which is a Microsoft Windows service that executes scheduled administrative tasks (called jobs) in SQL Server and Azure SQL Managed Instance.

Both scripts enrich discovered instances by reading the Windows registry remotely and export the results to CSV. They recognize SQL Server releases from legacy versions through SQL Server 2025 and ...

As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now. Gone are the days when you would second guess yourself choosing to use SQL Server over a ...

As today’s database administrators (DBAs) manage the complexity of modern database environments, particularly containerized systems, they must lean into smart automation to transform database ...