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

News and Updates

 

EmailSignature

Call for Speakers and Volunteers

We are looking for presenters for the Data Architecture Virtual Chapter. Whether you have 10 minutes worth to discuss on a specific insight, or a raft of full-length decks ready to roll, we want to hear from you.

EMail us at davc@pass.org

EventDisplay

Real World Stories – Migrating SQL to Hyperconverged Infrastructure By Ben Metcalf

Thu, May 25 2017 11:00 Central Daylight Time

RSVP: https://attendee.gotowebinar.com/register/7176865719682924034

Incremental Load Design Patterns By Tim Mitchell

Wed, Jun 14 2017 13:00 Central Daylight Time

RSVP: https://attendee.gotowebinar.com/register/4187334284782256643

R Intro and basic predictive model creation by Bryan Cafferky

Wed, Jul 12 2017 13:00 Central Daylight Time

RSVP: https://attendee.gotowebinar.com/register/1751065006815729409

Optimizing Stored Procedures by Kimberly L. Tripp

Wed, Nov 08 2017 13:00 (UTC-06:00) Central Time (US & Canada)

RSVP: https://attendee.gotowebinar.com/register/6343521666827249153

 

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.

GotoWebinar Link https://attendee.gotowebinar.com/register/7176865719682924034

 

 

 

 

 

Nutanix is now the Data Architecture Virtual Chapter sponsor. http://bit.ly/sqlonnutanix

 

 

Incremental Load Design Patterns

By Tim Mitchell

June 14, 2017 at 1 Pm CDT

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:

n “Why not just do a full load?”

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

n Common incremental load design patterns for sources and destinations

n 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

 

GotoWebinar Link https://attendee.gotowebinar.com/register/4187334284782256643

 

 

Bryan Cafferky

R Intro and basic predictive model creation

 

July 12, 2017, 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.

GotoWebinar Link https://attendee.gotowebinar.com/register/1751065006815729409

 

Optimizing Stored Procedures

by Kimberly L. Tripp

Nov 8, 2017, 1 PM CDT

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

 

GotoWebinar Link

https://attendee.gotowebinar.com/register/6343521666827249153

 

Data Architecture underpins just about everything we do in IT. Without a clear understanding of how data is structured, there is no reliable way to derive meaning from it. Data Architecture drives the design and governance of data systems, and thus should be of interest to any data professional. Data Architecture provides the blue-prints that we all share, whether we be DBAs, data integration developers, database developers, data warehousing professionals, data presentation developers or client-side application developers persisting data for later retrieval.

 

 

Back to Top