One of the very mundane, but extremely valuable tasks that any DBA must perform is the backup and restore of databases. In this post, we’ll look at a sample script that can backup databases on a given ...

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

Idera’s SQLsafe — a backup utility for Microsoft SQL Server — was designed to compete directly with Imceda’s LiteSpeed. Similar to LiteSpeed, SQLsafe improves on native SQL Server backups with ...

A practical Microsoft SQL Server administration portfolio covering database health, backup compliance, performance troubleshooting, blocking, storage, SQL Server Agent, and Always On Availability ...

This project is more than a collection of SQL scripts. The SQL Server Diagnostics desktop application brings together a curated set of SQL Server diagnostic checks into a single tool, helping you ...

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

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