Skip to content
Episode 276: Dynamic SQL and Testing in Isolation episode artwork

May 21, 2024 41 min

Episode 276: Dynamic SQL and Testing in Isolation

from SQL Data Partners Podcast Hosted by Carlos L. Chacon

Listener beware! This episode is full of danger as we tackle an interesting use case for Dynamic SQL. Dynamic SQL generally has a bad reputation in SQL Server circles, and with good reason. Dynamic SQL can open the door to many undesirable results - SQL Injection attacks being the most frightening of these. It can also be difficult to read, making maintenance problematic; however, in this episode one brave soul - Marathon's own Laura Moss - explains how she uses Dynamic SQL to help refresh a subset of production data to be used in their development environments. You know we are always suckers for an interesting use case and Laura delivers big time. While you won't be able to plug and play her example into your environment, we hope it gets the wheels turning if you struggle to update your test environments. Have you found a way to use Dynamic SQL as a tool for good and not evil? Did you get any good take-aways from today's podcast or have some questions? Leave us a comment and some love ❤️ on LinkedIn, Twitter/X, Facebook, or Instagram. The show notes for today's episode can be found at Episode 276: Dynamic SQL and Testing in Isolation. Have fun on the SQL Trail!

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

Episode 276: Dynamic SQL and Testing in Isolation

0:00 41:46

No transcript yet.

Requests help us decide what to transcribe next.

Share this episode

Similar podcasts

The Course Mentors Podcast The Course Mentors Hey there, future course creator! Ever feel like turning your know-how into an online course is like trying to solve a Rubik's cube blindfolded? Well, grab your headphones because "The Course Mentors Podcast" is here to be your secret weapon! Meet Aimee and Odette (that's us!), your new best friends in the course creation world. We've been in the trenches for over a decade, and for the last five years, we've been rocking the online course space. Now we're here to spill all our secrets in bite-sized, 15-20 minute episodes that'll fit perfectly in your coffee breaks. No fluff, no filler - just real, actionable advice that'll take you from "um, what's a landing page?" to "holy moly, I just hit six figures!". We're talking everything from crafting your course to marketing it like a pro and building a business that'll have you pinching yourself. Whether you're dreaming of ditching the 9-to-5 grind, adding a sweet extra income str

Frequently asked questions

How long is this episode of SQL Data Partners Podcast?

This episode is 41 minutes long.

When was this SQL Data Partners Podcast episode published?

This episode was published on May 21, 2024.

Can I download this SQL Data Partners Podcast episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.