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

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.recruiterbox.com/jobs/fk0qhi7?s…

I added 'UPSERT Pattern' to sp_Develop as a best practice to follow for #sqlserver development. emergentsoftware.github.io/SQL-Server-Dev… github.com/EmergentSoftwa… #sql #sqldeveloper #databasedevelopment #tsql #databasedesign #sqldatabase #databasedeveloper

The data warehouse date and time key pattern was added to the free and open source sp_develop best practice project. emergentsoftware.github.io/SQL-Server-Dev… github.com/EmergentSoftwa… #databasedesign #sqldeveloper #databasedevelopment #sqldatabase #databasedeveloper #sqlserver #sqldba

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

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

A very cool open source project to watch for SQL Server: github.com/kevinmartintec…

Call for Speakers for #DataWeekender CU5 is open and I've just submitted a session! sessionize.com/dataweekender-…

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

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

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

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

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

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

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

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

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

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

In our latest blog post, Sr. Data Architect Kevin Martin (sp_Develop & sp_CRUDGen Author) 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