Purging data with batched deletes
Yesterday, I wrote about the importance of planning your data purges. Today, let’s look at the simplest requirement for purging data: Keep data for X days after it’s created.
The thrill of purging old data
DBAs & Data professionals tend to be digital packrats. My personal Google Drive is filled with random files that I refused to part with–even though it’s of questionable value. I lament that I do not have a copy of every paper I typed in high school or college–and I envy those who do. You never know when you’ll need notes from that meeting 6 years ago, or when you’ll need that funny GIF you created for an inside joke you no longer remember.
SQL: A love story
I’m a college drop-out. When I was trying to figure out my life, a friend (my brother’s ex) referred me to a software company where she was working–I got the job because I was (a) breathing, (b) eager to do the job, and (c) cheap. … [Read More]
Failure is always an option
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
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
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.
Following up on the LGBTQ Meetup at PASS Summit
It’s been almost two weeks since the LGBTQ Meetup that I organized at PASS Summit, and I wanted to offer a bit of follow-up and commentary on the event. Why did I wait two weeks before writing this follow-up? Well, tomorrow is American Thanksgiving, so … [Read More]
I’m in a book! Data Professionals at Work
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
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?
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.
