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.
Presented by Neil Hambly at SQLBits X
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO

    Neil Hambly is a SQL veteran with over 15 years’ expertise in SQL Server from Version 6.5 through to the very latest 2012 edition. Neil has held numerous DB roles at major organizations such as BBC, ABN AMRO, ACCENTURE, alongside a number of smaller companies, with prior roles as both a DBA ,Developer & Architect, 

    He is a SQL Server Technology Evangelist @ Northdoor PLC

    The Leader of both the PASS London and Virtual Professional Development Chapters

    Neil is often found presenting @ international and domestic SQL events
  • Video
    The video is not available to view online.