SQL Server for Developers, Fast Focus Sessions

SQT05 Fast Focus: Common T-SQL Coding Mistakes and How to Fix Them

12/04/2018

1:30pm - 1:50pm

Level: Introductory to Intermediate

Amy Herold

Sr. Cloud Solution Architect-Engineering

Microsoft

If you have ever gone back and looked at code you wrote in the dark ages of your career, you're likely thinking how you would write it differently now that you have more experience. There are many different types of T-SQL coding mistakes - everyone makes them, but in this session we will talk about how we all can avoid them and write better T-SQL.

You will learn:

  • 5 different things to be looking for in poor performing code
  • Different methods for gathering performance metrics
  • New SQL Server features for troubleshooting query performance