Insert Unknown Row to Dimension Table

When building a warehouse there is a common practice of adding an Unknown row to the Dimension tables.  For me,...

Hawaii is Not Prometric Microsoft Certification Test Friendly

While I was at TechEd last week, I got a 50% off Microsoft Certification test voucher that expires on June...

Building A Remote Desktop Manager Connection List

Remote Desktop Connection Manager or RDCMan is a free download from Microsoft for managing multiple remote desktop connections. The functionality...

Sarasota SQL Server Users Group

Tonight I’m presenting for the Sarasota SQL Server Users Group. If you’re interested in attending, you can join in using...

The Value of an Artist

A short while ago someone complained that some of the headlines on SSC were deceiving in terms of what they...

Teaching ICT 4462 – Transact SQL Programming at Denver University, University College

I will be teaching a special five week version of ICT 4462 – Transact SQL Programming at Denver University, University College...

DBA Hell

On the first day of DBA hell, the server gave to me

A database with damaged system tables and no good...

Virtualizing Servers in Production

The company where I work has been using virtualization in development, QA, testing, etc., for many years now. We have...

Daily SQL Server 2008 New Features – Day 23

Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...

SQL Server XML Schemas

Ever been curious about the schema of , say an SSRS rdl file ?  How about the execution plan ?
Not only should...