Confusion over MS Terms Recently, I was working with a gentleman in our IT department and we were discussing adding redundancy to a couple of SQL Servers that were used for web apps. Turns out, VM...

It’s Thanksgiving Day and before we know it, Christmas and the New Year will be upon us. 2018 hasn’t worked out as I planned. In fact, 2018 has been a difficult year for me personally. The first h...

The Office is pissing me off I have worked in an office environment for a long time. Going on twenty years in fact. I have worked in a number of different types of environments, but cubicles have ...

Introduction to Postgres Failovers This week I got asked to help a developer figure out why a failover wasn’t working on a Postgres cluster. Interesting enough I guess. Especially because I don’t ...

I came across an article on SQL Server Central written by Claudio Silva (blog/twitter) discussing that you can’t do arithmetic operations on DateTime2 like you can with DateTime. For example: Old...

Future of the DBA Steve Jones (blog/twitter) wrote a blog post talking about the death of the Database Administrator. Mind you, he was talking about the title of DBA, not the actual job of being a...

The 101st addition to the SQL monthly blog party is being hosted by Jens Vestergaard (b/t). For the topic this month, Jens has asked which tools are essential to our daily job. Or rather, which t...

I have recently been working on tuning a job that purges data out of various tables that are older than 13 months using GetDate(). Pretty straight forward right? Well originally the job consisted o...

The non popular view I had a flash of brilliance this week, and that’s a rare thing for me. I came to an understanding with myself that I can’t solve all the world’s problems, most people disagree...

This month’s blog topic for TSQL Tuesday is learning goals in 2018 and is being hosted by Mala Mahadevan (blog/twitter). Mala has challenged the SQL community to list out specific learning plans ...