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

Upcoming Webinars


Phil Hummel – June 9 2015 12:00 CST



Architectural components that are

Critical to the success of

AFAs for SQL Server





All-flash arrays(AFAs) are a relatively new technology that is having a major impact on database design and operations. AFAs are especially useful in the case of a workload that looks like this:


         Large amounts of small block, random I/O

         Read intensive workloads

         Low I/O latency is required for application performance

         I/O bandwidth spikes in response to reporting or data extract needs

         The database(s) size is less than the capacity of an all-flash array


In this talk we will examine the architectural components that are critical to the success of AFAs for SQL Server applications including:


         Use of all commodity hardware to align to industry hardware advancements (i.e. Moore’s Law)

         Optimized software and hardware to fully utilize  performance of flash all the way to the applications/databases

         Scale-Out Design:  Should provide investment protection & linear scalability for both IOPS & capacity

         Active/Active Controllers:  Leverage all investments

         High Capacity Utilization (70+%):  Overhead should be minimized to allow growth/support for multiple applications


Speaker Bio:

Phil Hummel is a Solutions Architect on the EMC Microsoft Specialty Presales team.  He is responsible for developing and presenting demonstrations showing the integration of Microsoft enterprise software solutions with EMC storage hardware and software.  Phil has been working with SQL Server since 1998  in his role as a  Solutions Architect for marchFirst and then from 2001-2010 as a Technical Sales Professional for Microsoft.  He completed the Microsoft Certified Masters certification for SQL Server while working for Microsoft. Phil’s career prior to focusing on Microsoft SQL Server involved  writing software and managing projects for the electric power and natural gas industries focused on energy demand forecasting and the impacts of government sponsored energy efficiency programs.  He is a PASS member and speaks frequently at user groups in the Bay Area and a SQL Saturday – Silicon Valley.


GotoWebinar Link Click Below




Ryan Adams

July 15 2015 12:00 CST

Is AlwaysOn the Right High Availability and Disaster Recovery Plan for me?


You need a high availability and disaster recovery solution for your mission critical databases.  SQL Server AlwaysOn can help, but with Windows Clustering, Failover Cluster Instances, and Availability Groups, the choices get confusing and complicated quickly. This session will clear up all the confusion by explaining the various components and exposing all the gotchas.  You will learn how to choose the right level of protection for your environment.  You will walk away with the knowledge and confidence to pick the right solution to give your critical databases a solid high availability and disaster recovery plan.


 Speaker Bio:


Ryan Adams has worked for Verizon for 16 years. His primary focus is the SQL Server Engine, high availability, and disaster recovery.

Previously he was a Senior Active Directory Architect and designed the company's worldwide Active Directory infrastructure.

He serves on the Board of Directors for the North Texas SQL Server User Group and is President of the PASS Performance Virtual Chapter. He is also a PASS Regional Mentor and holds the following certifications: MCP MCSA MCSE MCDBA MCTS MCITP.


GotoWebinar Link Click Below





CEO / Owner

August 3 2015 12:00 CST

Index Fragmentation and Transaction Log Performance


Speaker Bio: 


Paul is a Microsoft SQL Server MVP and a Microsoft Regional Director. He spent 9 years working on the SQL Server team, writing DBCC CHECKDB, and ultimately responsible for the entire Storage Engine. In 2007 Paul left Microsoft to co-own and run, and is a world-renowned author, consultant, and top-rated speaker on SQL Server performance tuning, administration, internals, and HA/DR. When he's not tweeting, blogging, or helping someone recover from a disaster, he's likely to be underwater somewhere in the world with his wife, Kimberly L. Tripp.



Full Bio:



SQL Server MVP since 2008

GotoWebinar Link Click Below






PASS DAVC - Discount Code 


Save $150 by using the discount code VC15FFM6.



  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