Compression - Define your Strategy
The Enterprise only feature "Compression" can make a HUGE difference to your storage requirements and we will examine this feature in detail, integrate this into your strategies, finding objects which your should use this one - we will be using compression estimates along with index usage information, fill-factors to achieve a balanced strategy
This session will not only cover the core principles of SQL Server's data compression feature, how it functions, what options you can choose, and how it performs under differing workloads.
We will also look at how to integrate data compression into your current schema designs and the challenges you will likely encounter, examining the all-important performance aspects and the configuration changes to consider along with SKU editions requirements.
Neil Hambly
Neil Hambly is a Senior DBA @ Confio Software, having held various SQL Server roles during the last 14 years @ market leading companies (Accenture, ABN AMRO, BBC, iProfile, MDSL)
He has considerable Experience in SQL Server starting with version 6.5 through to the latest 2012 release. A regular International speaker @ SQL conference & User Group, he also leads the SQL London PASS Chapter (UK). Frequently found studying the inner workings of SQL Server, as well as an avid Tweeter @Neil_Hambly.