Tech Community Equality Index

June 24, 2020 Andy 1

Over the last weeks & months, I’ve had an increasing number of conversations with folks on the topics of diversity, inclusion, equality, and justice. These discussions we have with coworkers, members of the data community, family and friends are all valuable, and help us look … [Read More]

Hi, I’m Andy. My pronouns are he/him.

June 23, 2020 Andy 1

Lots of folks want to be an ally to the LGBTQ community, but don’t know where to start. One great way to be an ally is relatively low-friction. List your pronouns. Everywhere. Put your pronouns in your social media profile & your email signature. Edit … [Read More]

Racism is our problem to solve

June 9, 2020 Andy 2

This month’s T-SQL Tuesday is hosted by Kenneth Fisher (blog|twitter). Kenneth asked us to talk about any non-SQL tips and tricks we have. I’m going to take the moment to give some tips on how (and why) you can help fight bigotry, racism, and racial injustice.

Pride is a riot

June 8, 2020 Andy 2

Last year was the 50th anniversary of the Stonewall riots, which mark the start of the modern LGBTQ rights movement in the US. In the subsequent half century, the queer community has made significant strides in our march towards equality. Sodomy laws were struck down … [Read More]

Stop trying to shrink tempdb files

April 28, 2020 Andy 1

Stop shrinking your tempdb data files I recently wrote about growing, shrinking, and removing tempdb files. In that article I explained that SQL Server won’t move a page that contains an internal worktable object, and thus trying to shrink tempdb files can be futile. Today, … [Read More]