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
  • Server applying automatic software patches with network monitoring and threat detection

    How I Use Python To Automatically Download And Stage SQL Server CUs And GDRs

    Patching is such an important part of ensuring your MS SQL Servers are secure, reliable, and resilient. As important as it is, it’s still a tedious process. You have to chronically check for patches (hopefully you don’t have your servers running SQL to auto download and apply patches via Windows Update), look at breaking changes…

    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

  • 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