Data Vault Data Warehouse Architecture
Data vault is a compelling architecture for an enterprise data warehouse using SQL Server 2012. A well designed data vault data warehouse facilitates fast, efficient and maintainable data integration across business systems. In this session I will review the basics about enterprise data warehouse design, introduce you to the data vault architecture and discuss how you can leverage new features of SQL Server 2012 help make your data warehouse solution provide maximum value to your users.
Jeff Renz has been working in the IT industry for 14 years, the last 10 of which has been focused on designing and implementing data collection and reporting solutions. He is currently working as a senior consultant for Statera on the Business Intelligence Solutions team.
SQL Tips and Tricks: BackupSet
Managing backups is a fundamental part of being a DBA. The great thing about SQL Server is that so much information is baked right into the product. This short presentation will dive into the specifics of the BackupSet table in MSDB and how we can leverage that information as part of our day to day jobs.
Mike Fal is a musician turned SQL Server DBA, with 10+ years of experience as a database administrator. He has worked for several different industries, including healthcare, software development, marketing, and manufacturing and has experience supporting databases from 1 GB to 4 TB in size. Mike received his a Bachelor's Degree from the University of Colorado at Boulder in 1996 and has been caught playing trombone in public on more than one occasion.
17:30 - 18:00 - Food / Socializing
18:00 - 18:15 - User Group Business
18:15 - 18:30 - Open Panel/Questions & Answers
18:30 - 19:00 - Warm-up presentation
19:00 - 20:00– Main presentation
Give Away / Wrap-Up to follow
Post-meeting networking at Darcy's DTC