Vancouver SQL Server User Group

JANUARY 2010 MEETING

DATE: Thursday, January 21st, 2010

AGENDA:
5:30pm - Pizza and Socializing

6:00pm - Socializing

6:30pm - Presentation and Prizes...

8:00pm - Wrap up

LOCATION: Sierra Systems - 25th Floor - 1177 West Hastings St Vancouver BC

LIVEMEETING:

https://www.livemeeting.com/cc/usergroups/join?id=KST2FN&role=attend

http://www.clicktoattend.com/?id=144585

Presented by: Todd McDermid

About Todd

BSc, MCSD.Net, MCTS (SQL 08 BI), MVP 20 years in Software Development and Databases. Currently part of a very lean (and getting leaner) IT department in a building products distributor. Coordinator of the Kimball Method SSIS Slowly Changing Dimension Component project on CodePlex (www.codeplex.com/kimballscd). Moderator on the Microsoft SSIS Forums..

How A Data Warehouse is Different Than Your Regular Database

If you have (or are starting) a Data Warehousing project, there are a few things you need to know about how to treat your Data Warehouse – and how it will treat you. If you try to apply OLTP standards and practices to it, you’re going to end up hating each other. To start, I’ll explain what a Data Warehouse is, how it’s structured fundamentally differently than your “regular” databases, and why that structure is appropriate. I’ll cover the Microsoft BI stack, so we all know what parts of SQL Server can get involved in the handling of the data – or how to live without them at all. Lastly, we’ll build off of that platform to talk about what kind of queries and load you’ll get on a Data Warehouse, and how to think differently about tuning one.

SPONSORS