As one door closes another one opens

Normally I try and keep the things that happen at work separate from my blog, however it’s been an interesting...

Color Expressions in SSAS Calculations

Color expressions in SSAS allow you to build an MDX expression to control the color of text displayed in a...

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