I’m in a book! Data Professionals at Work

October 13, 2018 Andy 0

Back in January, Malathi Mahadevan asked me if I would participate in a book she was working on. The book, “Data Professionals At Work”, is part of Apress Media’s “…At Work” series, an anthology of interviews with Microsoft-focused data professionals

LGBTQ Meetup at PASS Summit 2018

October 8, 2018 Andy 5

In 2016, I organized an (unofficial) PASS Summit LGBT Meetup. It was a bit of a last-minute party, and more than once I found myself saying, “Worst case scenario, I’ll end up having a chill cocktail party with some friends.” Turns out, I under estimated … [Read More]

Who are the extra special people in your life?

September 21, 2018 Andy 4

On my flight home from a conference in Europe, I found myself watching a documentary on Fred Rogers. This prompted me to reflect on some of the extra special people in my life that have helped me get where I am.

Performance Myths: The query result cache

July 23, 2018 Andy 0

I was recently doing a training session when a developer commented that it was OK to run an expensive query twice because on the second execution, SQL Server would use the “results cache” and be “practically free”. It’s not the first time I’ve heard someone refer to a “results cache” in SQL Server. If you don’t know better, you might think SQL Server has a “results cache” because the second execution of a query is often faster.

TSQL Tuesday #104: dbo.Check_FileSize

July 9, 2018 Andy 2

It’s been a little bit since the last T-SQL Tuesday I joined, when I blogged about religion & politics. This month, I answer Bert Wagner’s call to blog about code I would hate to live without