What's Happening?

Next Meeting: Fri, Oct 11 2013

October ABQSQL Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: None

Summit 2013 Preview

When

iCal
UTC : Fri, Oct 11 2013 17:30 - 19:30
Event Time : Fri, Oct 11 2013 11:30 - 13:30 Mountain Daylight Time
Your Local Time: Fri, Oct 11 2013 17:30 - 19:30

Where

6700 Jefferson Street
Albuquerque , New Mexico

Direction: None

Featured Presentation

Accelerate Database Performance Through Data Compression

Speaker: Joseph D'Antoni, Principal Consultant Denny Cherry and Associates

Summary: 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.

About Joseph: Joseph D'Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry & Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. He holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book "Introducing SQL Server 2016”.

Attachments

Supplementary Materials

The following event attachments are available to you:

Please be sure to check out our Meetup.com page, and RSVP there for our monthly meetings.

PASS membership is not a prerequisite to attend this or any other monthly meeting of the Albuquerque SQL Users Group, however, you can enjoy many benefits of being a member by signing up for a FREE PASS membership at http://www.sqlpass.org/.