I think it's funny how all of these "NoSQL" environments now support some flavor of SQL. In reality, they meant to be non-relational.

I've seen many projects implemented in...

As previously mentioned, an ORM is a tool that when used properly does what is expected. Unfortunately, it's the mis-use of an ORM where I have encountered more performance issues...

I agree with John Rees in that there should be an option to turn it on so I can ensure that my developers use it consistently like I do. I...

I have to agree with Steve on this: “I'll admit that I often prefer to transform data inside of a SQL Server target, OLTP or DW database. The reason is...

Funny, I was actually glad to get this one wrong!  I had always assumed that there was no order of logical precedence and therefore always preached using parenthesis correctly.  I...

I totally believe in paying it forward.  Because of a presentation I saw in a user group, it open my eyes to a whole new world.  Actually, there wasn't a...

Ignoring the missing OVER() clause, this is still a good example.  I have seen way too many situations where DISTINCT was thrown into a query without regard to the consequences. ...