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, August 15, 2018 - Onsite Speaker

 

Ed Leighton-Dick - 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. 

Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)

As DBAs, we are asked all sorts of impossible questions.  Who dropped that important table last month?  Why was everything slow last week?  Who made that user a sysadmin?  You’d have to be a mind reader to know the answers to some of those, right?  Not necessarily!  SQL Server can help you find information about these and other common problems with its default trace and system_health Extended Events session, but you have to know how to collect and interpret the data they provide.  In this session, we’ll explore what system_health and the default trace are, what information they contain, and how to use them to find the answers you’re searching for.

Click to RSVP


Wednesday, September 12, 2018 - Onsite Speaker
Dave Bland

Over 14 years of SQL Server experience that includes being a DBA, BI development and Application development using VB.NET. Dave currently supervises the Shared Services DBA team at Stericycle He is a frequent presenter at SQL Saturday events throughout the Midwest. Has been teaching SQL Server since version 2000 and currently 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 2012\2014 • MCSE: SQL Server 2012\2014 - BI • MCDBA: SQL Server 2000 • MCSD • MCSE: Data Management and Analytics

SQL Server Extended Events

Extended Events are an essential part of proper monitoring and every DBA should know what they are and how to use them. This session will cover the basics of Extended events as well as an introduction to the system_health session. This session will give someone who has never used Extended events before the skills to start using them! We will also cover some of the common events to monitor and what kind of issues can be found.

                                                   Click to RSVP


Wednesday, October 10, 2018 - Onsite Speaker

Frank Gill


Frank Gill is a Senior Data Engineer at Concurrency   With 19 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.

Transaction Log for Developers

SQL Server tracks all changes to a database's data and schema in the transaction log. This makes it the most important file in any database. Understanding transaction log architecture and behavior will help you develop code that will maximize performance and minimize resource consumption. Join me to learn about transaction log architecture, batching transactions, rollback activity, and the effect these things can have on performance.


                                            Click to RSVP


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

 



PASS SUMMIT 2018

Two Ways to Save $$$

               


 



 

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!

 


 


EventDisplay

Next Meeting

Wednesday,

October

10

QCPASS Meeting - October 10, 2018

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

Wednesday, October 10, 2018 - Onsite Speaker

 

Frank Gill


Frank Gill is a Senior Data Engineer at Concurrency   With 19 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.

Transaction Log for Developers

SQL Server tracks all changes to a database's data and schema in the transaction log. This makes it the most important file in any database. Understanding transaction log architecture and behavior will help you develop code that will maximize performance and minimize resource consumption. Join me to learn about transaction log architecture, batching transactions, rollback activity, and the effect these things can have on performance.

                                            Click to RSVP


Featured Presentation:

Transaction Log for Developers

Frank Gill, Senior Systems Engineer Concurrency

SQL Server tracks all changes to a database's data and schema in the transaction log. This makes it the most important file in any database. Understanding transaction log architecture and behavior will help you develop code that will maximize performance and minimize resource consumption. Join me to learn about transaction log architecture, batching transactions, rollback activity, and the effect these things can have on performance.

About Frank:
Frank Gill is a Senior Data Engineer at Concurrency With 19 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 










 

















  

Curative Computers LLC

 

 


 

 

 

 

 


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