Using Dynamic SQL Effectively

Fox Valley Microsoft Data Platform Users Group
Fox Valley Microsoft Data Platform Users Group
Public group

Secura Insurance

6GP2+56 Fox Crossing · Menasha, wi

How to find us

We are on the first floor of the Secura building, in the "IT" meeting room off of the main entrance from the visitors parking lot.

Location image of event venue

Details

Please join us for "Using Dynamic SQL Effectively" with Jake Manske!

Jake is part of the Madison, WI PASS chapter, and can be found here: https://www.linkedin.com/in/jake-manske-32a6b8198/

A description of the talk:
"Dynamic SQL is a powerful tool that many applications use. Many of us are aware of the dangers of dynamic SQL, particularly SQL injection and plan cache bloat. Dynamic SQL is also inherently harder to troubleshoot than native SQL for functional and performance problems.

In this session, we will discuss how to use dynamic SQL effectively and correctly to avoid these and other dangers. We will discuss parameterized dynamic SQL, input validation and sanitation, and how to write your code so that it does not hinder troubleshooting. We will discuss suggestions that those who support application code can pass on to their development teams to incorporate into existing code.

Attendees will leave with the confidence and knowledge they need to develop and support application code that uses dynamic SQL effectively."

Schedule:
--5:30 PM: Food and networking
--6:00 PM: Presentation and discussion
--7:00 PM: Networking and discussion

If you would like to join us online, please connect to https://www.twitch.tv/fox_pass

Thanks and see you there!