I recently needed to configure log shipping for multiple databases at once as part of a migration project. I turned to PowerShell to do this. But before we get to that part, this post assumes that you’ve done the upfront work to create shares for the backups to write to and for the backups to … Continue reading How To Use Powershell to Configure Multiple Databases for Log Shipping
Hello dear reader! This is the third post in a series to help you get started automating things with PowerShell. You will be looking at how to start and stop SQL Server using PowerShell as well as setting the Max Server Memory setting, measuring free disk space and more. This series is just an introduction … Continue reading Introduction To PowerShell For The DBA Part 3
In Part 1 of this series we began to look at how you can leverage PowerShell as a DBA and there was a brief discussion about automation. Today you will experiment with the DBATools command Copy-DbaLogin and learn about Out-Gridview and the -whatif switch. Let’s suppose you have one, or more logins you need to … Continue reading Introduction To PowerShell For The DBA Part 2
Automating Tasks With PowerShell What we’re really talking about in this series is automation, specifically by using PowerShell. Now, in simple terms, automation is about removing the human, manual element in doing tasks. This will produce time savings for you as a DBA in the long run and provide better consistency in your environment than … Continue reading Introduction To PowerShell for the DBA Part 1