Next Meeting: Thu, Sep 18 2014
18 SEP 2014 NTSSUG Meeting
6:00 - 6:20 - Welcome, Announcements & Food
6:20 - 7:20 - Considerations for Clustered Columnstore Index Workloads by Fany Vargas
7:30 - 8:30 - Trimming Indexes Getting Your Database In Shape by Bradley Ball
8:30 - 8:45 - Raffle and closing
Event Time : Thu, Sep 18 2014 18:00 - 21:00 Central Daylight Time
Your Local Time: Thu, Sep 18 2014 23:00 - 02:00
Microsoft Building LC-1
7000 North Highway 161
Considerations for Clustered Columnstore Index Workloads
Fany Vargas, Sr. Premier Field Engineer (Dedicated Support) Microsoft
This session will introduce you to SQL 2014 Clustered Columnstore Indexes and how they can help you optimize your data warehouse workloads. Topics of discussion will include an architecture overview, and CCI creation and usage guidelines. Specifically, you will learn what to look out for when testing your first CCI workloads.
Fany Vargas is a Sr. Premier Field Engineer (Dedicated Support) at Microsoft. She has worked in various roles within the Microsoft SQL services and support teams throughout the past 11+ years - ranging from Support Engineer, Technical Lead, Support Escalation Engineer, and Premier Field Engineer. She graduated with a bachelor’s degree in Computer Science from Florida International University in 2002 and currently holds the MCSE: Data Platform (SQL 2012) certification.
Trimming Indexes Getting Your Database In Shape
Bradley Ball , Data Platform Management Lead Pragmatic Works
Indexes are a wonderful thing. We should be using them, and we should be maintaining them. But over time our production databases start to look a little pudgy around the mid-section. Maybe they are a little bloated with Unused Indexes, maybe they have Duplicate Indexes, and possibly even Reverse Indexes. The first step to fixing these problems it so see if you have them, and if you do the second is to set about fixing them. You could be costing yourself CPU cycles, I/Op’s, and space and never even know it.
About Bradley :
Bradley Ball is a SQL MCITP with almost 15 years of IT experience. Bradley spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office Of the President of the United States. Currently the Data Platform Management Lead with Pragmatic Works and a Microsoft VTSP. He has presented at SQL Saturdays, SQL Server User Groups, SQL Rally, DevConnections, SQL Live 360, and the PASS Summit. Bradley can be found blogging on http://www.SQLBalls.com