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

Good comments Steve.  I'd say that they worst scenario I was in where I really had to muddle through was to support an antiquated phone system.  It was a proprietary...

I have to agree with Jeff Moden on the need for better T-SQL skills especially to think and work in sets of data -- not in a procedural fashion.  I'm...