4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

Accelerate Database Performance Through Data Compression

Much like the cars of the 1970s sacrificed gas mileage for better performance, database technology has also made its share of sacrifices for efficiency. Fortunately, times have changed significantly since then. Just as adding a turbocharger to a car delivers more power while saving fuel, the addition of compression to a database accelerates read performance while saving disk space.

Come learn how, why, and when compression is the solution to your database performance problems. This session will discuss the basics of how compression and deduplication reduce your data volume. We’ll review the three different types of compression in SQL Server 2012, including the overhead and benefits of each and the situations for which each is appropriate, and examine the special type of compression used for columnstore indexes to help your data warehouse queries fly. As with turbo, data compression also has drawbacks, which we’ll cover as well.
Presented by Joey D'Antoni at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Joey D'Antoni is a Solutions Architect at Anexinet for SQL Server and Big Data platforms with a background as production DBA and Infrastructure Architect for Fortune 500 firms. His specialties include infrastructure architecture and design, disaster recovery and hybrid cloud scenarios. Joey is a speaker on many IT topics such as Cloud Computing, Big Data and a number of topics on SQL Server. He holds a MBA from North Carolina State University, and is MSCE for Business Intelligence.
    http://joedantoni.wordpress.com https://www.sqlbits.com/Profile/SpeakerProfile.aspx
  • Video
    The video is not available to view online.