Stop using sp_hexadecimal & sp_help_revlogin
Replace sp_hexadecimal and sp_help_revlogin with a more maintainable way to script SQL Server logins.
Continue readingBrowse the archive
Automation
Code to purge data based on creation date
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, …
Continue reading
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.
Continue reading
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 …
Continue reading
Building a Twitter-bot RSS Aggregator
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: Dig through reviews to find an app that I think I will love. Come up with …
Continue reading