SQLSat Madison Pre-Con: Make Me a Tuning Believer w/Jes Borland & Ted Krueger
Friday, March 28, 2014 from 8:30 AM to 4:00 PM (CDT)
San Francisco, California
London, United Kingdom
Expand your SQLSaturday #287 Madison experience with one of our amazing pre-conference sessions!
Are you an accidental DBA or developer that has been told to make a T-SQL query run faster? How many times have you heard complaints from the business about a report taking 5 minutes, 10 minutes, or longer to run? Have you found yourself lost in the mix of execution plan operations and indexing and scans?
Come to this class to build your query and execution plan tuning skills from beginning to end. We’ll focus on the everyday DBA’s and developer’s needs for tuning, and build up to more advanced methods which can be taken directly to work and bring immediate improvements in performance.
The workshop will show you skills and tools that revolve around what you will see most commonly in any business, such as:
- The life cycle of a transaction
- Preventing bad T-SQL coding practices
- Reading an Execution Plan
- Plan Cache and Monitoring
- Execution Plan Tuning
- Capturing bad execution plans that need to be tuned
You'll also have plenty of time to ask your questions and get answers!
About The Instructors
Jes Schultz Borland is a consultant with Brent Ozar Unlimited 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, President of FoxPASS in northeast Wisconsin, founder of Tech on Tap, and a LessThanDot.com blogger. Jes frequently presents at user groups, SQLSaturdays, and other community events. She is also an avid runner and chef. Reach her on Twitter at @grrl_geek
Ted Krueger has been working in development and database administration for over a decade. Ted currently works for a respected consulting company, BlueMetal Architects as a valued Data Architect. He is a PASS Region Mentor, Friends of Red Gate member, Author, SQL Server MVP and community mentor. Ted blogs and is also one of the founders of LessThanDot Technical Community. Reach him on Twitter at @onpnt
When & Where
SQL Saturday Madison
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. We're hosting a SQLSaturday in Madison, WI for the third year running, so see our website for more information!