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!

Avsnitt(287)

Episode 206: .NET Core Interactions with SQL Server

Episode 206: .NET Core Interactions with SQL Server

There are many programming languages available to the modern developer and there are even more options for connecting to the database. In this episode, we talk with Taurius Litvinavicius about his Man...

17 Sep 202038min

Episode 205: Data Modeling for Power BI

Episode 205: Data Modeling for Power BI

Power BI is founded on the idea of self-service BI and Excel is the most common data source in the world. While Power BI can import that information with ease, the data may not be in the best format. ...

3 Sep 202035min

Episode 204: IoT in Azure

Episode 204: IoT in Azure

A variety of devices now have the ability to report metrics about status, performance, or other sensor information. Collecting this information and making it useful in business operations can be diffi...

19 Aug 202026min

Episode 203: Spark in Action

Episode 203: Spark in Action

As we stretch the technology stack in this episode, I rely on my trusty co-hosts to get us through. Kevin and Jean-Georges Perrin do a great job giving us their thoughts on Spark. I hope you will enjo...

7 Aug 202045min

Episode 202: Virtual Conferences

Episode 202: Virtual Conferences

As COVID-19 prevents us from gathering in the same place, how do organizers continue to put on compelling events? This strikes home as SQL Data Partners consider whether to have our SQL Trail event th...

23 Juli 202050min

Episode 201: Common Data Model

Episode 201: Common Data Model

After we recorded Episode 189, we knew we lacked some of the business reasons behind the Common Data Model. Luckily, we reached out Tricia Wilcox-Almas and she has helped us fill in some of the gaps a...

9 Juli 202037min

Episode 200: Anything but the Cowboys . . .

Episode 200: Anything but the Cowboys . . .

To celebrate our 200th episode, we reached out to Bob Ward to come and celebrate this milestone with us. I have to plead the 5th on why it took us 200 episodes to finally invite him; however, we final...

25 Juni 202052min

Episode 199: Technical Debt

Episode 199: Technical Debt

We can incur technical debt in several ways—aging technology, choosing delivery speed over scale architecture, or implementing new technology the entire team cannot yet support. I don't know that I've...

30 Apr 202050min

Populärt inom Utbildning

rss-bara-en-till-om-missbruk-medberoende-2
historiepodden-se
det-skaver
harrisons-dramatiska-historia
allt-du-velat-veta
nu-blir-det-historia
johannes-hansen-podcast
roda-vita-rosen
rss-viktmedicinpodden
rss-foraldramotet-bring-lagercrantz
sektledare
i-vantan-pa-katastrofen
not-fanny-anymore
sa-in-i-sjalen
rss-max-tant-med-max-villman
rss-sjalsligt-avkladd
rss-basta-livet
rss-traningsklubben
rikatillsammans-om-privatekonomi-rikedom-i-livet
alska-oss