Meeting Details

Wednesday,

December

09

QCPASS Meeting - December 9, 2015

  • 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

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:

Transactional Replication 101

Wendy Pastrick, Data Platform Consultant Arrow IT Consulting

Replication simplified! Learn the basic parts that make up replication, what tools are included to help you along plus a look into monitoring. We will cover the players in the game: Pubishers, Subscribers and Distributors, then delve into the data delivery process with Publications, Subscriptions and Articles, finishing up with the Log Reader and how to make sure everything is working and running smoothly.

About Wendy:
Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.

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