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, June 14, 2017 - On site

David Thole

A functional programming and data science geek. Loves research, analysis of data, and developing algorithms to solve complex programming problems.

Intermediate R - Shiny, Working with SQL Server, and Docker

Intermediate to advanced R concepts. In this session, we'll look at connecting and working with SQL Server. This includes offloading data processing to Microsoft R Services. Along with that, we'll look at Shiny, and creating dashboard-like content in Shiny and how to deploy to a Shiny server. We'll use Docker for everything in this presentation, from the creation of the R/Shiny projects, to using SQL Server.


Sponsor: 


Eventbrite - QCPASS Meeting - June 14, 2017

 


Wednesday, July 12, 2017 - On site

Andy Yun

Andy Yun is a SentryOne Senior Solutions Engineer and a Microsoft MVP. He has been working with SQL Server for 15 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQL Saturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQL Saturday Organizing Committee.

Exploring Why UDFs & Nested Views Hinder the Query Optimizer

Ever found yourself deconstructing endless layers of nested code? Is your T-SQL codebase written in an object-oriented format with functions & views? Did you know that object-oriented code reuse can significantly hinder the Query Optimizer?

In this session, learn how T-SQL is not like other common programming languages. We will deep dive inside the Query Optimizer to understand why applying object-oriented principles can be detrimental to your T-SQL's performance. Extensive demos will not only explore solutions to maximize performance, you will also be introduced to a T-SQL tool that will aid you in unraveling nested code.

 Eventbrite - QCPASS Meeting - July 12, 2017

 



October 31 - November 3, 2017





 

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!

 


 


Next Meeting

Wednesday,

July

12

QCPASS Meeting - July 12, 2017

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

Wednesday, June 14, 2017 - On site

Andy Yun

Andy Yun is a SentryOne Senior Solutions Engineer and a Microsoft MVP. He has been working with SQL Server for 15 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQL Saturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQL Saturday Organizing Committee.

Exploring Why UDFs & Nested Views Hinder the Query Optimizer

Ever found yourself deconstructing endless layers of nested code? Is your T-SQL codebase written in an object-oriented format with functions & views? Did you know that object-oriented code reuse can significantly hinder the Query Optimizer?

In this session, learn how T-SQL is not like other common programming languages. We will deep dive inside the Query Optimizer to understand why applying object-oriented principles can be detrimental to your T-SQL's performance. Extensive demos will not only explore solutions to maximize performance, you will also be introduced to a T-SQL tool that will aid you in unraveling nested code.

 Eventbrite - QCPASS Meeting - July 12, 2017

Featured Presentation:

Exploring Why UDFs & Nested Views Hinder the Query Optimizer

Andy Yun, Senior Solutions Engineer SentryOne

Ever found yourself deconstructing endless layers of nested code? Is your T-SQL codebase written in an object-oriented format with functions & views? Did you know that object-oriented code reuse can significantly hinder the Query Optimizer? In this session, learn how T-SQL is not like other common programming languages. We will deep dive inside the Query Optimizer to understand why applying object-oriented principles can be detrimental to your T-SQL's performance. Extensive demos will not only explore solutions to maximize performance, you will also be introduced to a T-SQL tool that wil aid you in unraveling nested code.

About Andy:
Andy Yun is a SentryOne Senior Solutions Engineer and a Microsoft MVP. He has been working with SQL Server for 15 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQL Saturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQL Saturday Organizing Committee.