Ohio North SQL Server User Group

Choose a meeting below to view its details


Meeting Archive

Tuesday,

October

01

ONSSUG Cleveland Meeting October 2019

  • In-Person @ 6161 Oaktree Blvd. Ste 300 Independence, Ohio, United States (map)
  • 17:00 - 19:30 Eastern Daylight Time
  • Language: English

Please RSVP!
This meeting will be held at McIntyre/Alliance, 6161 Oaktree Blvd. Ste 300 · Independence, OH 44131

For this session, we will watch a video from PASS Summit. If you arrive early, you may suggest a topic!

Lisa will catch us up on all the latest news and upcoming events from PASS. Also, the ONSSUG board is looking for some input on the planning of the next Cleveland SQL Saturday. Please join if you would like to weigh in.

Featured Presentation:

Understanding Execution Plans

Erin Stellato, Principal Consultant SQLskills

If you have struggled to understand why a query takes too long to execute, or don’t know where to start when a query requires a lot of I/O or consumes significant CPU, then we should talk about execution plans. When you write a query for SQL Server, you are asking the engine to return a specific set of data, but the optimizer decides how to get that information; an execution plan provides details about what SQL Server decided to do, and it’s a great place to start to understand why a query may not perform as you hoped or expected. This session will include numerous demos that show: - How to capture an execution plan - How to understand what objects are being accessed - The basic operations in a plan In the demos we will also highlight other valuable information in a plan and how to identify potential problems. You will leave the session with practical information about execution plans that you can put to use immediately when you’re back at your desk and looking at a query that just didn’t run the way you anticipated. About Erin Stellato: Erin is a Principal Consultant with SQLskills. Erin discovered a passion for all things data while completing her M.S. in Motor Control at the University of Michigan. As she entered the IT field, she discovered the power of relational databases. During her IT career, Erin has worked closely with customers, users and colleagues to support business solutions across a variety of industries including healthcare, insurance, finance, and government. These experiences provided opportunities to see varied implementations, troubleshoot hardware and software-related problems, give guidance on configuration and design, and provide consultation on optimization, availability, and recoverability. As a result, Erin’s interests include Internals, Statistics, Performance Tuning, Extended Events, and developing HA/DR solutions. More than anything though, she likes to know how SQL Server works, so she can fix it when it breaks. Erin is an active member of the SQL Server community. She has been involved with PASS at both the local and national level over the years, volunteering for committees and providing leadership for the Performance VC and the Ohio North SQL Server User Group. Erin also presents at user groups, SQLSaturdays, SQLIntersection and the PASS Summit, and blogs about her experiences at SQLskills.

About Erin:
Erin Stellato is a Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids