Episode 255: Automate Complex CRUD with sp_CRUDGen

Episode 255: Automate Complex CRUD with sp_CRUDGen

One of the biggest challenges with developers using object-relational mapping (ORM) tools is the bad queries or procedures they create. Sure, most tools can create CRUD (Create, Read, Update, Delete, Upsert) procedures, but what about the extremely advanced safe dynamic Search stored procedures? My bet is they are super inefficient and could be improved. In this episode of the SQL Data Partners Podcast, we talk with Kevin Martin, the creator of sp_CRUDGen, about how his procedure can help your developers create better CRUD-type stored procedures. As always, we are super excited about sharing what our great community is working on, and we think there will be value in the work Kevin has put together. Have you used sp_CRUDGen? We'd love to get your thoughts.

The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/10/05/episode-255-automate-complex-crud-with-sp_crudgen/. Have fun on the SQL Trail!

Episoder(287)

Episode 223: Podcast Update

Episode 223: Podcast Update

With both Kevin and Eugene busy this week, Carlos went solo to share a few changes to the podcast, including the Twitch livestream moving to Tuesday, how you can support the podcast, and podcast episo...

14 Apr 20219min

Episode 222: Azure Arc-enabled Data Services

Episode 222: Azure Arc-enabled Data Services

Azure Arc-enabled data services provide powerful capabilities to deploy and manage local, on-premises, and hybrid cloud data resources using the same centralized management and tooling you get from th...

24 Mar 20211h 4min

Episode 221: SQL Trail March 2021 Retrospective

Episode 221: SQL Trail March 2021 Retrospective

Virtual conferences are just not the same as the conferences we are used to, but we're still determined to provide a good learning and networking environment for our friends. We very much miss having...

22 Mar 202139min

Episode 220: Microsoft Ignite Recap

Episode 220: Microsoft Ignite Recap

As we prepare for SQL Trail on March 18th, we peek back at Microsoft Ignite and review the announcements made there—filtering out the pieces our compañeros will enjoy hearing about. Did we miss someth...

10 Mar 202145min

Episode 219: SQL Server Inventory

Episode 219: SQL Server Inventory

How do you document your SQL Server environments? I can remember walking through Brent Ozar's takeover script back in the day and how cumbersome it was to put all that information together. We have a ...

24 Feb 202147min

Episode 218: File Growths

Episode 218: File Growths

In this episode of the SQL Data Partners Podcast, Eugene and I go back to our DBA beginnings and talk about database file growth, how to manage files and how to tell when a file has grown. The show no...

17 Feb 202130min

Episode 217: A Little Something About A Few Things

Episode 217: A Little Something About A Few Things

The story begins with a process that has been running forever and suddenly decides to cause grief by filling up tempdb. We talk about patching, and we talk about mental health. We talk a little about ...

10 Feb 202134min

Episode 216: EDI vs ETL

Episode 216: EDI vs ETL

When working on a customer on an import process, she made the comment—if we were doing true EDI, we'd [Do X]. The comment got me thinking—Aren't we working on an EDI process? As someone who frequentl...

3 Feb 202132min

Populært innen Fakta

fastlegen
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
mikkels-paskenotter
foreldreradet
rss-strid-de-norske-borgerkrigene
treningspodden
rss-bisarr-historie
jakt-og-fiskepodden
takk-og-lov-med-anine-kierulf
sinnsyn
rss-sunn-okonomi
hverdagspsyken
tomprat-med-gunnar-tjomlid
gravid-uke-for-uke
fryktlos
hagespiren-podcast
level-up-med-anniken-binz
rss-kull
rss-bak-luftfarten