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 7 years of experience administering large-scale SQL Server environments. With 15 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 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 Washington D.C. - December 6, 2014

SQL Saturday Cleveland - February 7, 2015

SQL Saturday Tampa - February 28, 2015

SQL Saturday Phoenix - February 28, 2015


For those of you looking to 2015:

SQL Saturday Austin - January 31, 2015 - You may consider this when you think back to the weather during our last January.

Madison, WI is hosting a SQL Saturday April 11th.  I'm sure this will be a fun and exciting SQL Saturday.  Registration is not open yet.

SQL Saturday in Chicago has changed their date.  Currently, the date Chicago will be hosting a SQL Saturday on May 2nd, 2015 at Allstate Insurance, in Northbrook, IL.  A few of us from Afni attended the SQL Saturday in Chicago last year, and I must say that it was like a full day at Summit.  I can't say enough about the speakers and topics, they were fantastic.


Summit 2015 - No information yet on the next Summit.