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




Central Illinois SQL Server User Group July 2014 Meeting

Meeting will be held at the Afni Headquarters in the Auditorium.  If you are running late to the meeting, there will be a sign on the door with a phone number to call.  This will be our second meeting for the SQL Server User Group, and all are welcome.  We had a great turnout for our first meeting, and look to have an even better turnout for our second meeting.



6:30 PM - Meet and Greet

7:00 PM - Frank Gill's Presentation

8:00 PM - Questions and Discussion.

Featured Presentation:

Interrogating the Transaction Log

Frank Gill, Senior Technology Specialist Apparatus

Frank Gill, who is the Co-President of the Chicago SQL Server User Group, will be speaking on June 29th. More information on the topic and about Frank is below. As a SQL Server DBA, I believe that the transaction log is the most important file in any database. I also believe that understanding how the transaction log works internally will help you make better decisions regarding log file sizing, transaction scope, and indexing. Join me to learn about transaction log architecture, how to see a transaction process in the log, how transaction scope affects log growth, and what happens when a transaction rolls back. Plus, you will see how transactions involving SQL Server 2014's in-memory object are handled by the log!

About Frank:
Frank Gill is a Senior SQL Server DBA with 8 years of experience administering large-scale SQL Server environments. With 16 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.

Training Opportunities:


SQL Server Launch 2016 Event and Discovery Day

Central Illinois SQL Server User Group SQL Server Launch 2016 Event and Discovery Day on Saturday, June 18th from 8:45 AM until 5:00 PM at Levi, Ray & Shoup, Inc. in Springfield IL.  We will have SQL Server MVP, Kathi Kellenberger, who is an amazing instructor and mentor,  tell us about the great new features of SQL Server 2016!  Chris Thompson, a Premier Field Engineer with Microsoft and a great presenter and very knowledgeable with Microsoft products, will also be presenting on Microsoft SQL Server 2016.


This won’t be your ordinary group event - you will be asked to participate and help solve a problem using SQL Server and PASS data. Towards the end of the day, you’ll present these ideas to the group and the winning team will receive prizes! Judging will be done by our MVP.


Microsoft will be providing breakfast, lunch and some snacks.  We’ll also be giving out Microsoft SWAG. You will get a lot out of this intense day, and you will walk away with concrete usage examples and of course some excellent networking with your SQL Server peers.


8:45 AM – Registration​​

9:20 AM – Introduction

9:30 AM – Presentations

10:30 AM – Break 10:45 AM – Presentation Cont.

11:30 AM – Breaking into groups/idea development

12:30 PM – Lunch

1:00 PM – Solution Development

2:30 PM – Break

4:00 PM – Show & Tell

4:45 PM – Wrapping Up

5:00 PM – Close

Register Below by EOD June 15th.



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 Iowa City - June 11th, 2016


SQL Saturday Indianapolis - August 13th, 2016



Summit 2016 - October 25 - October 28, 2015