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



March 17, 2015 Noon CST

John Sterrett

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.

Bio

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.

Goto Webinar Link

https://attendee.gotowebinar.com/register/8127983942485757954



 





Upcomming Webinars

April Robert Davis

Thomas Stringer - May 22 2015 12:00 CST

Troubleshooting SQL Server with Extended Events

                                                                                              

Description:

SQL 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 Events.

 

Speaker Bio:

Thomas 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

 https://attendee.gotowebinar.com/register/84140490081630978

 

Register at passbaconference.com today!

Discount Code

CODE: BAVCAR

 

 

 

  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 davc@sqlpass.org or twitter is @DArchVC