Things I Learned in 2014

2015 is here!
Last year I wrote about what I had learned in 2013, and I try to make it a...

Looking back on 2014

When a new year comes around it is always a great time to reflect on the previous year.

2014 was a...

T-SQL Tuesday #62 - Invitation to HealthySQL

Greetings ALL and Happy New Year 2015!  I wish everyone an excellent year ahead, and
that 2015 will bring peace and...

Table Variables, CTE and Temp Tables. Which one should I use?

There are several really good blogs that already exists that explain the differences between Table Variable, Common Table Expressions (CTE)...

Table Variables, CTE and Temp Tables. Which one should I use?

There are several really good blogs that already exists that explain the differences between Table Variable, Common Table Expressions (CTE)...

Las Vegas UG This week

What a fun week we have tuned up for the folks in Las Vegas.  It is the first full week of January and there is this huge convention going...

Las Vegas UG This week

What a fun week we have tuned up for the folks in Las Vegas.  It is the first full week...

"OR" pattern causing indexing scans in parameter based queries

#Tl;dr article (time constraints prevented me from reworking significantly)
An article on SQL-Server-pro was forwarded over to me to research by...

Case of the Mondays... causing me to randomly redefine the Scope of Global temp tables

Today, I was reminded that global temp tables scope lasts for the session, and doesn't last beyond that. The difference...

Beware of Login Issues for Privileged Accounts

In a recent post, I described an attack against a privileged account using a simple SQL Injection technique of updating...