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.
I’m a SQL Server consultant based in the Netherlands. I’m a SQL Server MVP and I’m the co-founder and current chairman of the Dutch PASS Chapter and a member of the volunteer team for the Dutch SQL Saturday’s. I’ve done a whole lot of pure DBA work managing 100′s of servers and learning something new every day.
These days I spend a lot of time on just a few servers containing some large databases and the better part of the day is spent with SSIS. In both roles I’ve been using Powershell a lot. I joke sometimes that I replaced myself with a powershell script when leaving the DBA role, but these days I automate so much that I have to watch myself and not actually do just that