March 17, 2015 Noon CST
Make SQL Server Queries Run Faster
Have you ever developed slowly running queries and wondered how to tune your SQL Server queries? In this session you will learn some T-SQL performance tuning tips from a DBA who has a developer background. We will go over how to identify bottleneck queries and how to measure them. We will go over basic indexing concepts for improving workloads. Finally, we will cover some coding patterns that are developer friendly but are not SQL Server database engine friendly and show you how to optimize them.
John Sterrett is a Group Principal and Sr. Consultant at Linchpin People. Previously, he was a Sr. Database Admin Advisor for Dell, directly responsible for several mission-critical databases behind dell.com. John has presented at many community events, including PASS Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a PASS Regional Mentor and founded WVPASS user group and the HADR Virtual Chapter.
Stringer - May 22 2015 12:00 CST
Troubleshooting SQL Server with Extended Events
Server is growing more complex and advanced as a database management system
with every new release and additional technology or functionality. With
the expanding responsibility on supporting and troubleshooting the SQL Server
environment in your organization, it is up to you to find the root cause of
problems and fix them with a proven solution to the given issue. The
hardest aspect of resolving problems is the troubleshooting step, but thankfully
SQL Server gives us the tools to be successful in pinpointing problems.
One of the most powerful tools is Extended Events, and it can be used to
troubleshoot a large array of problems, from errors to performance
bottlenecks. Join Thomas Stringer, a Microsoft SQL Server Premier Field
Engineer, as he dives into the finer points of the technology, and then shows
common troubleshooting scenarios that are often quickly resolved with Extended
Stringer is a SQL Server Premier Field Engineer at Microsoft, specializing in
high availability, disaster recovery, performance, administration, scripting
and automation (PowerShell), development (C/C++ and .NET/C#) and other aspects
of data. He can also be found contributing to the technical community,
speaking and writing about a variety of problems and solutions.
GotoWebinar Link Click Below
at passbaconference.com today!
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.
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.
at email@example.com or twitter is @DArchVC