Chicago Suburban SQL Server User Group

MEMBERSHIP

If you have not done so already, please register on PASS.  Then update your PASS Profile & Join our Chapter there. All future mailings will be sent out via your SQLPass account:

http://www.sqlpass.org/PASSChapters/LocalChapters.aspx

Quick Search on "Chicago Suburban SQL Server User Group" and make sure you are registered as a member.  Doing so will ensure that you will receive future e-mails from us.

Next Meeting

Tuesday,

January

16

January Meeting

  • In-Person @ 3025 Highland Pkwy Downers Grove, Illinois, United States (map)
  • 17:30 - 21:00 (UTC-06:00) Central Time (US & Canada)
  • Language: English

AGENDA:
5:30PM - Doors Open
6:00PM - Meeting Start with Dinner, Networking, & Open Q&A (bring your questions!)
6:30PM - Announcements, Sponsor Presentation, & Main Presentation

SPONSOR:


REGISTER:
https://www.eventbrite.com/e/chisub-ssug-january-meeting-tickets-41611627498

Featured Presentation:

Why is the Same Query Sometimes Slow?

You swear nothing has changed, but all of a sudden, out of nowhere, queries that used to be fast are suddenly slow. Even weirder, you take the slow query from the application, run it in SSMS, and it's totally fast! What's going on? You restart SQL Server or update statistics, and the problem seems to go away - but only for a few days or weeks, and then it comes right back. You're familiar enough with execution plans to realize that you're getting different plans, but...why? And how do you fix it long term? In this session, Brent Ozar will show you live demos of the most common culprit: parameter sniffing. You'll learn how to recognize parameter sniffing when it strikes, understand what causes it, see how to fix it short term with the lowest impact possible, and learn 6 ways to fix it long term.

Brent Ozar, Microsoft Certified Master of SQL Server Brent Ozar Unlimited

About Brent:
Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit. He loves sharing knowledge at BrentOzar.com.

REGISTER:

https://www.eventbrite.com/e/chisub-ssug-january-meeting-tickets-41611627498

PASSChapterLogo100.jpg


sql_micro_sm.gif






Andy Yun
E-Mail: SQLBek@gmail.com
Twitter: @SQLBek

Lowry Kozlowski
E-Mail: lowrykoz@gmail.com
Twitter: @lowrykoz

Chapter E-Mail: 
chisuburbanssug@sqlpass.org

 

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