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 the SQL Server Evangelist & lead consultant @ Northdoor PLC (MSFT Data Platform Gold partner), previous roles @ ABN AMRO, Accenture, ASOS, BBC, Confio Software with 15+ years in SQL Server roles
    Presented 120+ events, including 50 PASS Summit/24HOP/Rally/SQL Saturday, 20 European events (12 countries), 50 + UK (SQLBits, SQLRelay) 
    Leader of PASS London (UK) & Professional Development VC, Melissa Data MVP (2015)

    SQL Cruise Technical Lead, Likes Guinness, Loves Whisky, Dancing
  • Video
    The video is not available to view online.