The PASS Data Architecture Virtual Group focuses on data architecture concerns as they impact users, developers and DBAs on the Microsoft SQL Server platform.
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 email@example.com
How to Get Started Tuning SQL Server Performance
Tuesday , March 14, 2017 1 PM CDT
By Tim Radney
Figuring out how to get started tuning SQL Server performance can feel overwhelming at first. Where do you start? What should you look at? In this session you'll learn a systematic approach to tuning SQL Server. First we'll cover common instance level settings that can have a significant impact on SQL Server performance. Then we'll cover how to collect I/O metrics and pinpoint databases that have the highest latencies plus how to collect and understand wait statistics. Finally, we'll cover how to find high-cost queries and discuss the importance of having a good baseline to measure all these things against. If you've been struggling to put together a performance-tuning process, this session is for you!
Tim is a Data Platform MVP. He has presented at PASS, SQLintersection, SQL Saturdays, user groups and numerous webinars. In addition Tim runs the Columbus GA SQL Users Group, is a PASS Regional Mentor and was named a PASS Outstanding Volunteer in 2012. He’s married with three children and has a passion for electronics. He also farms chickens (for eggs), dwarf Nigerian goats, and tilapias in his spare time.
Full Bio: http://www.sqlskills.com/about/tim-radney/
Diving Deeper into Database Hardware
by Glenn Berry
Wednesday, April 12, 2017 1 PM CDT
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: http://www.sqlskills.com/about/glenn-berry/
GotoWebinar Link https://attendee.gotowebinar.com/register/6305653385748820225
Nutanix will host May Meeting
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
Nutanix is now the Data Architecture Virtual Chapter sponsor. http://bit.ly/sqlonnutanix
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 firstname.lastname@example.org or twitter is @DArchVC
Tweets about "#sqlpass"