Special Guest – Gareth Swanepoel

Sponsored By: Gravity IT Resources


Wednesday May 13, 2015 (6-8 PM)

Carl Desantis Building Room #4030

3301 College Avenue

Fort Lauderdale, Florida 33314

Parking Pass: Click Here

RSVP: Click Here

Feature Session:  SQL Server 2012 & 2014 Columnstore Indexes

Come and learn how the new SQL Server 2012 feature, ColumnStore Indexes, can parallelize your Data Warehouse aggregations. I will be doing a deep dive into the inner workings of ColumnStore indexes; how they work, key characteristics, do's and don'ts, restrictions, and more. We will dive into the Clustered ColumnStore indexes in SQL Server 2014, as well. If you are a production DBA who needs to find out more about some of the additional hot features that have been included with CSI's, like batch mode processing and data segments, then this session is for you. If you are a BI DBA or developer who needs to find out how CSI's can increase the performance of your aggregations and star-joins by up to 40 times, then this session is also for you.

Feature Speaker: Gareth Swanepoel

cid:part1.08050105.08020407@gmail.com Gareth Swanepoel is a sysadmin-turned-SQL Server DBA. He has been working in the IT industry doing support and administration for over 23 years. He enjoys solving the complex problems that his clients encounter when performance tuning SQL Server or when deploying SQL Server in data warehouse environments. He is originally from South Africa and is currently a consultant for Pragmatic Works in Jacksonville, Florida. He is an accomplished author and speaker. Current projects include various speaking engagements at user groups, SQL Saturdays, the PASS Summit and other technical conferences. He currently serves as one of the PASS Regional Mentors for the US SouthEast region.