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 195: Understanding DAX
Episode 194: PolyBase Use Cases
Episode 193: Power BI Premium
Episode 192: The DBA is Dead! Long Live the DBA!
Episode 191: Power BI Row-Level Security
Episode 190: SQL Server 2019
Episode 189: Power BI Common Data Model
Episode 188: Databricks
Episode 187: Power BI Performance Tuning
Episode 186: Analytics & Security: Find Pain Points, Make a Plan
Episode 185: DBATools in a Month of Lunches
Episode 184: Where do people get stuck with Power BI?
Episode 183: SQL Server Big Data Clusters
Episode 182: XEvents
Episode 181: Paginated Reports in Power BI
Episode 180: PolyBase in SQL Server 2019
Episode 179: SQL Trail Recap & Buying Power BI
Episode 178: Database Design
Episode 177: Lock Pages in Memory
Episode 176: Power BI Storage Options
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
Acquired