North Texas SQL Servers Users Group

Next Meeting

Thursday,

January

18

NTSSUG 18 JANUARY 2018

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

RSVP Here: https://www.meetup.com/North-Texas-SQL-Server-User-Group/events/246423926/

Monthly Newsletter

ISSUE #4 - JANUARY 2018
JANUARY MEETING

Rx for Demystifying Index Tuning Decisions

Summary:Indices are one of the most troubling and mysterious areas for DBAs and developers.Adding or deleting them can yield dramatic changes in query performance both positively and negatively.The mystery is knowing which indices need to be modified, added, or deleted and what outcome will result.This uncertainty often leads to great reluctance to eliminate indices that are used sparingly or only because the optimal one is not present.This often leads to index proliferation, which ultimately leads to inconsistent and poor query performance.Some DBAs believe that the SQL Server Database Tuning Advisor will solve all these problems, but in fact, it frequently does not and even compounds the index proliferation problem.This presentation will enable a DBA to make informed decisions regarding what metrics to monitor, determine how much indices are used, and devise appropriate index strategies to improve query performance.

Presenter:Jeff Schwartz

Bio:For 38 years Jeff has been conducting performance and capacity planning studies.He began his career in the mainframe world conducting performance and modeling studies.Since 2000, he has focused entirely on high-end Windows and SQL Server performance for large companies internationally and domestically.He has taught numerous courses, and given multiple presentations on performance and capacity planning.His knowledge and experience has caused his blogs to be routinely reposted and republished.
His reputation as an industry leader has resulted in numerous invitations to speak at conferences, SQL Saturdays, customer courses, webinars, and blogs on Windows and SQL Server performance.In particular, he presents the Windows Performance Course regularly at the Computer Measurement Group’s annual international conference.
During his career, he has received several consulting awards, the most prestigious of which was the 2008 Microsoft Data Management Solutions Partner of the Year for his 358,000+ line Windows and SQL Server performance analysis software framework for consultants.
Jeff is a graduate in Math and Computer Science from Cornell University and holds an MBA from the University of Rochester.He lives in Rochester, NY with his partner Marcia, his dog, Chloe, and his cat, Dutch.Jeff has been the lacrosse goalie coach at St. John Fisher College since 2002.

Meeting starts:6:00 pmwith food and Mingling
Announcements & Ask the Experts:6:30 pm to 7:00 pm
Presentation:7:00 pmto 8:00 pm

When:Thursday, January 18, 2018

Address:
Microsoft Las Colinas Offices
7000 North Highway 161 , Building LC-1
Irving Texas 75039
Map:https://goo.gl/maps/h9aWDZ6Z3wK2

Afterward socializing:If there is interest, we will gather at NYLO (1001 W Royal Ln, Irving, TX 75039) to casually socialize

NEWS & EVENTS
(these are simply notices and not condoned or guaranteed by NTSSUG)

Dallas Area Girls and Data Workshop #2 - Jan 27

Last September, NTSSUG provided 10 scholarships for girls ages 5th - 8th grade to attend a Girls and Data workshop in Richardson. The workshop took place at Westwood Junior High School in Dallas, A 2nd Dallas area workshop is now scheduled for January 27. The Covenant School in North Dallas has priority registration because they are hosting, but after Jan 9th, registration will open to the public. There are only 20 spots per class (2 workshops) for this event, so if you are interested or know someone who is, after the 9th of January have them jump right on it. Cost is only $15 thanks to generous donations. Below is a pic, and here is a link to a full album of photos from the last Dallas event.

SQL SATURDAY DALLAS

Join the Committee!!

The Dallas SQL Saturday 2018 is coming up May 19th. We need lots of help to make this happen. Are you interested in being on the committee? We need help in the following areas:

Marketing
Vendors & Sponsorship
Abstract Review
Scheduling
Speaker Room
Food & Refreshements
Setup
Cleanup
Speaker Dinner
After Event
PreCons
Swag Bags
Signage & Direction
more...

No job is too small. If you're willing to help in any way please contact Mindy either at the meeting or by responding / posting / PMing wherever you see this message. You can also email board@ntssug.com.

MEMBER SURVEY #2

A poll was presented to the members in December asking "What topics are you most interested in seeing presented at the monthly NTSSUG Meeting over the next 12-18 months? (Pick up to 10).
94 members responded to the survey. Here are the results:

Featured Presentation:

Rx for Demystifying Index Tuning Decisions

Jeff Schwartz SQLRx

Indices are one of the most troubling and mysterious areas for DBAs and developers. Adding or deleting them can yield dramatic changes in query performance both positively and negatively. The mystery is knowing which indices need to be modified, added, or deleted and what outcome will result. This uncertainty often leads to great reluctance to eliminate indices that are used sparingly or only because the optimal one is not present. This often leads to index proliferation, which ultimately leads to inconsistent and poor query performance. Some DBAs believe that the SQL Server Database Tuning Advisor will solve all these problems, but in fact, it frequently does not and even compounds the index proliferation problem. This presentation will enable a DBA to make informed decisions regarding what metrics to monitor, determine how much indices are used, and devise appropriate index strategies to improve query performance.

About Jeff:
For 38 years Jeff has been conducting performance and capacity planning studies. He began his career in the mainframe world conducting performance and modeling studies. Since 2000, he has focused entirely on high-end Windows and SQL Server performance for large companies internationally and domestically. He has taught numerous courses, and given multiple presentations on performance and capacity planning. His knowledge and experience has caused his blogs to be routinely reposted and republished. His reputation as an industry leader has resulted in numerous invitations to speak at conferences, SQL Saturdays, customer courses, webinars, and blogs on Windows and SQL Server performance. In particular, he presents the Windows Performance Course regularly at the Computer Measurement Group’s annual international conference. During his career, he has received several consulting awards, the most prestigious of which was the 2008 Microsoft Data Management Solutions Partner of the Year for his 358,000+ line Windows and SQL Server performance analysis software framework for consultants. Jeff is a graduate in Math and Computer Science from Cornell University and holds an MBA from the University of Rochester. He lives in Rochester, NY with his partner Marcia, his dog, Chloe, and his cat, Dutch. Jeff has been the lacrosse goalie coach at St. John Fisher College since 2002.


Thank You to the 

PLATINUM

SPONSORS 

of our May 2018 

SQL Saturday!











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