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

Handling Escape Sequences in SSIS Expression String Literals

The SSIS expression language is a powerful tool for a developer that gives you one method of making a package...

Handling Escape Sequences in SSIS Expression String Literals

The SSIS expression language is a powerful tool for a developer that gives you one method of making a package...

SQLFool IDX Defrag Scripts

I just found out that Michelle Ufford (@sqlfool) has updated her Index Defrag scripts.  Right now she is looking for...