Date:

Wednesday, May 22nd, 2013 5:30 PM

The Skinny on Data Compression
Whether your database is obese or just "big-boned" it can probably benefit in multiple ways from SQL Server's data compression feature. This session will arm you with the knowledge and understanding that can mean the difference between a successful deployment and wrecking your application's performance. First you will learn how compression works from an internals standpoint, which will be valuable for understanding the scenarios where compression provides the biggest advantage. You will also take home an understanding on when and where to deploy compression to ensure maximum performance based on real-world experience. Your data is growing but your budget probably isn't - learn how to take charge with data compression!

Bob Pusateri is a DBA in the healthcare data warehouse industry with 6 years experience on SQL Server. His interests involve internals, performance optimization and VLDBs. He is an active member of both Chicago-area chapters of PASS, a community speaker, and maintains a web presence through both twitter and his blog.

Flying Cars—Excel Pros in the BI Game
Microsoft wants to bring business intelligence to the masses; and that means Excel. And working with large datasets in Excel will mean PowerPivot. The SQL professional and Excel professional will start to speak a common language. And that language is DAX. In this presentation, Greg will share some tips and tricks regarding DAX that both Excel professional and the SQL professional should find useful.

 Greg Kramer is an Accounting and Finance professional who has taken a turn to the world of data and SQL Server via Excel, currently employed by CUNA Mutual Group as a Business Intelligence manager for the Finance group. Greg was a long-time Chicago resident recently transplanted to Madison Wi. with his wife Tracy and daughters Kate 8 and Brooke 6. Hobbies include working out and spending time with family.