Diagram of Batman's utility belt

T-SQL Tuesday #143: My favorite short scripts

October 12, 2021 Andy 0

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]

Microsoft Azure hack for social justice

October 4, 2020 Andy 0

Microsoft is going to be running a virtual hackathon, running from October 12 through November 20. The theme of the hack will be to use Microsoft Azure to address some social justice issue. I’m thrilled to be joining the judging panel for this event, which … [Read More]

What’s important in a code of conduct?

June 26, 2020 Andy 3

Earlier this week, I published a post about a proposed Tech Community Equality Index, and used it to grade the largest organization in the data community, PASS. One of the areas where I was critical of PASS is that their Anti-Harassment Policy (AHP) is not … [Read More]