High-end storage is expensive, and SQL Server data compression can make your database smaller. So lets compress all the tables! No--unfortunately, it's not that easy. We'll talk about how data compression actually works, and the differences between ROW and PAGE compression. As part of this, we'll look at the costs and benefits associated with each type of compression. By the end of this session, you'll have a better idea of when compression is the right solution, as well as what type of compression to use.
Andy Mallon (http://www.linkedin.com/in/amtwo) (@amtwo (https://twitter.com/amtwo)) is a SQL Server DBA that has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. He has over 12 years of experience supporting high-volume, highly-available OLTP environments with demanding performance needs. Andy blogs at www.am2.co (http://www.am2.co/), is co-organizer of SQL Saturday Boston.
Lighting talk "Ownership Chaining" by Michael Kane (https://www.linkedin.com/in/michaeldakane).
Meeting Sponsored By: First Pro, Inc (http://www.firstproinc.com/index.aspx)