Kevin Martin (sp_Develop & sp_CRUDGen Author)

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]

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

[Emergent Software @emergentsw]

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

[Umbraco HQ @umbraco]

Next up is the best editing experience! The winner is… 🥁 @emergentsw for their work on https://t.co/lVkFFxfdpb! 🎉

Congrats on the #Umbraco award!

#UmbracoAwards2022
#Codegarden

[Emergent Software @emergentsw]

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

[Kevin Martin (sp_Develop & sp_CRUDGen Author) @KevinMartinTech]

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

[Emergent Software @emergentsw]

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

[Kevin Martin (sp_Develop & sp_CRUDGen Author) @KevinMartinTech]

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

[Kevin Martin (sp_Develop & sp_CRUDGen Author) @KevinMartinTech]

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 https://t.co/J3ER53DGPd with everyone.

#sql #sqlserver #sqldeveloper #sqldatabase #sqlqueries

[Kevin Martin (sp_Develop & sp_CRUDGen Author) @KevinMartinTech]

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

[Kevin Martin (sp_Develop & sp_CRUDGen Author) @KevinMartinTech]

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

[Kevin Martin (sp_Develop & sp_CRUDGen Author) @KevinMartinTech]

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

[Kevin Martin (sp_Develop & sp_CRUDGen Author) @KevinMartinTech]

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

[Kevin Martin (sp_Develop & sp_CRUDGen Author) @KevinMartinTech]

Call for Speakers for GroupBy Conference - May 2022 is open and I've just submitted a session! https://t.co/JAASvdCNuq

[Kevin Martin (sp_Develop & sp_CRUDGen Author) @KevinMartinTech]

Call for Speakers for #DataWeekender CU5 is open and I've just submitted a session! https://t.co/ersCJUWr5k

[Darling Data @erikdarlingdata]

A very cool open source project to watch for SQL Server: https://t.co/3dqQgTupQ6

[Kevin Martin (sp_Develop & sp_CRUDGen Author) @KevinMartinTech]

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

[Kevin Martin (sp_Develop & sp_CRUDGen Author) @KevinMartinTech]

Call for Speakers for DataMinutes #1 is open and I've just submitted a session! https://t.co/zlFa5rU9lx

[Kevin Martin (sp_Develop & sp_CRUDGen Author) @KevinMartinTech]

The data warehouse date and time key pattern was added to the free and open source sp_develop best practice project.

https://t.co/bVmrWL8Et5

https://t.co/P4cGh4os6J

#databasedesign #sqldeveloper #databasedevelopment #sqldatabase #databasedeveloper #sqlserver #sqldba

[Kevin Martin (sp_Develop & sp_CRUDGen Author) @KevinMartinTech]

I added 'UPSERT Pattern' to sp_Develop as a best practice to follow for #sqlserver development.

https://t.co/D3HJQ0Lz7h

https://t.co/P4cGh46Rfb

#sql #sqldeveloper #databasedevelopment #tsql #databasedesign #sqldatabase #databasedeveloper

[Kevin Martin (sp_Develop & sp_CRUDGen Author) @KevinMartinTech]

I’m #hiring for a Senior SQL Server Guru (SQL Developer & DBA) at Emergent Software.

#sqlserver #dba #sqldba #sqldba #sqldatabase #sqldeveloper #tsql #databasedevelopment #microsoftsqlserver

https://t.co/XgkRs3dcKv

[Kevin Martin (sp_Develop & sp_CRUDGen Author) @KevinMartinTech]

I’m #hiring for a Senior SQL Server Guru (SQL Developer & DBA) at Emergent Software. #sql #databasedevelopment #databasedesign #tsql #dba #sqldatabase #sqldeveloper #sqldba #sqlserver #microsoftsqlserver https://t.co/FHGzl1RUJC