October 22, 2018 – T-SQL Performance Tuning (Full-day class)

T-SQL Performance Tuning

October 22, 2018 9:00am

Jes Borland

Jes Borland

Everyone that works with SQL Server writes T-SQL, including you. Do you understand how SQL Server interprets queries? Join me for a day of learning strategies for making queries faster and less resource-intensive using T-SQL. I’ll cover the basics such as the order of operations, CRUD statements, and joins. Then I’ll teach you how – and when! – to write aggregations, window functions, subqueries, views, and functions. This full day of T-SQL will refresh the basics and take you through advanced topics!

Instructor Bio

Jes Borland is a Premier Field Engineer – SQL Server for Microsoft, where she is a trusted technical adviser, deep technical support, and teacher for her customers. Her experience as a DBA, consultant, and 5-time Data Platform MVP allow her to help the business and the IT teams reach their goals. She has worked with SQL Server as a developer, report writer, DBA, and consultant. Her favorite topics are administration, automation, and performance. She is a former President of FoxPASS, founder of Tech on Tap, and a LessThanDot.com blogger. She frequently presents at user groups, SQL Saturdays, and other community events. She is also an avid runner and chef.

Important information:

This class is at the offices of Wayfair, upstairs from the Copley Place Mall, at 4 Copley Place, Boston. (Directions)

Due to building security at our meeting venue, attendees must be registered, and must present a valid photo ID to building security. Directions to the Wayfair offices can be found here.

Morning coffee, and lunch are provided as part of this class.