Home
sql-mac
Cancel

Microsoft marketing is making a mess

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...

End of 2018 - Review

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...

Office Conditions

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 ...

Postgres Failovers

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 ...

DateTime2 not like DateTime

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...

DBAs and the future

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...

tsql2sday 101 - Tools I have forgotten

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...

Using GetDate()

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...

Different Perspective

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...

tsql2sday 97 - Learning in 2018

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 ...