18 SEP 2014 NTSSUG Meeting Attendance
Will you be attending 18 SEP 2014 NTSSUG Meeting ?

Submit Survey  View Results
 Next Meeting

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

When

iCal
Event Time : Thu, Sep 18 2014 18:00 - 21:00 Central Daylight Time
Your Local Time: Thu, Sep 18 2014 23:00 - 02:00

Where

Microsoft Building LC-1
7000 North Highway 161
Irving, Texas

Direction: None

Featured Presentation

Considerations for Clustered Columnstore Index Workloads

Speaker: Fany Vargas, Sr. Premier Field Engineer (Dedicated Support) Microsoft

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

About Fany: 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

Speaker: Bradley Ball , Data Platform Management Lead Pragmatic Works

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

Attachments