Welcome to the Quad Cities PASS Chapter (QCPASS)

QCPASS is a SQL Server User Group in the Quad Cities area (Davenport & Bettendorf, IA and Rock Island & Moline, IL and the surrounding area).  We meet monthly, typically on the 2nd Wednesday of the month.  Meetings are always FREE and food will typically be provided.  Please come be a part of our local community! 

Time:           5:30 PM   Dinner
                  6:00 PM   Meeting
 
Location:     201 N Harrison St (4th Floor)
                   Davenport, IA

Parking:     Parking Ramp      - enter from Harrison St (.75/hr)
                 Parking Ramp      - enter from Harrison St (south side, no gate, FREE)
  On street parking - FREE after 5:00 PM

If you would like to be on our email list, please join our chapter by registering for a free PASS membership at http://www.sqlpass.org and adding our chapter to your myChapters page.  Please also check back here at the website for details!

Speakers and sponsors please contact us from our "About Us" page.

 

 


Tuesday, September 15, 2015 - off site tour

 

Topic:       Data Center Tour

One of our local data centers has invited us to take a tour of their facility for our September meeting. A discussion of data centers will be held after the tours are finished.

Not interested in a tour? No problem. Come out and join us for dinner, the discussion, and camaraderie.

We'll meet a week later than usual to avoid the Labor Day holiday.  Also note, we will meet on a Tuesday this month.

Advance registration is required so that we can comply with the data center's security rules. If you've never seen a Tier III data center in operation, now's your chance!

You can register at https://www.eventbrite.com/e/data-center-tour-registration-17839111262.

Speaker:  Pat Phelan

Pat Phelan joined a user group (DECUS) in High School, and many more since then. Pat was paid for his first program before he got his driver’s license. After many jobs (with some great stories) in High School and College, Pat worked over twenty years for a major accounting firm. Pat started working for Involta in 2007 and is now the database mentor and a member of the Engineering team.  Involta builds, owns and operates world class colocation datacenters and provides managed services and support staff to clients.


Sponsor:  

 

 


Wednesday, October 14, 2015 - onsite

 

Topic:       SQL Murder Mystery Hour:  Living and Dying by Dynamic SQL

Ask any DBA if they want to manage dynamic SQL: "Impossible-to-read source code and SQL injection? No thanks!" they'll say. However, dynamic SQL not a tool of the desperate and unskilled. It is flexible and makes complex queries screaming fast when more conventional methods cannot. In this session, we focus on:

* Understanding pros and cons of dynamic SQL

* Writing fast and efficient dynamic SQL code

* Monitoring dynamic SQL statements and their performance

To spark discussion and keep the audience riveted, this session is styled as a technical presentation weaved into an interactive murder mystery, complete with suspects, interrogations, and clues. Attendees form small groups to observe, discuss, and ultimately solve the mystery of the deadly dynamic SQL.

Developers and DBAs: if you want to become wise in the ways of dynamic SQL, this session is for you. Be sure to bring your sleuthing skills!

Speaker:  Doug Lane

Doug Lane (MCITP, MCTS) is a consultant for Brent Ozar Unlimited, specializing in T-SQL, Reporting Services, and motion pictures. He has over 15 years' experience in IT. In addition to presenting at conferences, SQL Saturdays, and user group meetings, Doug also blogs and does webcasts on brentozar.com.

RSVPs are appreciated so we know how much food to order - just click on the big red button below.


Eventbrite - QCPASS Meeting - October 14, 2015

 


Wednesday, November 11, 2015 - onsite

Topic:       My First PASS Summit Discussion


Speaker:  Denise Horner




Wednesday, December 9, 2015 - onsite

 

Topic:       Transactional Replication 101

 

Speaker:  Wendy Pastrick

 


 
PASS Summit 2015


Get $150 Discount using our chapter code:  LC15WCH6


This discount code cannot be combined with any other PASS Summit 2015 discount and cannot be applied retroactively to an existing registration.

Register soon for the best possible rate.

Save on accommodations by registering with PASS' partner hotels when registering for the summit.


 

 


 

O'REILLY User Group Offer

 

Receive a 35% discount on Wiley ebooks.  Use code DSUG35 when placing an order online at oreilly.com.

                                     

 


Microsoft Press - Free ebook: Introducing Microsoft SQL Server 2012

Friends, the final and complete version of Introducing Microsoft SQL Server 2012, by Ross Mistry (@RossMistry) and Stacia Misner (@StaciaMisner), is now ready as a free download! You can download the PDF version of this title here (288 pages; 10.8 MB).  The EPUB is here, and the MOBI is here.

If you prefer a hard copy of the book, you can order it here for $14.99.

We are releasing this title to help you learn about the new features and capabilities in SQL Server 2012, which Microsoft released to manufacturing (RTM) on March 6, 2012. You can expect general availability of the product to begin on April 1, 2012.

Please help us share the news about this ebook. And enjoy!

 


 

Next Meeting

Tuesday,

September

15

QCPASS Meeting - September 15, 2015

  • In-Person @ 201 N Harrison St, Suite 600 Davenport, Iowa, United States (map)
  • 17:30 - 20:30 Central Daylight Time
  • Language: English

Topic:       Data Center Tour

Speaker:  Pat Phelan

Pat Phelan joined a user group (DECUS) in High School, and many more since then. Pat was paid for his first program before he got his driver’s license. After many jobs (with some great stories) in High School and College, Pat worked over twenty years for a major accounting firm. Pat started working for Involta in 2007 and is now the database mentor and a member of the Engineering team.  Involta builds, owns and operates world class colocation datacenters and provides managed services and support staff to clients.

Featured Presentation:

Data Center Tour

Pat Phelan, GIR Involta, LLC.

Our group will tour a data center that few get to see.

About Pat:
Pat Phelan joined a user group (DECUS) in High School, and many more since then. Pat worked many jobs in high school and college, and over twenty years for a major accounting firm. Pat started working for Involta in 2007 and is now the database mentor and a member of the Engineering team. Involta builds, owns and operates world class colocation datacenters and provides managed services and support staff to clients.