Archive for December, 2012

Performance Tuning SQL Server Data Warehouse Database

December 13, 2012

I was recently invited to give presentation about performance tuning SQL Data Warehouse databses  to the The Southeast Michigan SQL Server User Group. Blue Granite was kind enough to pay for my travel to the user group.

I don’t usually give many presentations. I am more of a heads down coder by heart, but I love sharing my ideas and experience with others! Let me know what you think.

My presentation is titled Data Warehousing from the Trenches. It is a  presentation of lessons learn based on my recent involvement with Microsoft’s Massive Parallel Processing (MPP) Appliance called Parallel Data Warehouse (PDW). In it I also cover some of the new features of SQL Server 2012 like ColumnStore Indexes and how they are going to greatly enhance SQL Serve’s Data Warehouse scalability and performance.

Presentation PowerPoint Slide Deck

Note: The PDW projects that I have worked on to date where as an Independent Contractor with B.I. Voyage. My Linked-in Profile provides an over view of my work experience.