DBA Unfiltered

  • Using PowerShell and dbatools for Replication Administration

    The Old Way Might Not Be The Best Way So, I have an older blog post that covers how to remove and add a single article from a replication publication. The purpose of that post was to show you how to remove an article, which is pretty straightforward, but more importantly, how to add it…

    TheUnfilteredDBA

  • ChatGPT Series Part 4: Automating SQL Server Tasks with PowerShell

    Welcome to part 4 of the ChatGPT series: Automation with PowerShell (PS). PowerShell can be a polarizing tool—people tend to either love it or feel overwhelmed by it. I remember feeling quite intimidated when I first started learning it. However, rest assured, you don’t need to be an expert programmer or scripter to begin leveraging…

    TheUnfilteredDBA

  • Log Shipping Made Easy with PowerShell and Dbatools

    Diversify your Toolbelt As a DBA, it is important to know more than one way to skin a cat. With all of the options out there to setup and cutover log shipping, for me, PowerShell and the use of the open source dbatools module has come in handy to seamlessly setup and cutover log shipping…

    TheUnfilteredDBA