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 247: Pushing the Boundaries or Pushing Your Luck

Episode 247: Pushing the Boundaries or Pushing Your Luck

IT workers will generally claim they like learning new technology—it is almost a required attribute.  Why then is bringing in new technology so hard?  In this episode, we explore how new technologies ...

15 Jun 202235min

Episode 246: Microsoft Build 2022 Announcements

Episode 246: Microsoft Build 2022 Announcements

While we continue to review the new features of the CTP preview of SQL Server 2022, we turn our attention to the recent Microsoft Build conference and talk about some of the announcements made. We tr...

8 Jun 202229min

Episode 245: Tooling Updates

Episode 245: Tooling Updates

SQL Server Management Studio (SSMS) version 18 was introduced to support SQL Server 2019 and in this episode of the podcast, we discuss some of the new updates available in SSMS and Azure Data Studio....

20 Apr 202239min

Episode 244: Extended Events vs SQL Server Audit

Episode 244: Extended Events vs SQL Server Audit

Who made that change?  It is one of those questions that can send chills down the spine of those responsible for databases.  In this episode, Josephine Bush talks with us about how we can use a combin...

30 Mar 20221h 6min

Episode 243: Choosing What Content To Focus On

Episode 243: Choosing What Content To Focus On

Conferences are on the uptick as COVID restrictions lift and we are excited for the upcoming year. After Eugene's return from SQLBits my thoughts revolved around what I wanted to learn this year at co...

16 Mar 202242min

Episode 242: Upgrading Your SQL Server

Episode 242: Upgrading Your SQL Server

SQL Server 2012 is end of life later this year. I feel too young for this to be happening—it seems like only last year SQL Server 2005 came out. In this episode of the podcast, we talk about upgradi...

2 Feb 202250min

Episode 241: Replicating Data with Azure SQL Data Sync

Episode 241: Replicating Data with Azure SQL Data Sync

Do you find you need to keep SQL Server tables in sync across multiple systems?  After several projects involving syncing data, we return to the topic of Azure SQL Data Sync with some real world examp...

20 Jan 202238min

Episode 240: Azure Synapse Link

Episode 240: Azure Synapse Link

Azure Synapse Link is a feature coming to SQL Server in the next release. While there are few details on what the new feature will look like, we discuss how this same service is implemented in other A...

5 Jan 202234min

Populært innen Fakta

fastlegen
mikkels-paskenotter
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
foreldreradet
treningspodden
rss-strid-de-norske-borgerkrigene
jakt-og-fiskepodden
takk-og-lov-med-anine-kierulf
sinnsyn
hverdagspsyken
rss-bisarr-historie
gravid-uke-for-uke
rss-kunsten-a-leve
tomprat-med-gunnar-tjomlid
rss-sunn-okonomi
rss-kull
hagespiren-podcast
fryktlos
rss-var-forste-kaffe