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!
Episode 36: SQL Server Virtual Machines in Azure
Episode 35: Position Yourself to Better Opportunities
Episode 34: In-Memory Tables
Episode 33: From Developer To DBA
Episode 32: Up Your Game With PowerShell!
Episode 31: What Has Virtualization Done To My Database?
Episode 30: The Best Investment You Can Make
Episode 29: You Thinking What I Am Thinking?
Episode 28: How Do You Know There Is A Problem? Baselines!
Episode 27: Testing Changes Before You Break Production
Episode 26: DevOps for the Database--Everyone is Doing it, Right?
Episode 25: Stretch Database
Episode 24 Query Store
Episode 23: IO, IO, It’s Off to Tune We Go
Episode 22: Eight Years of sp_whoisactive
Episode 21: Azure Data Factory
Episode 20: the Role of Mentors
Episode 19: How Solid State Disks Can Help SQL Server
Episode 18: BIML
Episode 17: Partitioning
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
Lex Fridman Podcast