Hitting Parallel_Redo_Flow_Control waits with Availability Groups

In late June 2019, June 26th to be exact, we experienced an outage on Stack Overflow for about 11 minutes. It’s not unusual that we had an outage. They happen. Not often, but they do still happen. This one, however, was a little different because it was caused by a maintenance job that was running on our primary SQL Server for Stack Overflow. The job that caused it was something I’d noticed about a month prior, but had stopped it before an actual outage occurred.

Finally, My first PASS Summit

I’ve been working with SQL Server for a long time, and have always wanted to attend PASS. For one reason of another, with numerous employers, I hadn’t been able to go. The answer was always no. <insert sad face> The biggest blocker was always the cost. The conference is expensive. Seattle is expensive. It has always been impossible to get my employer to foot the bill for it. This year I was incredibly lucky that my employer, Stack Overflow, paid for my trip to PASS Summit.

How Stack Overflow upgraded from Windows Server 2012

Warning: This post is long. While working through this massive server upgrade/migration process, tears were shed, many cuss words were said, along with a general feeling of frustration, which ultimately culminated into extreme happiness once the migration was completed. The scale and complexity of the implementation factor into the length of this post, and I’ll share my thought process on how this was executed, so here goes. Last year, when we upgraded to SQL Server 2017 we didn’t make any changes to the operating system on our main production servers.

How we upgraded Stack Overflow to SQL Server 2017

This post has been rattling around in my head for months, and with SQL Server 2019 on the horizon, I figured I’d finally put my thoughts down, especially since I know we might hit some of the same issues when we upgrade. A quick background, when I became the DBA at Stack Overflow, we had various versions of SQL Server in place — the majority were at some level of SQL Server 2016, each with a different CU or SP installed.

Pivoting yet again - New blog and domain

Almost a year ago, in November 2017, I moved back into a more technical role at Stack Overflow and became a Database Administrator. During this time, I have wanted to relaunch my blog, as it’s been over three years since I really wrote anything (yes, I’m terrible). Well, that time has finally come. After spending a few weeks, looking at various options to replace Wordpress, I finally decided on using Hugo and Netlify.