Las Cruces & El Paso SQL Server Users Group

We will update meetings with slides and attachments as the presenters make them available.

Next Meeting

Thursday,

March

08

Las Cruces-El Paso SQL Server User Group: Why Did My Clever Index Change Backfire? Recorded SQL Pass

  • In-Person & Online @ 700 N Main Las Cruces, New Mexico, United States (map)
  • 12:00 - 13:00 (UTC-07:00) Mountain Time (US & Canada)
  • Language: English

The Las Cruces-El Paso SQL Server User Group (LCEP) will be having its next meeting, Thursday 03/08/18 from 12:00 PM - 1:00 PM at the Las Cruces City Hall - 700 N Main St, Rm 2007-C, Las Cruces, NM 88001. We will be watching a recorded session from SQL Pass by Kendra Little. Join us for this recorded presentation “Why Did My Clever Index Change Backfire?” Get to know your peers, and have lunch on us! 

Can’t Attend in person?  Join us on Skype! Join Skype Meeting.  Please email us at LCEP@pass.org if you intend on joining us online.

 

About this session:  SQL Server is full of advanced techniques to build powerful indexes: indexed views, filtered indexes, columnstore indexes, and more. But many of these techniques have risks: your cool indexing idea may backfire and leave your users frustrated. In this preview session, you'll see a few demos of how different indexing patterns may slow down queries, have dangerous side effects, or not work at all. If you have a solid knowledge of index basics and are comfortable reading query execution plans, this session will improve your index tuning skills.

 

Attend this FREE SQL training event! 

Kindly RSVP so we know how much pizza we should buy!

 

PASS Membership is not a prerequisite to attend this or any other monthly meeting of the LCEP SQL Users Group 

However, you can enjoy many benefits of being a member by signing up for a FREE PASS membership at: http://www.sqlpass.org/ 

Contact us at LCEPSSUG@gmail.com  

 

LCEP SSUG SPONSORS 

Red Gate-Simple tools for DBA's & developers. The Leader for SQL and .NET tools. If you haven't already 

O’Reilly– User group members save 40% off print and 50% off ebooks.Discount Code:DSUG 

If you organization is interested in sponsoring El Paso’s only association of SQL Server Professionals please contact us at LCEPSSUG@gmail.com. 

 

Featured Presentation:

“Why Did My Clever Index Change Backfire?” Recorded SQL Pass Session with Kendra Little

Kendra Little

SQL Server is full of advanced techniques to build powerful indexes: indexed views, filtered indexes, columnstore indexes, and more. But many of these techniques have risks: your cool indexing idea may backfire and leave your users frustrated. In this preview session, you'll see a few demos of how different indexing patterns may slow down queries, have dangerous side effects, or not work at all. If you have a solid knowledge of index basics and are comfortable reading query execution plans, this session will improve your index tuning skills.

About Kendra:
Kendra Little is a Senior DBA in the online advertising industry with seven years of DBA experience and ten years experience with SQL Server. Kendra creates tools to automate database maintenance, implements custom perf monitoring, tunes production servers, and builds SQL Reports for trending. She works closely with an Agile development team to plan and deploy weekly changes. Kendra is passionate about helping build the DBA profession as a dynamic, necessary function for successful businesses.

EventArchive

Meeting Archive

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