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 159: Power BI Dataflows

Episode 159: Power BI Dataflows

So what happens when you want to use data from two different sources, manipulate it (transform it) and then present the data in Power BI -- and you don't know how to use SSIS? Well, it turns out you c...

6 Feb 201945min

Episode 158: Gateways

Episode 158: Gateways

For only 10 bucks a month you can start visualizing your data and finally get the dashboard your executives have been waiting for!! What's that? You need to refresh the data--perhaps even multiple tim...

24 Jan 201935min

Episode 157: Windows Server Core

Episode 157: Windows Server Core

I can still remember working in high school when you had to 'dial in' to the internet and Microsoft bought the rights to the Rolling Stones song 'Start Me Up' for the release of their highly anticipat...

10 Jan 201933min

Episode 156: Social Intelligence

Episode 156: Social Intelligence

How well do you connect with others? We generally think pretty good of ourselves and at first glance you may give yourself a pretty high score.  While there is no test you can take to compare your res...

2 Jan 201946min

Episode 155: Data Science

Episode 155: Data Science

Do you want to be a data scientist? Do you even know what data science is? In this episode, we tackle the idea of being a data scientist and discuss the criteria and what it may take to get the job de...

13 Des 201840min

Episode 154: Test Driven Development

Episode 154: Test Driven Development

Who hasn't had a deployment go a bit sideways?  For all the talk of DevOps these days, the ability to push out code can still be challenging.  When I heard David Moore, our guest today, talk about the...

21 Nov 201841min

Episode 153: SQL Trail 2018 Retrospective

Episode 153: SQL Trail 2018 Retrospective

Year Two of our beautiful idea--gather together with a group of podcast listeners in a conference type format and find ways for us to connect and help each other grow. I am influenced by what I see i...

7 Nov 201820min

Episode 152: Do you use Analysis Services?

Episode 152: Do you use Analysis Services?

Those trained in SSAS may cringe a bit, but a curious thought entered my mind.  Many organizations start using data warehouse structure with fact and dimension tables, but never make it to the 'cube' ...

1 Nov 201844min

Populært innen Fakta

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