Managed a 30
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
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 https://youtu.be/Rbxyc2yK4JQ
2016 Noon CST
201: Selecting and Sizing Database Hardware for OLTP Performance
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
Wed, Feb 24, 2016 Noon CST
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.
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 LessThanDot.com blogger.
Jes frequently presents at user groups, SQLSaturday, and other community
9, 2016 Noon CST
Zero-Downtime Upgrades: Rockstar
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
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