It’s a holiday in the US, though I’m in the UK, having arrived this morning and heading to work. I’ve got a long day ahead, and a long week as I spend a few days here and then head home on Thursday.
In the meantime, you can get re-read Representative Data Challenges. I wish I’d talked more about this, especially the idea that so many bugs in software systems are data related, because we haven’t tested on representative data.
It’s hard to believe I wrote this in 2015. I’d have thought that it was a topic I would have covered earlier than that. Looking back, I think knowing how to use a tally or numbers table is a core SQL skill.
Still on vacation, but re-read The Tally Table and see what you think.
It’s the day before Christmas in the US and I’m on vacation. Hopefully relaxed and not trying to get anything done at the last minute.
In any case, I reached back in the archive. I wrote The DBA’s Twelve Days of Christmas a long time ago, my attempt at holiday humor. I did a few of these, but I always remember Phil Factor (Andrew Clarke) stopping me on one of my trips to the UK and telling me how he enjoyed my holiday attempts.
Enjoy, Happy Holidays, and Merry Christmas.
I’m using up some vacation I have this month, so I’m taking a break and trying to catch up on some ranch chores. While I’m braving the cold, and likely cutting some pasture grass, you get a republish.
I asked Your Area of Expertise about back in 2016. I found it interesting to re-read, and I wonder if you will, too.
Voice of the DBA 