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.
Twin Cities, Minnesota
Joined August 2020
- Tweets28
- Following86
- Followers170
- Likes28
Pinned Tweet
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_crudg…
Kevin Martin (sp_Develop & sp_CRUDGen Author) retweeted
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) retweeted
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) retweeted
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
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/#:~:tex…
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
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
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
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
Call for Speakers for GroupBy Conference - May 2022 is open and I've just submitted a session! sessionize.com/groupby-confe…
Call for Speakers for #DataWeekender CU5 is open and I've just submitted a session! sessionize.com/dataweekender…
Kevin Martin (sp_Develop & sp_CRUDGen Author) retweeted
A very cool open source project to watch for SQL Server: github.com/kevinmartintech/s…
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
Call for Speakers for DataMinutes #1 is open and I've just submitted a session! sessionize.com/DataMinutes
The data warehouse date and time key pattern was added to the free and open source sp_develop best practice project.
emergentsoftware.github.io/S…
github.com/EmergentSoftware/…
#databasedesign #sqldeveloper #databasedevelopment #sqldatabase #databasedeveloper #sqlserver #sqldba
I added 'UPSERT Pattern' to sp_Develop as a best practice to follow for #sqlserver development.
emergentsoftware.github.io/S…
github.com/EmergentSoftware/…
#sql #sqldeveloper #databasedevelopment #tsql #databasedesign #sqldatabase #databasedeveloper
I’m #hiring for a Senior SQL Server Guru (SQL Developer & DBA) at Emergent Software.
#sqlserver #dba #sqldba #sqldba #sqldatabase #sqldeveloper #tsql #databasedevelopment #microsoftsqlserver
emergentsoftware.recruiterbo…
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 lnkd.in/dQtZVet