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]

Thirsty Thursday – Essential bar equipment

April 16, 2020 Andy 1

I’m writing this post during the Coronavirus pandemic. Billions of people across the globe are isolating in their homes. Folks have started exploring new hobbies and interests as a way to pass the time and to keep their mind sharp. Folks are depending heavily on … [Read More]

Redgate Streamed

April 9, 2020 Andy 0

Last week, I had the pleasure of participating in Redgate Streamed, a three-day virtual conference organized by my friends at Redgate. My session was Shortcuts from an impatient DBA–discussing a bunch of Management Studio tips & tricks for data professionals. The virtual conference was free … [Read More]