Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

Idera, a provider of Microsoft SQL Server management and administration tools, has announced the latest version of its SQL Server backup and recovery solutions: SQL safe 6.4, SQL safe lite 6.4 and SQL ...

A couple of months ago, I wrote an article on how to use PowerShell to back up a database within SQL Server Express Edition. Even though the technique that I described in that post works, the script ...

The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...

This excerpt from the upcoming book, SQL Server 2008 Administration in Action, introduces the role of service-level agreements (SLAs) as part of a DBA's overall strategy to maintaining reliable ...

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