I will be presenting the session “Building an Effective Data Warehouse Architecture” today at 11am CST for the PASS DBA Fundamentals Virtual Chapter. Info about watching the presentation online is here, and the abstract for my session is below. I hope you can make it!
Building an Effective Data Warehouse Architecture
You’re a DBA and your boss asks you to determine if a data warehouse would help the company. So many questions pop into your head: Why use a data warehouse? What is the best methodology to use when creating a data warehouse? Should I use a normalized or dimensional approach? What is the difference between the Kimball and Inmon methodologies? Does the new Tabular model in SQL Server 2012 change things? What is the difference between a data warehouse and a data mart? Is there any hardware I can purchase that is optimized for a data warehouse? What if I have a ton of data? During this session James will help you to answer these questions so your response to your boss will provoke amazement and lead to a big raise. Or at least help to lead you down the correct path!