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

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

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

Lenovo W510

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

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

SQL Saturday #34

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

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

Another Keyboard Down

I don’t know if they’re making them cheaper and shoddier or what, but it seems that I’m going through a...

Database Normalization

Normalization :- Normalization can be defined as the process of organization the data to reduce the redundant table data to the...