Emergent Software Blog

Kevin Martin

sp_CRUDGen: A Practical Real-World SQL Server Example

By Kevin Martin - Wednesday, July 06, 2022

sp_CRUDGen is a free open-source SQL Server stored procedure that generates stored procedures based on your tables and metadata like foreign keys and data types. The generated stored procedure code utilizes the SQL Server community best practices.

Understanding Business Data Warehouses & Reporting Types

By Kevin Martin - Wednesday, December 09, 2020

You may have heard of data warehouses but aren't sure if your company needs them. Let's explore each piece that makes up your business data.

Using ID for Primary Key Column Name Database Development Best Practice | sp_Develop

By Kevin Martin - Wednesday, November 18, 2020

The open-source project contains a stored procedure named sp_Develop that can be used by developers for performing database code (smell) assessments.

Why Choosing a Part-Time Database Consultant Over a DBA May Be a Smart Business Move For You

By Kevin Martin - Wednesday, April 22, 2020

DBAs with the added bonus of consulting experience have deep exposure across many systems, allowing them to bring more immediate value to your situation.

Choosing Between a Full Time DBA or Consultant: Which Is Right for You?

By Kevin Martin - Wednesday, February 05, 2020

A company that houses data to run their business needs a skilled DBA to setup, backup, and secure databases. But, do you need a full-time DBA?

About Kevin Martin

Kevin is a Senior Data Architect on the SQL Server database development & administration team. He specializes in database architecture, development, reporting and performance tuning.

Top Categories

About Emergent Software

Emergent Software offers a full set of software-based services from custom software development to ongoing system maintenance & support serving clients from all industries in the Twin Cities metro, greater Minnesota and throughout the country.

Learn more about our team.

Let's Talk About Your Project

A software development and consulting company serving clients from all industries in the Twin Cities metro, greater Minnesota and throughout the country.

Microsoft Cloud Solutions Partner Top Software Developers