TSQL Coding Techniques, Are you Playing with Fire?

Venue: The University of Texas at Dallas - 800 Franklyn Jenifer Drive, Richardson, TX 75080 March 15-16, 2018

The good news? T-SQL is one of the easiest coding languages to learn. The bad news? Writing scalable T-SQL that performs optimally is an art that takes years to master. In this session, learn about some common T-SQL Troublemakers - Looping, Scalar Functions, Implicit Conversions, Non-Parameterized SQL, and Parameter Sniffing. Through examples and demos in this session you will witness the situational pitfalls of the techniques above. With each demo, you will be given an alternate T-SQL solution that solves the same problem in an efficient and scalable manner. Let's get things moving!


Track Details

  • Day: March 15, 2018 (01:00-01:50 pm)

Mindy Curnutt

Speaker: Mindy Curnutt

Mindy Curnutt is an Independent Consultant, 4X Microsoft Data Platform MVP and Idera ACE. She has been actively involved in the SQL Server Community for over nearly 20 years, presenting at local, regional and national events all across North America. For the last five years Mindy has been a key member of the Program Management Team for the SQL PASS Summit. She was a SME for a couple of the SQL 2012 and 2014 Microsoft SQL Server Cert Exams and helped to author the MS Press Book "SQL Server 2014 - Step by Step". This year She co-authored two soon to be released books, "SQL Server 2017 - Inside Out" and "Let Her Finish: Voices from the Data Platform". She is currently serving on the Board for the North Texas SQL Server User's Group and championing the Girls + Data Program in the Dallas area (a program for teens).