Performance Tuning SQL Server Data Warehouse Database

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: