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


PASS DAVC - Discount Code 


Save $150 by using the discount code VC15FFM6.


Oct 6, 2015 Noon CST

Ryan Adams

Install an AlwaysOn Failover Cluster and Availability Group

Abstract:  You have decided to install and deploy a Failover Clustered Instance (FCI) and an Availability Group and you don't know where to start. This is a complicated architecture with many moving parts (including Windows Clustering) and you are overwhelmed.  How do you install these features? This session will walk you through a complete AlwaysOn environment where we will install and configure an AlwaysOn FCI and an AlwaysOn Availability Group across 5 nodes.  We will use both the GUI and T-SQL so you know how, why, and when to use each method.


Webinar Link


Nov 12, 2015 Noon CST

Grant Fritchey

Getting Started Reading Execution Plans


This session will provide you with a simple set of tasks to get you started reading execution plans.

The best way to understand why your query is running slow is to look at the execution plan. But, knowing how to get started in execution plans, what to look for, what's important can all be terribly confusing. This session will provide you with a simple set of tasks to get you started reading execution plans. You'll learn where to start, what to look for first, and you'll be better prepared to tune your queries. We'll also look at some methods you can use to write queries against the plans themselves in order to more easily and quickly identify potential issues within your plans. The information presented will be immediately applicable on the queries you have running back in the office.

You will learn:

•Understand how to get useful information out of execution plans

•Learn where to look at execution plans to understand what things are, what they mean, and what they're doing to the data

•To make appropriate changes to improve performance on your queries

Webinar Link




Jan 19, 2016 Noon CST

Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance

By Glenn Berry


The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don't let this happen to you! This session covers current and upcoming hardware from Intel and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads.






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.




Full Bio:



 MVP since 2007




Gotowebinar Link



  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.

The PASS Data Architecture Virtual Chapter will focus on data architecture concerns as they impact users, developers and DBAs on the Microsoft SQL Server platform. We want to make data architecture accessible to all data practitioners, and drive the point home that Data Architecture is a set of practices and a body of knowledge that overlaps almost all database professionals to some degree.

Email us at or twitter is @DArchVC