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 135: Seinfeld Episode

Episode 135: Seinfeld Episode

Normally we have one specific topic we focus on each episode.  This episode is a little different. The show notes for today's episode can be found at http://sqldatapartners.com/2018/05/16/episode-135-...

16 Mai 201819min

Episode 134: CosmosDB

Episode 134: CosmosDB

It is not very often the internal codename is used when a product is launched; however, when you think about a database designed with global distribution in mind, CosmosDB makes sense.  I was a bit sh...

9 Mai 201849min

Episode 133: Shrinking Files

Episode 133: Shrinking Files

While the ability to shrink data files is available in SSMS, the conventional wisdom is don't do it.  I was extremely curious when I read an email from our guest suggesting the opposite.  In this epis...

3 Mai 201835min

Episode 132: What technologists can learn from superheroes

Episode 132: What technologists can learn from superheroes

Bang! Pow! Crash!  Besides just awesome fighting techniques, are there things we can learn from superheroes?  My guest, Will Fehringer, gave that very question some thought and came up with some very ...

19 Apr 201828min

Episode 131: Big Data Solutions in the Cloud

Episode 131: Big Data Solutions in the Cloud

Big Data.  Do you have big data?  What does that even mean?  In this episode I explore some of the concepts of how organizations can manage their data and what questions you might need to ask before y...

11 Apr 201845min

Episode 130: Use Case for PowerShell

Episode 130: Use Case for PowerShell

Heroes in a half shell, PowerShell!  Well, maybe that wasn't the original line, but you know from this program and other places on the internet, PowerShell is all the rage.  In this episode, we wanted...

4 Apr 201831min

Episode 129: Graph Databases

Episode 129: Graph Databases

Books online state: "There is nothing a graph database can achieve, which cannot be achieved using a relational database." Why then are we putting graph technology in SQL Server? To help me answer th...

28 Mar 201832min

Episode 128: Database Doing DevOps

Episode 128: Database Doing DevOps

To Devops or not to Devops, that is the question. We've talked before about how the developers have all the cool new tools, but this is slowly changing. For those in development or dare I say agile ...

21 Mar 201842min

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