Quad Cities PASS Chapter


Meeting Details




QCPASS Meeting - May 13, 2015

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

Topic:       Accelerating ETL Development 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.

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


Featured Presentation:

Accelerating ETL Development with BIML

Dave DuVarney, Consultant Talavant

Accelerating ETL Development with BIML

About Dave:
Dave DuVarney is an independent business intelligence consultant and trainer. He has broad technical and functional BI knowledge and has worked with organizations across the full BI life cycle. Dave has helped clients establish their BI program and run Agile development teams. He specializes in SQL Server Analysis Services, Integration Services, and Reporting Services as well as .NET development.


Meeting Archive


Apr   11, 2012     Mark Garner - Some New Features of SQL 2012

May    9, 2012     Joe Webb - Writing Better Queries

June 13, 2012     Scott Shaw - New T-SQL Features in SQL 2012     T-SQL Demo Scripts

July  11, 2012     Jes Borland - Making Your Voice Heard!

Aug  15, 2012     Jason Strate - Choosing Your Clustered Index

Sep  12, 2012     Michelle Ufford & Jessica Moss - SSIS Design Patterns for Fun and Profit

Oct   10, 2012     Kevin Kline - #1 - Top 10 Things DBAs Want Developers To Know

Oct   10, 2012     Kevin Kline - #2 - SQL Server Internals & Architecture  

Nov  14, 2012     Grant Fritchey - What to Look for in Execution Plans

Dec  12, 2012     Puneet Malhotra - Intro to PowerShell

Dec  12, 2012     Ted Krueger - Make Me a Query Tuning Believer    Slides & Demo Scripts 

Jan     9, 2013     Ed Leighton-Dick - Practically Normal

Feb   13, 2013     Russ Allen - Lessons Learned by the University of Iowa
Mar  13, 2013     Jennifer Salvo - Getting Started with SSAS Tabular Cubes
Mar  13, 2013     Adam Salvo - Microsoft Azure & SQL Azure 
Apr  10, 2013     Brian Duhn - Three 20 Minute Sessions - MCT & You, Log It or Leave It, Tool Talk  
May  15, 2013     Janis Griffin - Extend Your Knowledge with Extended Events!
Thank you Confio Performance Hog for visiting Davenport, IA!
Our databases perform better since your visit!



 June 12, 2013     Kathi Kellenberger - T-SQL Analytic Functions - Slides and Demo Script 

 July  10, 2013     Dave DuVarney - Overview of SSIS 2012 Deployment

 Aug  14, 2013     Michel Sellers - Source Controlling Your Database

 Sep  11, 2013     Michelle Ufford - PowerShell for Beginners

 Oct     9, 2013     Bradley Deem - Being Exceptional in Uncertain Times

 Nov  13, 2013     C. Elliott Whitlow II - SQL Synonyms as Database Boundary Objects or Synonyms, Your Friend in Obscure Places

 Dec  11, 2013     David Klee - Squeezing Top Performance from Your Virtualized SQL Servers

 Jan  15, 2014     Larry Toothman - Yesterday I couldn't even spell 'DBA', now I am one.  Help!

 Feb  12, 2014     Frank Gill - Designing a Restore Strategy

 Mar 12, 2014     Mike Lebben - BI Agility AND Enterprise Security with SQL Server and Pyramid Analytics..."How to make everybody happy!"

 Apr   9, 2014     Steve Piatak - Data Transformation - Tips and Tricks Learned Along the Way

 May 14, 2014     Pat Phelan - Involta's Tier 3 Data Center Tour & Presentation

June 11, 2014     Larry Toothman & Dave Tigges - That's Not My Job Description: The Accidental Developer

July    9, 2014     Mike Cole - Going The Extra Mile with Entity Framework Code First

Aug  13, 2014     Jes Borland - What's Coming in SQL Server 2014?

Sep  10, 2014     Russ Allen - Divide and Conquer - Creating and Managing Partitioned Tables and Indexes in SQL Server

Oct   15, 2014     Mitchel Sellers - Managing Database Change for your Organization

Nov  12, 2014     Ed Leighton-Dick - SQL Server Features That Will Blow Your Mind!

Dec  11, 2014    Ed Leighton-Dick - Computer Science Education Week

                          Eric Selje - Stealing Home (Depot) f/k/a Don't Be a Target!

Jan  21, 2015     Michelle Ufford - Resistance is Futile: What You Need To Know About Big Data

Feb  11, 2015     Ed Leighton-Dick - Protecting Your Data with Encryption

Mar  11, 2015   Mark Garner - Power BI and Azure Machine Learning

Apr   15, 2015   C. Elliott Whitlow II - Getting Started with Microsoft Azure

May  13, 2015   Rob Long - Building Metadata Driven ETL Solutions with BIML

Jun   10, 2015   Pat Phelan - Data Architecture 101

Jul    15, 2015   Tim Radney - Common SQL Server Mistakes and How to Avoid Them

Aug   12, 2015   Pat Phelan - PowerShell for the Reluctant Adminstrator

Sep   15, 2015   Pat Phelan - Data Center Tour and Presentation

Oct   14, 2015   Doug Lane - SQL Murder Mystery Hour: Living and Dying by Dynamic SQL

Nov  11, 2015   Denise Horner - My First PASS Summit Discussion

Dec    9, 2015  Wendy Pastrick - Transactional Replication 101

Jan  13, 2016   David Klee - Objective SQL Server Performance - Slides, Scripts

Feb  10, 2016   Jen McCown - Effortless Backup with Minion Backup

Mar   9, 2016   Mike Richardson - SQL 2016 analytics, cloud federation, and the implications for infrastructure

                        Anthony Counsell - SQL 2016, SQL 2016 on Linux, and SQL 2016 on Azure

Apr 13, 2016   Andrew Mauch - A Web-Based Governed Data Discovery and Analytics Platform

May 11, 2016  Pat Phelan & Denise Horner - Building a Data Warehouse for the DBA

Jun 15, 2016 Kevin Boles - Common TSQL Mistakes

Jul 13, 2016 Tonio Lora - Big Data Analytics with HDInsight

Aug 10, 2016 NetApp/Veeam/Sirius - How SQL and Microsoft environment can be optimized and maximized with their holistic solution

Sep 14, 2016 Scott Shaw - Hive 2.0: ACID and sub-second SQL latency with LLAP

Oct 12, 2016 Chuck Hieber - SQL Server Tips and Tricks from a lazy DBA

Nov  9, 2016   John Manzella - Accelerating DevOps Using Data Virtualization

Dec 14, 2016   Mark Vaillancourt - Azure SQL Database Elastic Boogie

Jan 11, 2017   Tim Radney - Azure SQL Database for the Production DBA

Feb 15, 2017   Jonathan Kehayias - Deadlocking for Mere Mortals

Mar 15, 2017 Pat Phelan - Ethics, Morals, and Laws 101 for the DBA

Apr 12, 2017   Ed Leighton-Dick - DevOps+Data: Working with Source Control

May 10, 2017 John Eisbrener - Index 360 - Looking at Indexes from Multiple Perspectives

Jun  14, 2017 David Thole - Intermediate R - Shiny, Working with SQL Server, and Docker

Jul 12, 2017 Andy Yun - Exploring Why UDFs & Nested Views Hinder the Query Optimizer

Aug 9, 2017 John Morehouse - Only You Can Prevent Database Fires!

Sep 13, 2017 Pat Phelan - Learn about "Helper tables" and CTEs

Oct 18, 2017 Pat Phelan - Network and learn about In Memory Tables

Nov 15, 2017 David Klee - Linux for the SQL Server Administrator






















Curative Computers LLC








Back to Top