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 231: Mental Health and Wellness in IT

Episode 231: Mental Health and Wellness in IT

Everyone has bad days; however, how those bad days develop are unique to each of us. In a special episode, we chat with Tracy Boggiano about her experiences with Mental Health, how she has dealt with ...

11 Aug 202159min

Episode 230: RTO & RPO

Episode 230: RTO & RPO

No one wants to lose data when disaster strikes; however, we need to plan for some data loss and putting all the pieces in place can be tricky. There are two metrics commonly used to measure data loss...

4 Aug 202141min

Episode 229: Data Migration Assistant

Episode 229: Data Migration Assistant

The scary part of upgrading SQL Server is finding out you have a problem AFTER the fact. In this episode, Mariano Kovo joins us to discuss the Data Migration Assistant tool from Microsoft. While the n...

21 Jul 202143min

Episode 228: Predicting Application Problems with Database Metrics

Episode 228: Predicting Application Problems with Database Metrics

As data practitioners, we want to get ahead of any problems that might come up and share those insights with others on our team. In this episode, Edward Pollack gives us a few scenarios we might consi...

14 Jul 20211h 7min

Episode 227: SSDT Methodologies for DB DevOps

Episode 227: SSDT Methodologies for DB DevOps

Organizations look to constantly improve and offer better services and the application tooling has been built to accommodate the process. Database tooling has been a bit slower to develop; however, in...

23 Jun 20211h 9min

Episode 226: SQL Server IaaS Agent Extension

Episode 226: SQL Server IaaS Agent Extension

Let's say you have completed a lift and shift VM hosting to the cloud. Great—you now use Iaas services. While you don't have to worry about the hardware, managing the software can be problematic. T...

9 Jun 202158min

Episode 225: Dashboard Design Principles

Episode 225: Dashboard Design Principles

Have you ever created a report in a visualization tool, spent all this time and energy creating something that looked really cool, went through more edits than you could remember only to deliver the r...

26 Mai 202156min

Episode 224: The Standup Meeting

Episode 224: The Standup Meeting

Carlos, Kevin, and Eugene reconnect after some time away with a new streaming time.  Long form conversation on a single topic is also the place we want to get back to in our podcast.  The show notes a...

28 Apr 202124min

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
rss-bak-luftfarten
ukast
lederskap-nhhs-podkast-om-ledelse
level-up-med-anniken-binz