Yesterday, I talked about batching deletes, and the day before I talked about how much I like to delete data, and why it’s necessary to do it, despite being a data pack rat. Today, let’s look at just one scenario, and how I like to handle it. In my experience, this is one of the most common purge requirements (and probably the easiest), so first, let’s look at the business requirements.
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.
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.
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]
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.
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]
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.
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]
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
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]