Quad Cities PASS Chapter

Welcome to the Quad Cities PASS User Group (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:     Please note location on each meeting below.
 
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.

Meetings

 
 

 

Wednesday, July 10, 2019 - Remote Speaker

 

Location:  Twin State Technical Services
                   3541 E Kimberly Road
                   Davenport, IA  52807
 

Ryan Adams - Microsoft

 

Ryan Adams is a Senior Premier Field Engineer for Microsoft.  He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud.

Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company.  His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.

 

How Active Directory Affects SQL Server

If you have ever had a Kerberos or SSPI context error, then you won't want to miss this session.  SQL Server has a large surface area and Active Directory can influence how SQL Server performs.  I will discuss AD DNS configuration, Group Policy Objects, Kerberos, and how all of them affect your SQL Server.  By the end of the session you'll have a check list of things to discuss with your domain administrator when you return to work.

                                                  Click to RSVP
 

 


Wednesday, August 14, 2019 - On Site Speaker

Location:  Twin State Technical Services
                   3541 E Kimberly Road
                   Davenport, IA  52807
 

Juan Soto 

Juan Soto is a frequent speaker at SQLSaturdays.com and prolific author of articles at the official Microsoft Access blog, including being the only Access developer to be profiled on the site. He’s also the founder of AccessUserGroups.org, a worldwide organization of user groups that meet virtually online to discuss Access topics each month in multiple languages and countries. When he’s not presenting he’s managing one of the largest practices of Access consulting in the world at AccessExperts.com

Optimizing Microsoft Access with SQL Server 

SQL Server DBA’s are often asked to take over a Microsoft Access application that has become mission-critical, the conversation usually goes like “You’re a DBA and Access is a database, so take over this system and upgrade it to SQL Server...”, but simply moving the data over may not guarantee better performance and can even make matters worse.

The reality is Access can be much faster with SQL Server, allowing many more users, improving stability and safeguarding your data over a regular Access database. In this session, Juan Soto, the only Access MVP in Illinois, will discuss how to avoid pitfalls with performance, the proper method to designing tables for Access and how to leverage stored procedures and views with pass-through queries.

                                                  Click to RSVP

 


Wednesday, September 11, 2019 - On Site Speaker

David Bland - Manager of Database Administrators, Stericycle

Over 20 years of SQL Server experience that includes being a DBA, BI development and Application development using VB.NET.  Dave currently is the Manager of the DBA team at Stericycle.  Dave is a Friend of Red-Gate for 2019.  He is a frequent presenter at SQL Saturday events and user groups around the country.  Has been teaching SQL Server since version 2000 and is the SQL Server instructor at Harper College in Palatine, IL.  Current certifications include: Microsoft Certified Trainer; MCTS: SQL Server 2008, Implementation and Maintenance; MCTS: SQL Server 2008, BI Development and Maintenance; MCSA: SQL Server 2008; MCSA: SQL Server 2016; MCSE: SQL Server 2016 - BI; MCDBA: SQL Server 2000; MCSD; MCSE: Data Management and Analytics.

Is my Server Suffering from Memory Pressure?

As we all know, SQL Server loves memory and will use as much as it can get.  However, when there is memory pressure we need to use our DBA skills to identify what is causing the pressure.  During this session we will explore how SQL Server uses memory and how to properly configure memory settings.  We will discuss the use of DMVs and other tools to help us find what is consuming the most memory and some potential solutions.


Wednesday, October 9, 2019 - On Site Speaker

Ed Leighton-Dick - Founder/Principal Consultant, Kingfisher Technologies

Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies.  He is a frequent volunteer with PASS, including roles as regional mentor, chapter leader of I-380 PASS SQL Server User Group, and organizer of SQLSaturday Iowa City.  He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.

Topic - TBA

 

Announcements

 



 


EventDisplay

Sorry, there are no upcoming meetings. Please check back for updates.

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 













 












  

Curative Computers LLC

 


 

 

 

 

 


Back to Top
cage-aids
cage-aids
cage-aids
cage-aids