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

Thu, Feb 28 2013 12:00 (UTC-06:00) Central Time (US & Canada)

Neil Hambly on Think you have the right Data-Type?

RSVP: None

This month Confio DBA Neil Hambly presents Think you have the right Data-Type? He will talk about selecting the right Data-Type (DT) for data is key to efficient data storage, retrieval and processing, with over 30 different DT to choose from this isn’t as straight forward as you might think. Join us Feb 28th 2013 at noon central for a talk about data type design and decisions.

Think you have the right Data-Type?

Selecting the right Data-Type (DT) for data is key to efficient data storage, retrieval and processing, with over 30 different DT to choose from this isn’t as straight forward as you might think, have your also considered the usage pattern of the data in addition to its storage requirements This session explores the various data-types now available, we look at conversion’s between different DT’s as well as index sizes & effectiveness, compression and other factors can that influence these decisions, we finish off by discussing different approaches on ‘migrating’ a DT to a different DT, throughout the session we consider any performance considerations, such as when implicit conversions occur and more

Neil Hambly is the SQL Server Evangelist & lead consultant @ Northdoor PLC (MSFT Data Platform Gold partner), previous roles @ ABN AMRO, Accenture, ASOS, BBC, Confio Software with 15+ years in SQL Server roles Presented 100+ events, including 40 PASS Summit/24HOP/Rally/SQL Saturday, 15 European events (10 countries), 50 + UK (SQLBits, SQLRelay) Leader of PASS London (UK) & Professional Development VC, Melissa Data MVP (2015), SQL Cruise Technical Lead Likes Guinness, Loves Whisky, Dancing

PASS Summit Discount Code VC15FFM6

The cost of the PASS Summit is now $2195.00 until midnight PST 09/18/16. If you use our discount code,VC15FFM6, you can save an additional $150.00 to bring the cost down to $2045.00.

It will go up $200.00 after 09/18/16comes to a close.

If you are interested in presenting on Data Architecture topic, please submit your bio and abstract to



Silent Killers Lurking in Your Schema

October 11th 2016

9 pm CDT (**** UPDATED TIME ****)

By Mickey Stuewe

GotoWebinar Link



Considerations for deploying SQL Server with hyperconverged infrastructure solutions


Nov 9th 2016 Noon CDT



Hyperconverged platforms, where compute, storage and virtualization are combined into a single appliance, are becoming a popular mode for deploying infrastructure to support SQL Server installations.  This session will discuss the benefits, pitfalls and best practices of running SQL Server with hyperconverged solutions, including details on performance, sizing, data protection and high availability.




Mike McGhee

Sr. Technical Marketing Engineer, Nutanix

Mike has 17 years of experience in the IT industry and is currently focused on assisting customers and partners better understand the core functionality of the Nutanix platform.  Mike has responsibilities around stretched clustering solutions as well as the Microsoft ecosystem of products including Hyper-V.  Prior to Nutanix, Mike worked for EMC as a Systems Engineer with a focus on storage technologies and their intersection with hybrid clouds. Mike has several certifications including MCP, MCDBA and NPP.



GotoWebinar Link



John Sterrett

December 7th 2016 CDT Noon

Table Partitioning: Secret Weapon for Big Data Problems

Is big data starting to slow you down? Data growth putting your maintenance tasks in danger of not meeting your SLAs? Wish you could archive old data with minimal impact to your tables during the archive process or that you could eliminate most of the data in your tables when you query them? If so, it’s time you consider implementing table partitioning to help with general performance and reduce your window for completing maintenance tasks.

Come learn how table partitioning works and when it should be implemented. You’ll see how to initially configure partition functions and partition schemes to have a rock-solid partitioned table. And you’ll learn how to implement an automated sliding window to maintain your partitioned tables and ensure optimal performance.

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