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 NULL: Summer Break

Episode NULL: Summer Break

24 Juli 20191min

Episode 174: Power BI Report Server

Episode 174: Power BI Report Server

What do you do when you want to use the Visualizations of Power BI but management doesn't want to send company data to the cloud? Well, you can implement Power BI Report Server! In this episode we dis...

27 Juni 201931min

Episode 173: New Data Certifications

Episode 173: New Data Certifications

As the data platform continues to evolve, so do certifications. In this episode we chat with Rick Heiges about the new role-based certifications and how they fit into Microsoft's cloud platform. We re...

12 Juni 201936min

Episode 172: Power BI Monitoring

Episode 172: Power BI Monitoring

From a SQL Server perspective we have many ways to identify problem areas. In this episode, we discuss ways to diagnose performance issues in Power BI. They are certainly making many strides; however,...

5 Juni 201924min

Episode 171: SQL Server Encryption

Episode 171: SQL Server Encryption

You've got first name, last name, full name, birth date, address, email, phone, tax ID or Social Security Number, driver's license number, medical evaluation notes, MAC address, and IP address columns...

22 Maj 201933min

Episode 170: Devops with Power BI

Episode 170: Devops with Power BI

Two years ago blogger Jay Killeen observed, "And with modern languages and modern applications such as PowerBI and Power Query you should be safe to assume there would be modern tooling. You would be ...

15 Maj 201924min

Episode 169: Should you learn to code?

Episode 169: Should you learn to code?

These are dark times. Drastic measures must be taken. In this episode, we talk about--coding. *Queue scary music* Last year I bumped into Sean McCown and found out he had coded himself a GUI for his M...

8 Maj 201943min

Episode 168: Data Privacy Settings

Episode 168: Data Privacy Settings

One of the great abilities we have with Power BI is connecting to multiple data sources. Authors can actually publish data sources for others to use in their reports. Developers then get to mix and ma...

1 Maj 201919min

Populärt inom Utbildning

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