|Title:||PASS Performance Virtual Chapter
|Start:||9/27/2012 2:00:00 PM
|End:||9/27/2012 3:00:00 PM
Our speaker this month is Jeff Renz. Jeff will be presenting “I feel the need…the need for speed”.
Abstract: Every project that I worked on I’ve always felt that users want everything to be fast…really fast. Since we tend to be constrained by time and money we want to best leverage the tools and techniques that make the project successful….”fast”. With the introduction of SQL 2012 we need to understand what we get by implementing a SQL Server 2012 solution. That led me to these questions:
Is SQL Server 2012 really faster and more efficient then SQL Server 2008 R2 when I load data and query data? Does a SQL Server 20012 Tabular model perform the same as a SQL 2012 Dimensional Model? Are there really any performance differences when loading data using SSIS 2012 compared to other data loading approaches? Does SQL Server 2012 offer me anything specific that would cause me to change how I would design my database to take advantage of new performance features? Find out the answers to these questions and more in my session.
BIO: Jeff Renz has developed databases using SQL Server for over 13 years, primarily focused on global manufacturing and supply chain data collection and reporting. In the past 2 years he has implemented two large data warehouses using data vault architecture for Abound Solar. Jeff has a Bachelors degree in computer science and a Masters degree in operations research from the Colorado School of Mines. Jeff is a Certified Data Vault Data Modeler by the Genesee Academy.