North Texas SQL Servers Users Group

Next Meeting

Thursday,

September

18

18 SEP 2014 NTSSUG Meeting

  • In-Person @ 7000 North Highway 161 Irving, Texas, United States (map)
  • 18:00 - 21:00 Central Daylight Time
  • Language: English

RSVP Here: None

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

Featured Presentation:

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.

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

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


Thank You to the 

PLATINUM

SPONSORS 

of our May 2018 

SQL Saturday!











Back to Top
cage-aids
cage-aids
cage-aids
cage-aids