PASS DAVC - Discount Code
JOIN US AT THE PASS COMMUNITY SUMMIT IN SEATTLE, WA OCTOBER 27 - 30, 2015
Save $150 by using the discount code VC15FFM6.
2015 Noon CST
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
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
Jan 19, 2016 Noon CST
Hardware 201: Selecting and Sizing Database Hardware for OLTP
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
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/
Microsoft MVP since 2007
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