Using Data Compression with SQL Server 2008 and 2008 R2
Return to Session Listings
Presenter: Maciej Pilecki, Project Botticelli
Session 10 (21:00 GMT on May 19)
When used properly, data compression can be a killer feature. It lets you store more data using less disk and memory space, improving cacheability of your data and limiting the number of I/O operations performed. This session looks into the details of data compression and backup compression as available in SQL Server 2008 as well as the Unicode compression available in SQL Server 2008 R2.
About the Speaker
Maciej Pilecki is a SQL Server MVP, MCT, and consultant with Project Botticelli. With many years of international experience in SQL Server database development, optimization, and troubleshooting, he spends most of his time traveling around the world advising customers on how to improve performance and reliability of their databases and sharing lessons learned with conference and user group audiences. His favorite topic are SQL Server database engine internals, including SQLOS, storage engine, and query optimizer, but he also ventures into business intelligence, especially data warehousing and data mining.
Maciej likes skiing with his son and trekking in the mountains in his spare time. He has recently climbed Lobuche East – a 21,000 foot mountain in Everest region of the Himalayas.
Register now for 24 Hours of PASS!