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

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

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

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

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

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

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

Retrieving Deadlock Graphs with Event Notification

Checkout my article (i.e. Retrieving Deadlock Graphs with Event Notification) that is published on SSWUG.org. This article shows the steps...

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