The PASS Data Architecture Virtual Group focuses on data architecture concerns as they impact users, developers and DBAs on the Microsoft SQL Server platform.

2017 Speakers

Incremental Load Design Patterns

By Tim Mitchell

Incremental Load Design Patterns

 

When building extraction, transformation, and load (ETL) processes, one of the most common requirements is to process only new or changed data. This incremental load design significantly improves the performance of the ETL process by dealing only with a subset of the data during each load.

Choosing the correct change detection mechanism for each incremental load process is critical. From change data capture to change tracking in SQL Server, to the slowly changing dimension wizard and other native tools in SSIS, there are many ways to detect and process incremental changes.

In this session, we will review the common decision points surrounding incrementally loading data, and will walk through methods for incremental processing in SQL Server. Among the topics of discussion:

  • “Why not just do a full load?”

  • A survey of the various methods of change detection in SQL Server

  • Common incremental load design patterns for sources and destinations

  • Performance considerations for large incremental loads

This session is ideal for those with some experience performing ETL operations in SQL Server and SSIS, but can be useful as an overview for others who want to gain a general understanding of incremental load patterns.

 

Tim Mitchell, Microsoft Data Platform MVP

Principal Data Architect, Tyleris Data Solutions

 

 

Youtube link

 

https://youtu.be/pC6BaGxHloI

 

Real World Stories – Migrating SQL to Hyperconverged Infrastructure

 

By Ben Metcalf

May 25 2017 at 11 AM CDT

 

 

Ben Metcalf

Systems Administrator, Faith Technologies, Inc.

 

Imagine starting a new job where the infrastructure planning and purchasing decisions have been made and you’re forced to live with the consequences. Ben Metcalf was thrown into the hyperconverged infrastructure (HCI) arena when he accepted a job where his predecessors had already purchased HCI for an infrastructure refresh and SQL migration. Learn from his real world experience on what that journey entailed and the benefits his company has realized from migrating SQL Server to HCI.

 

Youtube Link    https://youtu.be/k_p7XTTNNco



How to Get Started Tuning SQL Server Performance

 Tuesday , March  14, 2017 1 PM CDT

 By Tim Radney

 

           Figuring out how to get started tuning SQL Server performance can feel overwhelming at first. Where do you start? What should you look at? In this session you'll learn a systematic approach to tuning SQL Server. First we'll cover common instance level settings that can have a significant impact on SQL Server performance. Then we'll cover how to collect I/O metrics and pinpoint databases that have the highest latencies plus how to collect and understand wait statistics. Finally, we'll cover how to find high-cost queries and discuss the importance of having a good baseline to measure all these things against. If you've been struggling to put together a performance-tuning process, this session is for you!

Tim Radney

SQLskills.com

Principal Consultant

 

Tim is a Data Platform MVP. He has presented at PASS, SQLintersection, SQL Saturdays, user groups and numerous webinars. In addition Tim runs the Columbus GA SQL Users Group, is a PASS Regional Mentor and was named a PASS Outstanding Volunteer in 2012. He’s married with three children and has a passion for electronics. He also farms chickens (for eggs), dwarf Nigerian goats, and tilapias in his spare time.


Email: 
Tim@SQLskills.com 
Website: 
http://www.SQLskills.com 

Full Bio: http://www.sqlskills.com/about/tim-radney/
Blog: 
http://www.SQLskills.com/blogs/tim
Twitter: 
http://twitter.com/TRadney
Microsoft 
MVP since 2014

 

Links from webinar

Wait Stats

https://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/

 

Wait Stats over Time

https://www.sqlskills.com/blogs/paul/capturing-wait-statistics-period-time/

 

File Stats

http://www.sqlskills.com/blogs/paul/how-to-examine-io-subsystem-latencies-from-within-sql-server/

 

File Stats Over Time

http://www.sqlskills.com/blogs/paul/capturing-io-latencies-period-time/

 

Modifications for using with Azure SQL Database

https://sqlperformance.com/2016/03/sql-performance/tuning-azure-sql-database


YouTube Link  https://youtu.be/RBTHWpPHBlo



Why Physical Database Design Matters

Feb 9, 2107, 1 PM CDT

By Kimberly L. Tripp

 

 

 

KIMBERLY L. TRIPP

SQLskills.com

President/Founder

Kimberly’s an author, consultant, and top-rated speaker having spoken at PASS, TechEd, SQLintersection, and numerous other events around the world; she’s also been a Microsoft SQL Server MVP for over 10 years. She has over 25 years of experience designing and tuning SQL Server solutions with a focus on optimizing procedural code, indexing strategies, statistics, and partitioning. When she's not tuning SQL servers, she's diving and photographing all sorts of underwater critters such as frogfish with her husband, Paul S. Randal.

Email: Kimberly@SQLskills.com

Website: http://www.SQLskills.com

Full Bio: http://www.sqlskills.com/about/kimberly-l-tripp/

Blog: http://www.SQLskills.com/blogs/Kimberly

Twitter: http://twitter.com/KimberlyLTripp

SQL Server MVP since 2002

 

 

Youtube Link https://youtu.be/H-jPsp2QlT0

 

 

Bryan Cafferky

SQL Server 2016 R Intergration

Jan 18, 2107, 1 PM CDT

About Bryan Cafferky...

 

Bryan is a 2016 MVP award winner and author of Pro PowerShell for Database Developers by Apress. He is an independent Business Intelligence/Data Science consultant with decades of experience in information technology focused on the Microsoft stack. Bryan has spoken on a number of subjects at various PASS chapters, Code Camps, and SQL Saturdays. He has worked in banking, insurance, Internet/Ecommerce, utilities, and health care. Bryan holds an undergraduate degree in Computer Information Systems from Bryant University and a Masters in Business Administration from Bentley University.

Youtube Link

https://youtu.be/h4681u6H8qM

Diving Deeper into Database Hardware

 

 by Glenn Berry

 

Wednesday, April 12, 2017 1 PM CDT

 

GLENN BERRY

SQLskills

Principal Consultant

Glenn is a Microsoft SQL Server MVP. He has worked as a SQL Server professional for many years in a variety of roles, including stints with NewsGator and Avalara. His expertise includes DMVs, high availability, hardware selection and configuration, and performance tuning. He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. Glenn is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQL Saturdays, SQLintersection, and the PASS Community Summit. He is the author of the book SQL Server Hardware, and he wrote chapters for SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2 books.

Email: Glenn@SQLskills.com 

Website: 
http://www.SQLskills.com

Full Bio: http://www.sqlskills.com/about/glenn-berry/

Blog: 
http://www.SQLskills.com/blogs/Glenn 

Twitter: 
http://twitter.com/GlennAlanBerry 

Microsoft 
MVP since 2007

Youtube Link https://youtu.be/1wFTcMftxJM

 

 

Back to Top