-
Using Azure Cloud Shell To Manage Resources
As a DBA or any data professional, it is becoming more valuable and vital to have a well rounded understanding of your data estate and environment. However, sometimes it can be a bit cumbersome, especially when connecting to Azure resources via PowerShell. You have to fumble with authentication, connection cmdlets and more, which can be…
-
Migrating 20+ Production AGs From Windows Server 2016 To 2025: A Distributed Availability Groups Deep Dive
Before we dive in, this is a longer post but if you’re staring down a Windows Server 2016 end of support deadline with AGs in your environment, it’s worth every minute. I hope this post can help answer some questions that pop up when choosing a migration approach for something like this. Setting The Scene…
-
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…
-
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…
-
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…
-
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…
-
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…
-
Subscribe
Subscribed
Have a WordPress.com account? Log in now.
