Virtual Labs - A Great Resource for SQL Server

I had someone send me a note recently asking some questions about how to get set up to work with...

What is Normalization in SQL ?

=> What is normalization ?
Defination :Normalization is the process of efficiently organizing data in a database. There are two goals of...

24 Hours of PASS coming over the next two days

Hey folks,
The 24 hours of PASS is coming very quickly.http://www.sqlpass.org/24hours/fall2010/. There are so many great sessions that I don’t know...

An impossible case

In a previous blog entry (Inconsistent NullIf behaviour), Jeff Moden and Dan Halliday(twitter) both made a very similar observation.
When executing...

Awards for SQL Heroism

Motivational time again!
Have you ever worked on a project where someone was seeking their moment in the sun for an...

Building your 1st Performance Point Dashboard in Sharepoint 2010

Hey there gang
The PASS BI Virtual Chapter is presenting some great stuff this fall. September 14th I’m doing a new session on...

Get ready for the Third Annual SW Florida .Net Code Camp!

Hey there database folks! Don’t be scared off by a little .NET. The SW Florida code camp is getting underway...

Idera SQL Tools – An evaluation (Part 2)

This is the 2nd in the series of evaluations I have carried out on Idera’s SQL Server Toolbox. The first...

Labor Day Bloopers

Happy Labor day to everyone. A day off for me, but I’m posting a few bloopers from the past couple...

Let’s get Dimensional – from Requirements to Dimensional Design

Hey folks!

You asked for it – so coming up on September 8th we’re doing a SQL Lunch that is going to...