Different techniques to identify blocking in SQL Server

SQL Server is able to service requests from a large number of concurrent users. When SQL Server is servicing requests...

How To Prevent SELECT * The Evil Way

SELECT * FROM…when administrators see that from developer code, we generally tend to cringe. Why? In a nutshell, it’s terrible on...

Licensing SQL Server Dev/Test Environments

I was recently at a client site and we started talking about SQL Server licensing, specifically for their development and...

Perform a Rolling Upgrade to SQL Server 2008 R2 SP2 in a Database Mirroring Scenario

Yesterday evening (European Time zone) Microsoft has released the SP2 for SQL Server
2008 R2. You can download the Service Pack...

SQL Saturday #150 Baton Rouge 2012

Baton Rouge SQL Saturday is Saturday, August 4!

 We expect ~400 attendees at the brand new LSU Business Education Centre of...

SQL Server 2008 R2 – Service Pack 2 now available

SQL Server Team, has announced the Service Packe 2 available for the SQL Server 2008 R2.
All the details are here 
Stay...

SSRS – Using Lookup Function for Multiple Column Join

When SQL Server 2008 R2 was released several new Reporting Services expressions were made available that would help join multiple...

A Quick Guide to Expanding Database Files and IFI

This is a topic that’s been well covered, but in the interest of spreading good database practices, here’s a very...

Capacity considerations while moving SQL workloads to a Virtual world !

One of the most basic capacity considerations involved while planning to move SQL workloads to a virtual environment is to understand the...

Joining on NULLs

A problem I see on a fairly regular basis is that of dealing with NULL values.  Specifically here, where we...