Quad Cities PASS Chapter

EventDisplay

Meeting Details

Wednesday,

August

12

QCPASS Meeting - August 12, 2015

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

Topic:      PowerShell for the DBA

Speaker:  Pat Phelan

Pat Phelan joined a user group (DECUS) in High School, and many more since then. Pat was paid for his first program before he got his driver’s license. After many jobs (with some great stories) in High School and College, Pat worked over twenty years for a major accounting firm. Pat started working for Involta in 2007 and is now the database mentor and a member of the Engineering team.  Involta builds, owns and operates world class colocation datacenters and provides managed services and support staff to clients.


Featured Presentation:

PowerShell for the DBA

Pat Phelan, GIR Involta, LLC.

Learn about PowerShell for the DBA.

About Pat:
Pat Phelan first joined a computer user group (DECUS) in High School, and has joined many more since then. Pat worked many jobs in high school and college, and over twenty years for a major accounting firm. Pat started working for Involta in 2007 and is now the database mentor and a member of the Engineering team. Involta builds, owns and operates world class colocation datacenters and also provides managed services and support staff to clients.

EventArchive

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


 

 


 



 



 



 

 



 

 


 


 

 

 

 

 

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 









 















  

Curative Computers LLC

 

 


 

 

 

 

 


Back to Top