Data & Backup Compression in SQL Server 2008

The new compression features built into the Enterprise Edition of SQL Server 2008 should use less disk space and, perhaps even more important, speed up your system because of reduced disk IO.
In this session we will :
  • Take a look behind the scenes to see how it works.
  • Investigate what commands / tools we can use to set it up and maintain it.
  • Look into some examples of my own day to day experience that I collected so far.
I aim to give an overview of both data compression and backup compression AND some Lessons Learned.
Presented by Andre Kamman at SQLBits V
  • Downloads
    Slide deck available Slide Deck 171 KB
    Video available WMV Video 118 MB
  • SpeakerBIO
    André is a DBA and SQL Server Solutions architecht for He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML), and even implementing PDW. 
    André is a Data Platform MPV, Dutch PASS Chapter Leader and organiser of SQL Saturday Holland
  • Video