Speaker

Kevin Martin

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

Kevin works as a Senior Data Architect for the Custom Software Development and Database & Analytics services company named Emergent Software. Emergent is a Microsoft Triple-Gold Partner in Application Development, Cloud Platform, and Data Platform.

Contact Emergent if you need senior level database development or administration assistance, even if it is to cover you on your vacation so you can turn your mobile off. Tell them Kevin sent you.

Area of Expertise

  • Information & Communications Technology

Topics

  • Database Design
  • Database Administration
  • Database Development
  • Database and Cloud
  • Databases
  • Database
  • Azure SQL Database
  • Database and Analytics

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

December 2022

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