www.sqlpass.org    Professional Association for SQL Server

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.

 

 Meetings

 

Wednesday, March 11, 2015 - onsite

 

Topic:       Power BI and Azure Machine Learning 


Speaker:  Mark Garner (Microsoft)


RSVPs are appreciated so we know how much food to order - just click on the big red button below.




 

Wednesday, April 15, 2015 - onsite

 

Topic:       Bridging The Gap From Rows To Columns

For many who come to T-SQL from other languages, dealing with result sets and thinking in set based solutions can be frustrating. Our minds are conditioned to think in processing rows of data, not entire sets. As a consequence many give up and misuse cursors or come up with other ways to create RBAR (Row By Agonizing Row) solutions. Some others try to deal with sets but get caught in the tangle of nested queries. In this session I will deal with Table Expressions with particular emphasis on CTEs or Common Table Expressions. Let me show you how using these simple tools can help simplify your code, bridging the gap between RBAR and set based solutions.

Session Level: Intermediate 

Speaker:  Larry Toothman

Larry has been a Database Administrator for a non-profit health system in Cedar Rapids, IA since late 2007. With over 20 years of software and database development experience, he was drafted to be the DBA in 1999 for a dev company. Amazed by the wide variety of people in the SQL Server community as well as the support from the "SQL Family" Larry is always looking for opportunities to pay it forward, spread the word & mentoring.

RSVPs are appreciated so we know how much food to order - just click on the big red button below.




 

Wednesday, May 13, 2015 - onsite

 

Topic:       Building Metadata Driven ETL Solutions with BIML

ETL development can consume a significant portion of time in Data Warehousing initiatives.  It can also be very cumbersome to change ETL patterns across a large number of objects.  This session will look at how BIML + metadata can be leverage to significantly reduce ETL development time.

Speaker:  Dave DuVarney & Rob Long

Dave DuVarney is President and Co-Founder of Talavant.  Dave has delivered numerous business intelligence projects in both a technical and functional leadership role.  Dave's latest technical focus has been on the Microsoft Business Intelligence tools including Analysis Services 2012, Integration Services 2012, BIML, Reporting Services and PowerPivot.  Along with technical delivery, Dave has assisted clients in establishing Data Warehousing and Business Intelligence initiatives.  This includes working with executive stakeholders to define objectives, assisting in the identification of team roles and implementing development best practices using Agile Scrum.

Rob Long is Chief Architect and Co-Founder of Talavant. Rob is passionate about developing solutions that improve the delivery of data warehousing and business intelligence solutions.  He has a breadth of experience including development, network administration and database administration.  For the last 8 years, Rob has focused his efforts on delivering solutions on the Microsoft BI stack.  He is a proud father of four, a Certified Business Intelligence Professional, and enjoys spending time with family and keeping up with the ever changing data management industry.

RSVPs are appreciated so we know how much food to order - just click on the big red button below.





 

Wednesday, June 10, 2015

 

Topic:       TBA


Speaker:  TBA



 

Wednesday, July 15, 2015 - onsite

 

Topic:       Forensic Analytics with PowerPivot for Excel

Despite the wealth of analytical technologies available today, 65% of occupational fraud at public companies is detected through tips, management review, or simple accidents. Forensic analytics can change this disappointing scenario by employing a combination of human intuition and leading-edge technologies, and can provide superior detection methods to significantly improve the detection and investigation of illegal or unethical activities.

In this session, we explore forensic analytics: a set of techniques we can use to uncover irregularities in financial data. We also gain an understanding of goals of forensic analytics: to enable us to find out how — and why — these irregularities exist, and to find out their source(s) — especially when fraudulent activity is suspected. We discuss guiding principles that are key to effectively and confidently ferreting out data anomalies, and outline a methodology to meet key principles by applying a standard, repeatable process to forensic analytics. Throughout the session, we view examples of how we can employ PowerPivot for Excel to drive forensic analytics via various tests and reviews.

Speaker:  William E. Pearson III

Bill Pearson, SQL Server Analysis Services Maestro, SQL Server MVP, CPA, CITP, CGMA, CMA, CIA, MCDBA, MCSE, is a consultant, author, mentor and business intelligence architect who has been working with business intelligence for over 18 years, and with the integrated Microsoft Business Intelligence solution since its inception. Bill has been awarded the Microsoft Most Valuable Professional designation multiple years for his technical experience implementing Microsoft BI, as well as his contributions to the community as an author and speaker. Bill’s recent series’ include the Stairway to MDX and Stairway to PowerPivot and DAX columns at SQLServerCentral.com, and he presents regularly at SQL Saturdays and other diverse events worldwide. Bill is a member of the Boulder BI Brain Trust.


RSVPs are appreciated so we know how much food to order - just click on the big red button below.


 

 Announcements

PASS Business Analytics Conference 2015

Get $150 Discount using our chapter code USSE25

 



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!

 

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.
 Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 













  

Curative Computers LLC