DBA Unfiltered

  • Robotic arms working on electronic circuit boards in a factory

    DBAOps Pt.3: Automating A Full SQL Server AG Lab With Hyper-V And PowerShell From Zero To Synchronizing

    Before we begin, I first and foremost would like to give credit to Amy Abel for this idea. I’ve been blogging over the past few weeks about how the DBA role is evolving and there is a shift in mindset to have when approaching projects and tasks. I have mentioned before that I was a…

    Jordan Boich
  • Digital data packets flowing through transparent pipes connecting servers and routers in a network hub

    We Built a Hybrid AzDO Pipeline Instead of YAML. Here’s Why.

    Microsoft is always moving towards the latest and greatest features for their products. Faster, more efficient, cool features. There’s usually something that claims to make the grass greener if you go to the cutting edge. However, some things just work. And some things are still useful and applicable to architecture designs even though they may…

    Jordan Boich
  • Security officer in uniform focused on unlocking a door with a key.

    Configuring gMSA Accounts for SQL Server and Availability Groups: The Complete Gotcha List

    So, you’re making a valiant effort to improve your security posture in your SQL Server estate and have decided to move to Group Managed Service Accounts (gMSAs). But, after switching from your local account running SQL, or your domain account, you’re staring at Configuration Manager telling you that “It could not start the service in…

    Jordan Boich
  • Humanoid robot holding a tablet showing system analysis, interacting with smiling IT specialist in office.

    We Built an AI-Assisted Operating Model for SQL Server Migrations

    Disclaimer/ Edit: This post was heavily “polished” and rewritten with AI. The content is mine and true but I’m sure you’ll detect the AI patterns in this one :). The Problem with Traditional DBA Operations If you’ve worked in enterprise SQL Server long enough, you know how migrations usually go. A request comes in to…

    Jordan Boich

  • 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…

    Jordan Boich

  • 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…

    Jordan Boich

  • 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…

    Jordan Boich