Automation

Stop using sp_hexadecimal & sp_help_revlogin

July 6, 20218 min read

Replace sp_hexadecimal and sp_help_revlogin with a more maintainable way to script SQL Server logins.

Code to purge data based on creation date

April 4, 20196 min read

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, …

Databases

Purging data with batched deletes

April 3, 20196 min read

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.

Databases

The thrill of purging old data

April 2, 20195 min read

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 …

Databases

Building a Twitter-bot RSS Aggregator

January 11, 201710 min read

I hate RSS readers I love my new bot For some reason, about once a year, I go hunting for a new RSS reader so I can keep track of blogs that I like to read. It’s always the same process: