This book aims to introduce you to PowerShell and how it can be used with SQL Server. How well does it do it? PowerShell is Microsoft’s preferred scripting tool, useful for task automation and ...

Whenever I give a talk on databases or even Azure, I typically ask for a show of hands to see what percentage of the audience has worked with PowerShell. Typically, this is about 20 to 30 percent 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 ...

This book aims to make it easier to manage your SQL Server estate, how does it fare? DBAs often need to manage many SQL Servers, so a tool that provides automation should help get the work done faster ...

A collection of small, focused, standalone tools that I wrote and refined over the years as a System Administrator and DBA. Each one answers a question that comes up ...

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