What the Exec?

I’ve been working with SQL Server for 10 years and have worked in production with versions 6.5 – 2005 and used...

IN and NOT IN

One of the most common mistakes made in T-SQL is thinking that these behave identically.  I've personally opened up a...

The Black Art of PowerShell V2 Version Numbers

Last week while helping someone in the SQLPSX forums having an issue importing modules I suspected they had a CTP...

SQL Search 1.0 Beta Available

Red Gate Software has released the 1.0 beta version of SQL Search, a new free SSMS add-in that allows you...

Wildcards in WHERE Clauses

This is just a very short post regarding the use of wildcards in a WHERE Clause

It is possible that the...

Identity Values – Dropouts and Spaces

Identity values are very useful, but there can be misconceptions about the way in which they work. One of the...

SQL Saturday #34

The event is this Saturday. Take a look at our sponsors, speakers and the program. It’s going to be a...

Speaking at the Baltimore SQL Server User Group

On Monday, the first of February, 2010, I will be speaking at the Baltimore SQL Server User Group meeting at...

Cleaning up sys.dm_exec_cached_plans

Following on from my previous post in which I noticed that SQLServer itself was artificially bloating sys.dm_exec_cached_plans, the next obvious...

Lenovo W510

I finally ordered a new laptop, a Lenovo W510, that caught my eye. I was thinking the T series 510,...