T-SQL Tuesday: The last ticket I closed

February 13, 2024 Andy 2

For this month’s T-SQL Tuesday, Brent Ozar (blog|Instagram) asks us to describe the most recent ticket we closed. “We had a pretty significant wait spike…” The literal last ticket I closed was “please run this script in production…”, and I don’t think it would be … [Read More]

A black dog sits outside on a blue bed. Her golden eyes are looking directly at the camera. She wears a rainbow kerchief around her neck, with the words "I bark at bigots" emblazoned on it

Publishing a Code of Conduct isn’t enough

July 13, 2022 Andy 1

I’ve seen more and more events & communities adopt Codes of Conduct. Even local events, local user groups, and smaller online communities are adopting Codes of Conduct. That’s GREAT! …but it’s just a great start. It’s not that easy. Discoverability The issue of discoverability is … [Read More]

Diagram of Batman's utility belt

T-SQL Tuesday #143: My favorite short scripts

October 12, 2021 Andy 2

For this month’s T-SQL Tuesday, John McCormack (blog|twitter) asks us: “What are your go-to short, handy scripts”? I’ve got so many handy dandy scripts, it was hard to choose. Where to start? I have so many go-to scripts that are short, amazing, and I use … [Read More]

What time is it in Oz?

October 5, 2021 Andy 1

There was a recent post on Database Administrators, where there was some confusion over Daylight Saving Time(DST) in Australian timezones. Let’s be honest though–timezones are confusing, especially when DST comes into play. Arizona Time doesn’t observe Daylight Saving Time, so sometimes it’s the same as … [Read More]

Stop using sp_hexadecimal & sp_help_revlogin

July 6, 2021 Andy 2

Since I started at Stack Overflow, I’ve had the chance to see some of the interesting challenges with running our databases at our scale. My coworker Taryn Pratt (blog|twitter) recently blogged about fighting with deadlocks related to Stack Overflow for Teams. Lots of logins Taryn … [Read More]

FAQs about the dissolution of PASS

December 28, 2020 Andy 2

In my prior post, I talked about how all signs pointed to it being Closing Time for PASS. Since then, PASS has announced the organization will “cease its operations and pursue dissolution.” TL;DR; The short version is that on 15 January, 2021, PASS will shut … [Read More]

Closing Time

December 8, 2020 Andy 1

This year, I’ve written a couple of critical posts targeted at PASS. If you follow me on Twitter, you know I’ve been critical there, too. Last week, the PASS Board of Directors had their December meeting. Coming out of that meeting, Mindy Curnutt (blog|twitter) resigned … [Read More]