SQL Server Default Trace

The default trace in SQL Server is something I have been experimenting with lately. It is a feature included in...

“Building a Better Blog” with Steve Jones

I recently watched  Steve Jones’ (Blog | Twitter) "Building a better blog" presentation from the 24 hours of PASS virtual conference...

Professional Association of SQL Server (PASS)

I recently discovered the Professional Association of SQL Server (PASS) virtual chapters. For those of you who struggle to make...

SEO my SQL Server Blog

I was going to spend today finishing off some SQL Server related blog posts, I currently have a list of...

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

XML Index - ALTER INDEX with REBUILD Issue

I run into a small issue at the end last week, a CHECKDB job was reporting corruption on one of...

Instant File Initialisation

I have been reading up on instant file initialization and I have read a couple of good blog posts by...

DDL Triggers

We had a request from a developer who wanted to access data from a source database and another database on...

SQL Server 2008 R2 - Release May2010

SQL Server 2008 R2 now has a release date...May 2010.

Check out the microsoft site for more details...link to follow

SQL Server Resource Governor

I didn’t know this bit Resource Governor in SQL Server 2008 is only available in Enterprise edition