Would you be interested in a tool to help you do code review checks and provide developers guidance on best practices? In this episode of the SQL Data Partners Podcast, we talk with Kevin Martin, the creator of sp_Develop, about how his procedure can help you review naming conventions, table conventions, data type conventions, SQL code conventions, data issues, and even configuration issues. Kevin was approached about writing a best practice document but ended up writing a stored procedure you and I can use to help our environment. We love sharing what community members have done and hope you enjoy this conversation with Kevin on the tool. He is looking for folks to help him build out items, so if you have a suggestion, be sure to include it in GitHub.
The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/09/21/episode-254-code-smell-checks-with-sp_develop/. Have fun on the SQL Trail!
Episode 280: A Focus on Microsoft Fabric
Episode 279: SQL Server Migrations Demystified
Episode 278: Running SQL Server on Azure VMs
Episode 277: PostgreSQL for the SQL Server Crowd
Episode 276: Dynamic SQL and Testing in Isolation
Episode 275: Machine Learning and Power BI
Episode 274: A CMM Case Study
Episode 273: The Capability Maturity Model for Data Professionals
Episode 272: Performance Tuning Scripts
Episode 271: Pass Summit 2023 Wrap-Up
Episode 270: Medallion Architecture
Episode 269: Why Do I Need a Managed Service Provider?
Episode 268: AI and the Future of the Database
Episode 267: Microsoft Fabric
Episode 266: Working with Containers
Episode 265: WHY and What's Next
Episode 264: Verified Backups
Episode 263: SQL Server This ‘n That
Episode 262: Learning Azure Synapse Pt 1
Episode 261: The Data Lakehouse
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
Lex Fridman Podcast
All-In with Chamath, Jason, Sacks & Friedberg