Kevin Martin
Author of the open source projects sp_Develop and sp _CRUDGen, used by database developers and software developers. Find it on GitHub.
Minneapolis, Minnesota, United States
Actions
Kevin works as a Senior DBA Developer at Venture Solutions.
Links
Area of Expertise
Topics
sp_CRUDGen – How to generate and use the Search Stored Procedure AKA (Kitchen Sink)
Tired of writing stored procedures where it feels like you are writing the same code over and over again? Need to develop an optional parameter or kitchen sink stored procedure because users want a “does everything report”? If so, attend my presentation to see what I built that will save you massive amounts of time!
sp_CRUDGen (https://kevinmartin.tech/go/sp_crudgen) is a free open-source SQL Server stored procedure that generates stored procedures for you based on your tables and metadata like foreign keys and data types. The generated stored procedure code utilizes the SQL Server community best practices.
You can use sp_CRUDGen to generate 11 different stored procedures from basic your Create, Read, Update, Delete, Upsert stored procedures to extremely advanced safe dynamic search stored procedures otherwise known as optional parameters, kitchen sink, Swiss army knife, catch-all queries.
The generated ‘Search’ (kitchen sink, optional parameters) stored procedure is the most exciting. sp_CRUDGen generates this dynamic, safe, and performant TSQL stored procedure for you. This will be the main stored procedure covered in this presentation.
sp_CRUDGen will auto-generate and regenerate stored procedures for you. If you want to customize one of the generated stored procedures, you can remove "auto-generated" comment section and the stored procedure will not be overwritten.
This project is being used by software developers and DBAs at the consulting company I work for. It saves massive amounts of development time and conforms to best practices.
sp_Develop - SQL Server Development Assessment
The open source SQL Server Development Assessment project contains the sp_Develop stored procedure. It can be used by database developers, software developers and for performing database code (smell) assessments to adhere to best practices.
Documentation Website: https://kevinmartin.tech/go/sp_Develop-wiki
GitHub Repo: https://kevinmartin.tech/go/sp_Develop-github
Blog Articles: https://kevinmartin.tech/go/sp_Develop-blog
COVID-19 Data Warehouse
Interested in seeing how a data warehouse was built for a State agency that tracked positive COVID-19 tests?
I'll will give a high level demo of ingesting COVID-19 testing results data, dimension mapping, archiving source data files, SSIS logging, and SSIS package deployment.
15-20 minute session.
SQLSaturday MN 2022 Sessionize Event
Kevin Martin
Author of the open source projects sp_Develop and sp _CRUDGen, used by database developers and software developers. Find it on GitHub.
Minneapolis, Minnesota, United States
Links
Actions
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top