Episode 276: Dynamic SQL and Testing in Isolation

Episode 276: Dynamic SQL and Testing in Isolation

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!

Episoder(287)

Episode 143: Transitioning from DBA to Data Warehouse Architect

Episode 143: Transitioning from DBA to Data Warehouse Architect

We frequently talk about how many DBAs are concerned our job may be phased out in the future. This episode discusses one common career path in going from DBA to Data Warehouse Architect and we talk wi...

9 Aug 201841min

Episode 142: Do You Have a HEAP of Hurting?

Episode 142: Do You Have a HEAP of Hurting?

Are you giving yourself a HEAP of trouble by using tables with no clustered indexes?  But it is faster you say . . . because you don't have to worry about the sorting when inserting.  Our guest Rick L...

26 Jul 201832min

Episode 141: Wait, Wait, What?

Episode 141: Wait, Wait, What?

In this episode, we chat with David Maxwell about wait stats, what they are and why we should care about them. There are so many different directions we can go and if you have a specific use case you'...

4 Jul 201841min

Episode 140: Why data types matter

Episode 140: Why data types matter

They're just numbers, right?  A date's a date.  It's just string data, who cares?  I admit I have posed those questions before and only much later did I understand how complicated it can get. Angela H...

20 Jun 201850min

Episode 139: Getting Started with SQL Server in Azure

Episode 139: Getting Started with SQL Server in Azure

"The move to the cloud is inevitable."  Listening to Microsoft marketing and all the MVPs out there, it can certainly seem like we are getting further and further behind each day we aren't use cloud s...

13 Jun 201848min

Episode 138: Meeting of the Minds

Episode 138: Meeting of the Minds

I invited our fearless panelists Kevin Feasel and Eugene Meidinger to join me for a podcast discussion.  We couldn't agree on a topic so we'll just call this episode Meeting of the Minds.  You're welc...

6 Jun 201838min

Episode 137: You want to work with Analytics?

Episode 137: You want to work with Analytics?

What's in a name? That which we call a rose, by Any Other Name would smell as sweet. We could say the same for analytics -- there are plenty of similar or related words we use to describe the role or...

31 Mai 201858min

Episode 136: Devops with Visual Studio

Episode 136: Devops with Visual Studio

Everybody does things a little differently and this is one of the things I LOVE about the podcast--chatting with others about how they get work done.  In this episode I chat with Tom Norman about how ...

23 Mai 201848min

Populært innen Fakta

fastlegen
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
rss-strid-de-norske-borgerkrigene
treningspodden
rss-sunn-okonomi
foreldreradet
jakt-og-fiskepodden
takk-og-lov-med-anine-kierulf
merry-quizmas
sinnsyn
smart-forklart
lederskap-nhhs-podkast-om-ledelse
rss-kunsten-a-leve
hverdagspsyken
gravid-uke-for-uke
level-up-med-anniken-binz
rss-kull
fryktlos
hagespiren-podcast