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

Let's follow up the last column with a step-by-step breakdown shows how the PowerShell script automates SQL Server backups, manages retention, logs activity and verifies data integrity. In my first ...

This article is a revised version of the original published January 3, 2005. See Editor’s Note for details. Two major factors drive database backups these days: compliance and disk space. Some ...

Microsoft SQL Server version migrations are one of the more difficult activities for a DBA to execute, yet they are a very common change to the infrastructure. Databases eventually have to be migrated ...

Knowing how to automate tasks in the cloud will make you a more productive DBA. Here are the key concepts to understand about cloud scripting and a rundown of the best tools for automating code in ...

For the past several weeks I’ve been doing nothing but complaining about vendors so I thought I’d take a break and write something about SQL Server for a change. So to that end today I’m gonna talk ...