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.
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 https://t.co/6Fjdjq6JrM
Session Overview:
https://t.co/i38yaOtHVL
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: https://t.co/kIDenl6l3V
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!
https://t.co/FOP1u1VvYx
#customsoftware#customdevelopment#softwareconsulting
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: https://t.co/JFbv4u77fk
#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.
https://t.co/NSf2UHDicf
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.
https://t.co/cWBlbhCeey
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.
https://t.co/Mzj6PFjvmF
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.
https://t.co/COKPZU8GrZ
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.
https://t.co/u6xUf55tJg
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. https://t.co/ISMcaKyHbG