KevinMartinTech's profile picture. Data architect consultant and author of the open-source projects sp _CRUDGen and sp_Develop, used by database and software developers. Find them on GitHub.

Kevin Martin (sp_Develop & sp_CRUDGen Author)

@KevinMartinTech

Data architect consultant and author of the open-source projects sp _CRUDGen and sp_Develop, used by database and software developers. Find them on GitHub.

Pinned

I'm speaking at #DataWeekender CU5 about generating search, create, read, update, & delete stored procedures (Track 6) on May 14th 9:20 AM CT. It is a free online event, so sign up at meetup.com/DataWeekender Session Overview: kevinmartin.tech/go/sp_crudgen_…


Kevin Martin (sp_Develop & sp_CRUDGen Author) reposted

In our latest blog post, Sr. Data Architect @KevinMartinTech walks us through a practical, real-world example of sp_CRUDGen, a free open-source #SQLServer stored procedure that he has developed in his spare time. Way to go, Kevin! 👏 ⬇️⬇️⬇️ Read now: bit.ly/3Pdjsqd

emergentsw's tweet image. In our latest blog post, Sr. Data Architect @KevinMartinTech walks us through a practical, real-world example of sp_CRUDGen, a free open-source #SQLServer stored procedure that he has developed in his spare time. Way to go, Kevin! 👏

⬇️⬇️⬇️

Read now: bit.ly/3Pdjsqd

Kevin Martin (sp_Develop & sp_CRUDGen Author) reposted

Next up is the best editing experience! The winner is… 🥁 @emergentsw for their work on kalahariresorts.com! 🎉 Congrats on the #Umbraco award! #UmbracoAwards2022 #Codegarden

umbraco's tweet image. Next up is the best editing experience! The winner is… 🥁 @emergentsw for their work on kalahariresorts.com! 🎉

Congrats on the #Umbraco award!

#UmbracoAwards2022
#Codegarden

Kevin Martin (sp_Develop & sp_CRUDGen Author) reposted

A BIG thank you to our amazing clients for all of the wonderful Google reviews. We are both humbled and honored that you put your trust in us for your custom software development & consulting needs! bit.ly/3LaPeCm #customsoftware #customdevelopment #softwareconsulting

emergentsw's tweet image. A BIG thank you to our amazing clients for all of the wonderful Google reviews. We are both humbled and honored that you put your trust in us for your custom software development & consulting needs!

bit.ly/3LaPeCm

#customsoftware #customdevelopment #softwareconsulting

I didn't think anyone would notice me hanging out with my buddy Chewbacca in the bottom right!

On the 3rd Wed. of every month, our team takes a break from their busy schedules to learn from one another. Now that's #teamwork! We're hiring! Check out our careers page at: bit.ly/3jDkdL8 #devlife #developerjobs #developercareers

emergentsw's tweet image. On the 3rd Wed. of every month, our team takes a break from their busy schedules to learn from one another. Now that's #teamwork!

We're hiring! Check out our careers page at: bit.ly/3jDkdL8

#devlife #developerjobs #developercareers


Please vote for my session 'sp_CRUDGen – How to generate and use the Search Stored Procedure AKA (Kitchen Sink)' for @GroupByConf Americas. My session will show you how to create stored procedures like a dynamic (kitchen sink) search. groupby.org/vote-now/#:~:t…

groupby.org

Vote - GroupBy

Group By offers free online training for Data professionals. Anyone can submit a session for GroupBy, and community votes decide who presents a session!


Just submitted my speaking proposal for #PASSDataCommunitySummit. This year's PASS Data Community Summit will be made up of some of the leading data experts. Hope to share spcrudgen.org with everyone. #sql #sqlserver #sqldeveloper #sqldatabase #sqlqueries


How to Sort (Order By) columns with the search stored procedure in sp_CRUDGen. The generated search stored procedure allows for multicolumn sorting by passing in JSON to the @OrderColumns parameter. Watch the demo video below. youtu.be/_We1J12dMzE

KevinMartinTech's tweet card. sp_CRUDGen - Sorting Order By with the Search Stored Procedure AKA...

youtube.com

YouTube

sp_CRUDGen - Sorting Order By with the Search Stored Procedure AKA...


You can time travel search with the dynamically generated search stored procedure with sp_CRUDGen. If you have a system-versioned temporal table included in the search stored procedure, you will have parameters that will allow you to time travel. youtu.be/LyBLQgDMcfA

KevinMartinTech's tweet card. sp_CRUDGen - Temporal Tables with the Search Stored Procedure AKA...

youtube.com

YouTube

sp_CRUDGen - Temporal Tables with the Search Stored Procedure AKA...


Database Views are now supported with sp_CRUDGen. You might have a need for a more complex table join so a view can be your best option to generate a search stored procedure (Kitchen Sink). Watch the demo video below. youtu.be/jmD6Se8KX48

KevinMartinTech's tweet card. sp_CRUDGen - Views with the Search Stored Procedure AKA (Kitchen Sink)

youtube.com

YouTube

sp_CRUDGen - Views with the Search Stored Procedure AKA (Kitchen Sink)


Your Table Per Type (TPT) inherited tables are now supported with sp_CRUDGen. When your tables are built with Table Per Type (TPT) polymorphic association, sp_CRUDGen will add them to the dynamic search stored procedure. Watch the demo video below. youtu.be/_l1TLEjPVTQ

KevinMartinTech's tweet card. sp_CRUDGen - Inherited Tables with the Search Stored Procedure AKA...

youtube.com

YouTube

sp_CRUDGen - Inherited Tables with the Search Stored Procedure AKA...


Call for Speakers for GroupBy Conference - May 2022 is open and I've just submitted a session! sessionize.com/groupby-confer…


I just uploaded an overview video explaining how the #sqlserver stored procedure I created named sp_CRUDGen can create a search (optional parameters, kitchen sink, Swiss army knife, catch-all queries) stored procedure plus 10 others. youtu.be/HYCKyRi8k6w

KevinMartinTech's tweet card. sp_CRUDGen - How to use the Search Stored Procedure AKA (Kitchen Sink)

youtube.com

YouTube

sp_CRUDGen - How to use the Search Stored Procedure AKA (Kitchen Sink)


Call for Speakers for DataMinutes #1 is open and I've just submitted a session! sessionize.com/DataMinutes


Loading...

Something went wrong.


Something went wrong.