Thank you to our sponsors




All 24 Hours of PASS registrants will automatically become PASS members. (membership is free!)





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)

Session Details

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! 

Check out the speaker lineup!



Copyright 2013 by PASS | Terms Of Use | Privacy Statement | Login