www.sqlpass.org    Professional Association for SQL Server

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.



Wednesday, September 10, 2014 - onsite


Topic:       Divide and Conquer – 

Creating and Managing Partitioned Tables and Indexes in SQL Server

This presentation will provide an overview of table and index partitioning in SQL Server 2012 and 2014, and describe a step-by-step approach for creating and managing partitions in a large data warehouse. Topics will include:

    • The benefits of table and index partitioning
    • Partitioning requirements and considerations
    • Laying the partitioning foundation
    • Creating partitioned tables and indexes
    • Adding data one partition at a time
    • Removing partitions when their data has “aged out”
    • Piecemeal restores of partitioned databases

The presentation will include a live demonstration of partitioning using fact tables from the AdventureWorksDW2012 sample database. All scripts used in the demonstration will be available to attendees after the presentation.

Speaker:  Russ Allen

Russ Allen has over 30 years of experience as a developer, technical instructor, and database administrator. He has worked for a variety of Eastern Iowa employers including Norand Corporation, Parsons Technology, Entre Information Systems, Productivity Point International, and Mercy Medical Center. For the last eight years, Russ has been a SQL Server DBA and BI Developer for the University of Iowa.



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

                                                                          Eventbrite - QCPASS Meeting - September 10, 2014



Wednesday, October 15, 2014 - onsite


Topic:       Managing Database Change for your Organization

Speaker:  Mitchel Sellers



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


                                                                           Eventbrite - QCPASS Meeting - October 15, 2014



    Save the date: 24 Hours of PASS: Summit 2014 Preview Edition coming Sept. 9. Get a sneak peek at what's to come in November with this free 24 Hours of PASS event - learn new skills and engage in free online technical training ... all from the comfort of your home or office!


PASS Summit 2014 - Seattle, WA - November 4-7, 2014

Pre-Cons - Nov 3 & 4

Save $150!  Use Discount Code - USNCS32


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!


The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.









Curative Computers LLC