Microsoft SQL Server Parallel Data Warehouse (PDW) Explained

Microsoft SQL Server Parallel Data Warehouse (PDW), formally called by its code name “Project Madison”, is an edition of Microsoft’s SQL Server...

Microsoft Small Basic

This is a bit off-topic, but I wanted to mention a great tool for beginners to learn how to program. ...

Tracking down KPI error in PerformancePoint

On a few occasions, I have opened up my PerformancePoint scorecard on SharePoint to see an error staring at me:

So...

Methods for populating a data warehouse

Source tables change over time. A data mart or data warehouse that is based on those tables needs to reflect these...

Microsoft SharePoint Online

Microsoft SharePoint Online is a cloud-based service that is part of the recently released Microsoft Office 365.  For those of us...

Using SSIS lookup transformation editor with millions of rows

If you are using a SSIS lookup transformation editor and the reference dataset is large (millions of rows) and you...

SSAS Maestro Program (or SQL BI MCM)

There is a very interesting new Microsoft program that started back in January, called the SSAS Maestro Program.  It is a five-day,...

Product Guide for SQL Server “Denali” released

Released today, the SQL Server code name ‘Denali’ Community Technical Preview 3 (CTP3) Product Guide download contains the latest datasheets, white...

SQL Server “Denali”: Distributed Replay

Replaying multiple threads of a captured trace in SQL Profiler is difficult, and you are limited to replaying the workload from...

Tools to make creating MDX much easier

For those of you who use MDX, I’m sure you share my opinion that MDX is a lot harder to...