Kevin Martin – Senior SQL Server DBA & Database Engineer

SQL Server Database Development Best Practices

Practical SQL Server database development standards, patterns, and findings covering database design, naming, tables, data types, T-SQL code, data quality, and development environments.

View Best Practices & Findings

sp_CRUDGen

Free open-source, metadata-driven SQL Server stored procedure generator that creates CRUD, UPSERT, and advanced safe dynamic-search stored procedures from database tables, relationships, and data types.

View GitHub Project

sp_Develop

Free open-source SQL Server development assessment that analyzes database objects for code smells, design issues, and best-practice violations. Built to make database code review and development standards repeatable for DBAs and software developers.

View Project Wiki

View GitHub Repo

Senior SQL Server DBA, Database Developer & Open Source Creator

Senior SQL Server DBA, database developer, database engineer, and data architect with 20+ years designing, tuning, modernizing, and operating enterprise database and data platforms. My deepest expertise includes SQL Server, T-SQL, database architecture and development, performance tuning, production troubleshooting, database administration (DBA), HA/DR, and Azure SQL.

I created the free open-source projects sp_Develop and sp_CRUDGen to turn practical SQL Server development standards and patterns into reusable tools. sp_Develop helps identify database code smells and design issues, while sp_CRUDGen uses database metadata to generate consistent, performant stored procedures.

I also write and speak about SQL Server database development, performance tuning, database design, engineering practices, and the lessons behind these projects.