Free

Demystifying Data Compression

Event Information

Share this event

Date and Time

Location

Location

Microsoft Canada

110 - 9 Ave SW

Seventh Floor

Calgary, AB T2P 1M9

Canada

View Map

Event description

Description

SQL Server 2016 SP1 and newer makes data compression available in all editions. Data compression can reduce storage costs, and provide a performance boost—and now compression is available without the added cost of Enterprise Edition. Whether you are a developer or a DBA, it’s important to know how to use compression to save money and improve speed.

Come learn about how data compression actually works, the differences between ROW and PAGE compression, and learn how to pick the best compression level for your data. This session will cover the details of the compression algorithms, and the costs and benefits associated with each type of compression.

By the end of this session, you’ll have a better idea of how the different compression algorithms work, when compression is the right solution, as well as what type of compression to use.

Agenda

4:30 pm - 4:45 pm MST - Food, drinks and networking
4:45 pm - 5:00 pm MST - Sponsor presentation
5:00 pm - 6:30 pm MST - Feature session with Andy Mallon

Speaker:

Andy Mallon is a Data Platform MVP and SQL Server DBA who has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. He has over 13 years of experience supporting high-volume, highly-available OLTP environments with demanding performance needs. Andy blogs at am2.co, as well as an occasional guest post at sqlperformance.com.

Andy is also co-organizer of SQL Saturday events in Boston, and the founder of the BostonSQL User Group.

Sponsor:

Born SQL


Share with friends

Date and Time

Location

Microsoft Canada

110 - 9 Ave SW

Seventh Floor

Calgary, AB T2P 1M9

Canada

View Map

Save This Event

Event Saved