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 95 Polybase

Episode 95 Polybase

Big data is term we have been hearing frequently as of late and this might cause some concern for us in the SQL Server space. Micrsoft has introduced some new functionality to help connect different ...

10 Mai 201751min

Episode 94 Qlik Technologies

Episode 94 Qlik Technologies

There are lots of reporting options and I watch SQL Server move up the Gartner magic quantrant, I saw another reporting tool moving up as well--Qlik. In this episode we will start by sharing informat...

3 Mai 201748min

Episode 93 Making Mistakes

Episode 93 Making Mistakes

We all make them and sometimes it can be painful. Making and sharing mistakes is one of the most powerful tools for learning; However, most of us do all they can to avoid and hide those mistakes. In...

26 Apr 201731min

Episode 92 SSDT

Episode 92 SSDT

At one time there were two different products named SSDT and that was confusing for lots of folks. and we're pleased to have Kevin Cunnane, the program manager for SSDT, as our guest. We wanted to as...

19 Apr 201743min

Episode 91 DBA Tools

Episode 91 DBA Tools

We all want an easy button. It is human nature. We heard quite a bit about how easy PowerShell will make everything, but for those of us who aren't programmers, it can be a bit intimidating to get s...

12 Apr 201750min

Episode 90 Check DBCC

Episode 90 Check DBCC

DBCC CheckDB. It is a simple command, but one that can cause database contention, dba stress, confusing results, dba elation, and everything in between. At one time we will all have to face the resu...

5 Apr 20171h 11min

Episode 89 Lone DBA

Episode 89 Lone DBA

One of the neat benefits of putting the podcast together is talking to a wide spectrum of folks with varied backgrounds. As we get more feedback from listeners, the idea of the Lone DBA emerged. The...

30 Mar 201751min

Episode 88 SharePoint

Episode 88 SharePoint

Why can't we just get along? There can be a real love/hate relationship between those of us with data responsibilities and those who are responsible for SharePoint environments. We want to provide go...

22 Mar 20171h

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
rss-kunsten-a-leve
merry-quizmas
gravid-uke-for-uke
hverdagspsyken
smart-forklart
hagespiren-podcast
rss-kull
lederskap-nhhs-podkast-om-ledelse
fryktlos
uroskolen