Event link at our Meetup page.

• 5:30 Networking
• 6:00 Meeting

Mastering Dynamic SQL

Dynamic SQL has a bad reputation. Some of it is even deserved. However, dynamic SQL can be a great tool to have in your toolbox when used correctly.

In this session, we’ll dive into creating and troubleshooting dynamic SQL syntax. We will start by examining various scenarios that would be good candidates for implementation. Then we’ll take a look at how it executes under the covers. We’ll discuss ways of smarter and safer ways of crafting our SQL statements. And of course, we will discuss various ways to debug the statements as well as add error handling.

You will leave this session with a better understanding and appreciation for how dynamic SQL works as well as why and when to use it.

Deborah Melkin

Deborah Melkin has been working as a database professional with SQL Server for over 20 years. She spends her days helping coworkers with all aspects of database design, queries, performance, documentation, and deployment. In 2016, she began her blog, Deb the DBA. Soon after that, she began speaking at SQL Saturdays and user groups. Deborah is a board member of the New England SQL Server User group (NESQL) and a member of the Azure Data Community Advisory Council. She was named “One To Watch” as part of the #Redgate100 and won Speaker Idol at PASS Summit 2019. Deborah is also a Microsoft MVP for the Data Platform.

In her spare time, Deborah can usually be found doing something musical or doing something geeky with her husband, Andy, and dog, Sebastian.

---