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, November 14, 2018 - Remote Speaker

 

Allen White


DataPerf Professionals Consulting


Allen White is a Microsoft Data Platform MVP, community leader, mentor, author and public speaker.

For over 40 years, Allen has specialized in developing applications that manage the movement of data and maximize data’s usefulness.

Allen excels at communicating highly technical information using language that results in increased client engagement and understanding, regardless of technical competency.

Allen has been working with relational database systems for over 25 years. He has architected database solutions in application areas like retail point-of-sale (POS), POS audit, loss prevention, logistics, school district information management, purchasing and asset inventory and run-time analytics.

In addition to designing and developing application data structures, Allen mentors and coaches development teams on database best practices. He has created “Center of Excellence” documents for major corporations, while achieving full client developer adoption.

Maintain SQL Server Performance Baseline with PowerShell

Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs.  Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem.  This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

                                                    Click to RSVP


Wednesday, December 12, 2018 - TBA

 


Wednesday, January 9, 2019 - TBA

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


PASS SUMMIT 2018

Two Ways to Save $$$

               


 



 


EventDisplay

Next Meeting

Wednesday,

November

14

QCPASS Meeting - November 14, 2018

  • 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, November 14, 2018 - Remote Speaker

 

Allen White


DataPerf Professionals Consulting


Allen White is a Microsoft Data Platform MVP, community leader, mentor, author and public speaker.

For over 40 years, Allen has specialized in developing applications that manage the movement of data and maximize data’s usefulness.

Allen excels at communicating highly technical information using language that results in increased client engagement and understanding, regardless of technical competency.

Allen has been working with relational database systems for over 25 years. He has architected database solutions in application areas like retail point-of-sale (POS), POS audit, loss prevention, logistics, school district information management, purchasing and asset inventory and run-time analytics.

In addition to designing and developing application data structures, Allen mentors and coaches development teams on database best practices. He has created “Center of Excellence” documents for major corporations, while achieving full client developer adoption.

Maintain SQL Server Performance Baseline with PowerShell

Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs.  Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem.  This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

                                                    Click to RSVP

Featured Presentation:

Maintain SQL Server Performance Baseline with PowerShell

Allen White, Consultant DataPerf Professionals Consulting

Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

About Allen:
Allen is a Data Platform Consultant. He's been both a developer and an administrator so understands both perspectives towards database technology, and loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT. Allen has been awarded Microsoft’s MVP Award for the last twelve years, and is in his third year as a PASS Director.

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 










 

















  

Curative Computers LLC

 

 


 

 

 

 

 


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