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!

Avsnitt(286)

Episode 62: Ask Me Anything--Cortana Intelligence Suite

Episode 62: Ask Me Anything--Cortana Intelligence Suite

Have you heard the buzz around the Cortana Intelligence Suite? It seems like it is all the rage these days and Microsoft is coming out with lots of new features in this space. In Episode 62, Steve and I interview Melissa Coates, AKA “SQLChick”. We chat about the history of Cortana, about the tools it encompasses, and why you might implement parts of the suite in your organization. Show notes for today's episode are found at http://sqldatapartners.com/cortana If you are using Cortana, we would love to hear about it on the show notes for today's episode.

21 Sep 201634min

Episode 61: The Debrief

Episode 61: The Debrief

Do you dread the idea of going to the project post-mortem?  Is it because you have to spend tons of time prepping your defenses for the onslaught?  This week we chat with Russ Thomas and get his take on what makes a good debrief and where he got some of his ideas.  These concepts are intended to make the whole team better so if you like what you hear, pass this along to other in your group and perhaps your debriefs can help everyone. The show notes for today's episodes are at http://sqldatapartners.com/2016/09/05/debrief/ where you can get links to information Russ points to in this episode.  Have fun on the SQL trail compañeros!

14 Sep 201647min

Episode 60: What is U-SQL?

Episode 60: What is U-SQL?

When Microsoft introduced the Azure Data Lake, they included a new language, U-SQL, for Big Data processing as part of the Cortana Intelligence Suite.  U-SQL plays a role in the streaming analytics space–primarily in the Azure environment.  We break down some of the basics of U-SQL, then we’ll discuss the use cases that might make it an effective addition to your database toolbox--especially if you know C#.   The show notes for today's episode can be found at http:\\sqldatapartners.com\usql  Have fun on the SQL trail, compañeros!

7 Sep 201639min

Episode 59: Mirroring, Availability Groups, Replication, and Log shipping

Episode 59: Mirroring, Availability Groups, Replication, and Log shipping

Have you ever wondered what the best option is for making your data available in your environment? Listener Chris Hendon asked us to talk about differences between Availability groups, mirroring, log shipping, and replication. Today on the SQL Trail Steve and I chat with Andy Mallon and Mariano Kovo about these topics. We cover each topic in detail and explain the positives and negatives of each one.  Join us, for another great episode. The show notes for today's episode are available at http://sqldatapartners.com/2016/08/24/data-availability/

31 Aug 201649min

Episode 58: 4 ways to stay sharp with technical learning

Episode 58: 4 ways to stay sharp with technical learning

With all the changes in technology, how do you stay up to date with your technical learning?  This is a question we have been asking our guests the last several episodes and in this episode we, the hosts, attempt to answer this question and Carlos and Steve give some thoughts on how we stay up to date.  We discuss four ways to keep up.  If all else fails, you can follow this old adage.  "It's know WHAT you know, it's not WHO you know--it's WHAT you know about WHO you know."    The show notes for today's episode can be found at http://sqldatapartners.com/learning.

24 Aug 201626min

Episode 57: What SQL Server feature would you change?

Episode 57: What SQL Server feature would you change?

Compañeros, in Episode 57 of the SQL Data Partners Podcast we take a page from the SQL Server Radio podcast where they list the 50 worst feature and discuss SQLFamily question 2 about what SQL Server features we think could improve. We talk about the redundancy of default maintenance plans, the pain of autogrowth and autoshrink, why NO LOCK hints shouldn't be used, what's so bad about Activity Monitor, and more.  It should be noted here, that we LOVE SQL Server, we just being a bit picky with some of the tools.  :) What feature do you want to change? Do you disagree with our list?  Let us know on the show notes page or using the hastag #SQLPodcast The show notes for today's episode are at http://sqldatapartners.com/worstfeatures

17 Aug 201639min

Episode 56: What is your favorite SQL Server 2016 Feature?

Episode 56: What is your favorite SQL Server 2016 Feature?

I found myself in Columbus Ohio at the SQLSaturday event and thought I'd do a live panel discussion about our Favorite SQL Server 2016 Features--what we are most excited about.   We also discuss the "Microsoft paradigm shift" and how the hybrid model is likely to stick around for a long time.  Oh, and Scott Klein from Channel 9 shows up and gives us his two cents.  You just never know what is going to come out of the wood work.

10 Aug 201640min

Episode 55: The new and improved SQL Server Reporting Services

Episode 55: The new and improved SQL Server Reporting Services

SQL Server reporting services hasn't changed in what seems like 10 years.  The rest of the reporting environment at Microsoft has seen some MEGA changes and it seems like we could use a few updates to the environment.  Our guest this episode is Jessica Moss, a data architect and Microsoft MVP.  She gets us up to speed on what we can expect in the new version and how this ties into the other changes Microsoft is making.  The show notes for today's show can be found at http://sqldatapartners.com/jessica and we'll see you on the SQL trail.

3 Aug 201641min

Populärt inom Utbildning

bygga-at-idioter
historiepodden-se
det-skaver
rss-bara-en-till-om-missbruk-medberoende-2
alska-oss
nu-blir-det-historia
harrisons-dramatiska-historia
svd-ledarredaktionen
johannes-hansen-podcast
allt-du-velat-veta
not-fanny-anymore
roda-vita-rosen
rikatillsammans-om-privatekonomi-rikedom-i-livet
rosceremoni
sa-in-i-sjalen
sektledare
rss-max-tant-med-max-villman
i-vantan-pa-katastrofen
rss-sjalsligt-avkladd
jagaren