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:     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, December 12, 2018


Location
  

Antonella’s Pizzeria II
421 West River Dr

Davenport, IA  52801

Please join us this month for an informal networking dinner at Antonella’s Pizzeria II located in the Freight House Building on River Drive in Davenport.  We will gather between 5:30 p.m. - 6:00 p.m.

We will have a discussion of PASS Summit 2018 led (and sponsored) by our own Pat Phelan.

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 Shool 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.

Click to RSVP


Wednesday, January 9, 2019 - Remote Speaker

 

Andrew J. Kelly

Andrew J. Kelly is a Senior Technical Subject Matter Expert with B3 Group Inc. and a Data Platform MVP with over 20 years’ experience with relational databases and application development specializing in Performance, Scalability and Maintainability of large scale SQL Servers. He is a regular speaker each year at multiple conferences.

Twitter: http://twitter.com/gunneyk
MVP Profile: http://mvp.microsoft.com/en-us/mvp/Andrew%20J.%20Kelly-5438

 

Getting your Daily Debrief 

We will walk thru the code and process to automate the collection of several key aspects of your SQL Server instance that you should be aware of each day. This will include parsing the SQL Server Error logs, extracting key DDL / Audit events and finding the top offending SQL statements. The automation will include scheduled jobs that use standard TSQL, Extended events and PowerShell to gather and extract the necessary information so they can be loaded into tables for easy reporting.

   Click to RSVP


Wednesday, February 13, 2019 - Remote Speaker

 

Glenn Berry - SQLSkills

Principal Consultant

 

Glenn has worked as a SQL Server professional for many years in a variety of roles, including stints with NewsGator and Avalara. His expertise includes DMVs, high availability, hardware selection and configuration, and performance tuning. He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. Glenn is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQL Saturdays, SQLintersection, and the PASS Community Summit. He is the author of the book SQL Server Hardware, and he wrote chapters for SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2 books.

Email: Glenn@SQLskills.com 
Website: http://www.SQLskills.com 
Full Bio: http://www.sqlskills.com/about/glenn-berry/ 
Blog: http://www.SQLskills.com/blogs/Glenn
Twitter: http://twitter.com/GlennAlanBerry
Microsoft MVP since 2007

Dr. DMV's Troubleshooting Toolkit 

Dynamic Management Views and functions allow you to easily see exactly what is happening inside your SQL Server instances and databases with a high level of detail. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session presents, demonstrates and explains a complete set of diagnostic DMV queries that you can easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases.  This session goes into exhaustive detail on how to interpret the results of each of the diagnostic queries, including relevant background information on how to properly configure your hardware, storage subsystem, operating system, SQL Server instance and databases in order to avoid performance and scalability issues.

Click to RSVP


Wednesday, March 13, 2019 - Remote Speaker





Tim Radney - SQLSkills

Principal Consultant

 

Tim is a SQL Server MVP. He has presented at PASS, SQLintersection, SQL Saturdays, user groups and numerous webinars. In addition Tim runs the Columbus GA SQL Users Group, is a PASS Regional Mentor and was named a PASS Outstanding Volunteer in 2012. He’s married with three children and has a passion for electronics. He also farms chickens (for eggs), dwarf Nigerian goats, and tilapias in his spare time.

 

Email: Tim@SQLskills.com 
Website: http://www.SQLskills.com 
Full Bio: http://www.sqlskills.com/about/tim-radney/ 
Blog: http://www.SQLskills.com/blogs/tim
Twitter: http://twitter.com/TRadney
Microsoft MVP since 2014

 

Introduction to Azure Managed instances 

Have you been hearing about Azure Managed Instances and want to know what all the fuss is about? Come see how Managed Instances is changing how we think about cloud databases. Managed Instances can be considered a hybrid of Azure SQL Database and on-premises SQL Server with all the awesome benefits of Platform as a Service. You’ll get to see first-hand how easy it is to migrate databases from on-premises to a Managed Instance. We’ll explore the differences between Azure SQL Database, Managed Instances, and SQL Server on an Azure VM to help you determine what is the best fit for your organization. If you’ve been considering Azure for your organization, this session is for you!

Click to RSVP


 



 


EventDisplay

Next Meeting

Wednesday,

January

09

QCPASS Meeting - January 9, 2019

  • In-Person @ 201 N Harrison St, Suite 600 Davenport, Iowa, United States (map)
  • 17:30 - 20:30 (UTC-06:00) Central Time (US & Canada)
  • Language: English

Wednesday, January 9, 2019 - Remote Speaker

 

Andrew J. Kelly

Andrew J. Kelly is a Senior Technical Subject Matter Expert with B3 Group Inc. and a Data Platform MVP with over 20 years’ experience with relational databases and application development specializing in Performance, Scalability and Maintainability of large scale SQL Servers. He is a regular speaker each year at multiple conferences.

Twitter: http://twitter.com/gunneyk
MVP Profile: http://mvp.microsoft.com/en-us/mvp/Andrew%20J.%20Kelly-5438

 

Getting your Daily Debrief 

We will walk thru the code and process to automate the collection of several key aspects of your SQL Server instance that you should be aware of each day. This will include parsing the SQL Server Error logs, extracting key DDL / Audit events and finding the top offending SQL statements. The automation will include scheduled jobs that use standard TSQL, Extended events and PowerShell to gather and extract the necessary information so they can be loaded into tables for easy reporting.

   Click to RSVP

 

Featured Presentation:

Getting your Daily Debrief

Andrew Kelly, Senior Technical Subject Matter Expert B3 Group Inc.

We will walk thru the code and process to automate the collection of several key aspects of your SQL Server instance that you should be aware of each day. This will include parsing the SQL Server Error logs, extracting key DDL / Audit events and finding the top offending SQL statements. The automation will include scheduled jobs that use standard TSQL, Extended events and PowerShell to gather and extract the necessary information so they can be loaded into tables for easy reporting.

About Andrew:
Andrew J. Kelly is a Senior Technical Subject Matter Expert with B3 Group Inc. and lives in Waynesboro, VA. He has over 20 years experience with relational databases and application development, but his main focus now is SQL Server. In addition to general SQL Server training and mentoring, he specializes in performance, scalability, and maintainability of large-scale SQL Servers. He is a regular speaker at conferences and user groups and has been a SQL Server / Data Platform MVP since 2001.

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 











 












  

Curative Computers LLC

 


 

 

 

 

 


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