The Predictioneer

I’m not sure how this book got on my radar, but it turned out to be fairly interesting. It’s written...

SQLSaturday #40 Announced

SQLSaturday #40 will be held July 31st, 2010 in Miramar, FL. This is the second annual SQLSaturday organized by Scott...

SQLSaturday #39 Announced

SQLSaturday #39 will be held April 24, 2010 and is being coordinated by Melissa Demsak and others from the NJ...

The Little Stick

In the end, that was what made the difference. I was typing along one night on my spare Acer and...

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