Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Vivek Yadav, an engineering manager from ...

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

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

If you are an old hand at Microsoft SQL Server, you have probably used the SQL Server Agent (i.e., SQL Agent) service and MSDB database for the last 20 years. With a humble and largely unchanged ...

Amazon Simple Storage Solution (Amazon S3) allows you to back up data from your Windows Server on its massive cloud storage. Backing up your data is crucial, as it prevents data loss in the event of ...

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

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