Restoring an entire SQL Server user databases with PowerShell using dbatools
All the good DBAs backup their databases. A significant amount of SQL DBAs use [Ola Hallengrens maintenance solution](https://ola.hallengren.com/) to do so....
Rob Sewell
Rob was a SQL Server DBA.
Now he just helps people with PowerShell, Azure, Automation, and Data.
He is a Cloud and Data Center MVP and a Data Platform MVP, co-leader of Data South West UK user group and PSConfEU organiser. One of the Admins for Data Saturdays https://datasaturdays.com
He is a proud supporter of the Data and PowerShell communities.
He has a fabulous beard
Recent Posts
Adding a PowerShell Job Step to an existing SQL Agent Job Step with PowerShell
In my last post I showed how to add a T-SQL Job step to an existing SQL Agent Job. The process is exactly the same for a PowerShell job step. As before I ga...
VS Code PowerShell Snippets
Just a quick post, as much as a reminder for me as anything, but also useful to those that attended my sessions last week where I talked about snippets in Po...
Quickly Creating Test Users in SQL Server with PowerShell using the sqlserver module and dbatools
One of the most visited posts on my blog is nearly two and half years old now – Add User to SQL Server Database Role with PowerShell and Quickly Creating Tes...
SQL VNext sp_configure on Windows and Linux with dbatools
This weekend I set up some SQL vNext virtual machines, two on Windows and one on Linux so that I could test some scenarios and build an availability group. ...