For the best web experience, please use IE11+, Chrome, Firefox, or Safari

Writing efficient code for SQL Server based applications

Quest® and MSSQLTips webcast: Writing efficient SQL code
On Demand
  • Recorded Date:Sept. 23, 2021
  • Event:On Demand
Quest® and MSSQLTips webcast: Writing efficient SQL code

Writing SQL code that works is easy with some basic experience. But we often fall into the habit of reusing the same techniques to write code that does the job but may not perform well.

Whether you’re writing your own code or copying and modifying code over time, it’s important to learn approaches that improve SQL code performance. In this Quest and MSSQLTips webcast, we’ll explore what you should be aware of when writing SQL code for your database applications.

You’ll learn how to:

  • Write efficient SQL code
  • Take advantage of SQL Server functions, stored procedures, triggers, indexes, CTEs, temp tables and options for tuning code
  • Implement development best practices that will help with your future database application projects


Brian Kelley is an author, columnist, Certified Information Systems Auditor (CISA) and former Microsoft Data Platform (SQL Server) MVP (2009-2016), focusing primarily on SQL Server and Windows security. Brian currently serves as a data architect as well as an independent infrastructure/security architect, concentrating on Active Directory, SQL Server and Windows Server. He has served in a myriad of other positions, including senior database administrator, data warehouse architect, web developer, incident response team lead and project manager. Brian has spoken at 24 Hours of PASS, IT/Dev Connections, SQLConnections, the Techno Security and Forensics Investigation Conference, the IT GRC Forum, SyntaxCon and at various SQL Saturdays, Code Camps and user groups.

Mathew Phan is a systems consultant with Quest Software. He began his career as a technical support engineer for Quest Software soon after graduating from the University of California, Irvine, where he obtained a bachelor's degree in computer and information science. Mathew has devoted his entire 16-year career at Quest to the Toad® by Quest® family of database solutions and held various positions, helping to shape the direction and growth of Toad. Early in his tenure, his focus was on databases from a developer and analyst point of view. Now, as a systems consultant, he continues to work with customers to build effective solutions to solve their database challenges, including DevOps and data prep.