North Texas SQL Servers Users Group

Next Meeting

Thursday,

January

15

15 JAN 2015 NTSSUG Meeting

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

RSVP Here: None

6:00 - 6:20 - Welcome, Announcements & Food

6:20 - 7:20 - The Ins & Outs of Indexes - Beginner Level by Mindy Curnutt

7:30 - 8:30 - Rev up data warehouse performance with SQL 2014 Columnstore indexes by Denzil Ribeiro

8:30 - 8:45 - Raffle and closing

Featured Presentation:

The Ins & Outs of Indexes - Beginner Level

Mindy Curnutt, Distinguished Engineer TMW Systems (a Trimble Company)

This course will focus on the fundamentals of strategic SQL Server index design and creation. Terms that will be covered and clarified: clustered index, non-clustered index, uniqueness, covering index, fill-factor, scan, seek, key lookup, and fragmentation. This is a beginning level course for those who have always found indexes confusing and somewhat elusive. Lots of valuable information will be provided in a short amount of time.

About Mindy:
Bio Mindy Curnutt is a Distinguished Engineer for TMW Systems (a Trimble Company), supporting nearly 2,000 customers using SQL Server. At Unisys from 2000-2007, she focused on VLDBs, scalability, performance, DR/HA , migration, and training. She wrote the log shipping chapter in the MS Press book “SQL Server 2012 – Step by Step" and served as a SME for Microsoft SQL Server 2012 and 2014 cert exams. Mindy is a SQL Server MVP, has spoken at many SQL Saturdays nationwide and presented at SQL PASS Summits in 2005, 2006, 2012 and 2013. She currently serves on the PASS Summit Program Committee Team.

Rev up data warehouse performance with SQL 2014 Columnstore indexes

Denzil Ribeiro, Principal Program Manager - SQL Customer Advisory Microsoft

SQL 14 offers a key data warehouse feature in updatable clustered Columnstore indexes that offers DW workloads 2-7X Data compression and overall huge query performance improvements. In this session we will cover the basics of Columnstore, the underlying architecture, tips and tricks to improve load performance as well as associated query performance benefits.

About Denzil:
Denzil Ribeiro is a Principal Program Manager in the SQLCAT (Customer Advisory team). He is a Microsoft Certified Master (MCM) and has 15+ years of experience working with large SQL Server implementations. Prior to his SQLCAT role, he has worked as a SQL Server Escalation Engineer and in the field as a Premier Field Engineer.


Thank You to the 

PLATINUM

SPONSORS 

of our May 2018 

SQL Saturday!











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