SQL Server 2008 R2 to be Available in May

This past Tuesday, Microsoft officially announced that SQL Server 2008 R2 will be available in May 2010. See the announcement...

SQLSaturday #32 – Tampa

Just a reminder that SQLSaturday #32 – Tampa is taking place this weekend (January 23rd).  This will be my 5th SQLSaturday...

Using sp_ExecuteSql to Run Dynamic SQL

Introduction
Lately it seems like I am being bombarded by Dynamic SQL and people who insist it is the only way...

Can query performance be dependent on the client?

This question sounds really easy! The query performance depends essentially on the execution plan, which in its turn isn’t dependent...

Collaboration Patterns – Part 2

Recently I caught a few minutes of a CSPAN interview with Chief Justice John Roberts, part of a larger presentation...

DDL Triggers

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

Please Take the Time to Donate for Haiti

This morning, Haiti was shaken yet again by another aftershock of the recent devastating earthquake.  
 
The situation has become so dire...

Setting a Dedicated Login To Run DMV Queries in SQL Server 2005\2008

In order to run server scoped DMV queries, you must have VIEW SERVER STATE permission for the login you are...

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