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,

July

29

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.

 

Agenda:

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 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 Cleveland - February 7, 2015

SQL Saturday Tampa - February 28, 2015

SQL Saturday Phoenix - February 28, 2015

SQL Saturday Madison - April 11, 2015

SQL Saturday Iowa City - May 30, 2015

 

SQL Saturday Indianapolis - August 8, 2015

 

 

 

PASS SUMMIT

Summit 2015 - No information yet on the next Summit.