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



Dec 9 2015, Wed Noon CST

Eric Peterson: SQL Server 2016: What’s New

  • Database table/column Masking

  • Row Level security

  • Temporal tables

  • Full setup scripts and examples for each of the technical features


  • Over 30 years of database experience

  • IBM IDMS, DB2, Oracle, Sybase and SQL Server

  • 10 Years as a lead architect for Sybase Professional Services

  • 22 Years SQL Server experience ( 4.2 and beyond)

  • DBA, Programing, design

  • HA ( replication, clustering, AlwaysOn)

  • Managed a 30 TB database


    Goto Webinar Link


    Dec 16, 2015 Noon CST

    Grant Fritchey: Getting Started Reading Execution Plans Part 2

     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

    PART 2 - Gotowebinar Link

     Part I You Tube 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




    Wed, Feb 24, 2016 Noon CST

    Minimize Data Loss

    By Jes Borland



    Data loss can strike any server at any time. Are you prepared for the inevitable? A good DBA takes regular backups and practices regular restores; a great DBA has advanced restore techniques planned and tested. In this session, I will demonstrate three advanced restore methods that can make you a great DBA - point-in-time restores, page restores, and piecemeal restores, and will discuss the appropriate situations when each should be considered. Attend this session to better protect your business and your job.



    Jes Borland is a Senior SQL Engineer at Concurrency and a Microsoft SQL Server MVP. She holds an AAS - Programmer/Analyst degree and has worked with SQL Server as a developer, report writer, DBA, and consultant. She is an active member of PASS, founder of FoxPASS in northeast Wisconsin, and a blogger. Jes frequently presents at user groups, SQLSaturday, and other community events.







    March 9, 2016 Noon CST

    Zero-Downtime Upgrades: Rockstar DBA

    By Argenis Fernandez



    SQL Server upgrades bring enticing new features and much needed enhancements, but can you perform them while maintaining high availability of your SQL Server infrastructure?

    You can actually do this by leveraging rolling upgrades, which are upgrades performed with minimal downtime or service disruptions.

    In this session you will:

    * Understand how rolling upgrades are better than in place upgrades

    * Learn how to use database mirroring or AlwaysOn Availability Groups for rolling upgrades

    * Explore how you might use Log Shipping to perform a simpler type of rolling upgrade

    This is a demo-intensive session, so you can see rolling upgrades live and up close.

    If you are considering upgrading to a major version of SQL Server, or just applying a Service Pack or a Cumulative Update, this session is for you!


    Argenis Fernandez is a SQL Server MVP and SQL Server Solutions Architect for Pure Storage. He has worked with SQL Server for over 17 years and enjoys high-end OLTP databases, virtualization, performance troubleshooting, high availability, disaster recovery, best practices, and dealing with hard problems. Previously a Senior Consultant for Microsoft, he is also a Microsoft Certified Master, founder of the PASS Security Virtual Chapter, and an active member of the SQL Server community.




      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