Failure is always an option

January 15, 2019 Andy 1

Bloggers spend a lot of time writing about our successes, but we’re human and we make mistakes, too. This post is a chance to share one of my memorable failures.

Using PowerShell to tidy up CSV files

December 28, 2018 Andy 0

I was recently fussing with a CSV file that had an inconsistent number of columns. UGH. There was a bunch of historical data that had 4 columns, and then more recent data had a new attribute added with 5 columns. I spent a few minutes … [Read More]

Working from home: Home office tour

December 18, 2018 Andy 4

About two years ago, I moved my home office down into the basement at our house. Earlier this year, I started a new job at SentryOne, and work from home full time. This means I spend more (awake) time in my office than any other room in the house. I thought I’d take everyone through a guided tour of my home office.

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 4

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 2

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.