Welcome to the Central Illinois SQL Server User Group!

 

We are an official SQL PASS chapter, serving all of Central Illinois, which includes Quincy, Peoria, Bloomington/ Normal, Springfield, Decatur, Champaign, Danville and all the great communities that make up Central Illinois.

Next Meeting

Tuesday,

September

19

Central Illinois SQL Server User Group Meeting - Bloomington September 2017

Erin Stellato is going to present a session over WebEx.  You may join us at Afni in the auditorium, or join us online.  The WebEx will be emailed to the people signed up the day of the presentation.  As of right now, we don't have a sponsor, so food will not be provided.  Erin is an outstanding presenter and is extremely knowledgable in SQL Server.  This is a must see event.

Agenda:

5:00 PM - Doors open to Auditorium (Come to the front door)

5:30 PM Erin's presentation

6:30 PM to 7:00 PM Questions

 

Featured Presentation:

Answering the Question, "What Happened?" with Query Store

Erin Stellato, Principal Consultant SQLskills

One of the most highly anticipated new features in the SQL Server 2016 release is Query Store. It's been referred to as the "flight recorder" for SQL Server because it tracks query information, namely plans and runtime statistics. If you've ever had to drop everything to troubleshoot a sudden drop in performance, then you've probably already realized the value of this feature. In this session we'll walk through Query Store with a series of demos designed to help you understand how you can immediately start to use it once you’ve upgraded to SQL Server 2016. We'll review the different options for Query Store, look at examples of what gets collected, dig through the included reports, see how you can force SQL Server to use a specific plan for a query, and find out what happens when it can’t use the specified plan. Get ready to make troubleshooting easier with this feature that’s included in all editions of SQL Server 2016!

About Erin:
Erin Stellato is a Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 15 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery. Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.

Training Opportunities:

 

SQL Saturday's

PASS SQLSaturday’s are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Whether you're attending a SQLSaturday or thinking about hosting your own, we think you'll find it's a great way to spend a Saturday – or any day.  I've only listed a few that are in driving distance; many more are listed at the "SQL Saturday" home page.


SQL Saturday Home

SQL Saturday Indianapolis - August 12, 2017

SQL Saturday Kansas City - October 7, 2017

 

PASS SUMMIT

Summit 2017 Seattle - October 31st, 2017 - November 3rd, 2017

 

 

cage-aids
cage-aids
cage-aids
cage-aids