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 158: Gateways
Episode 157: Windows Server Core
Episode 156: Social Intelligence
Episode 155: Data Science
Episode 154: Test Driven Development
Episode 153: SQL Trail 2018 Retrospective
Episode 152: Do you use Analysis Services?
Episode 151: Azure SQL Database Managed Instance
Episode 150: The SQL Data Partners Team
Episode 149: Managing lots of databases
Episode 148: High Performance SSRS
Episode 147: Always Encrypted
Episode 146: SQL Trail Speakers
Episode 145: Is SSIS still relevant? Part 2
Episode 144: Is SSIS still relevant? Part 1
Episode 143: Transitioning from DBA to Data Warehouse Architect
Episode 142: Do You Have a HEAP of Hurting?
Episode 141: Wait, Wait, What?
Episode 140: Why data types matter
Episode 139: Getting Started with SQL Server in Azure
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
Lex Fridman Podcast