Episode 254: Code Smell Checks with sp_Develop

Episode 254: Code Smell Checks with sp_Develop

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!

Avsnitt(287)

Episode 231: Mental Health and Wellness in IT

Episode 231: Mental Health and Wellness in IT

Everyone has bad days; however, how those bad days develop are unique to each of us. In a special episode, we chat with Tracy Boggiano about her experiences with Mental Health, how she has dealt with ...

11 Aug 202159min

Episode 230: RTO & RPO

Episode 230: RTO & RPO

No one wants to lose data when disaster strikes; however, we need to plan for some data loss and putting all the pieces in place can be tricky. There are two metrics commonly used to measure data loss...

4 Aug 202141min

Episode 229: Data Migration Assistant

Episode 229: Data Migration Assistant

The scary part of upgrading SQL Server is finding out you have a problem AFTER the fact. In this episode, Mariano Kovo joins us to discuss the Data Migration Assistant tool from Microsoft. While the n...

21 Juli 202143min

Episode 228: Predicting Application Problems with Database Metrics

Episode 228: Predicting Application Problems with Database Metrics

As data practitioners, we want to get ahead of any problems that might come up and share those insights with others on our team. In this episode, Edward Pollack gives us a few scenarios we might consi...

14 Juli 20211h 7min

Episode 227: SSDT Methodologies for DB DevOps

Episode 227: SSDT Methodologies for DB DevOps

Organizations look to constantly improve and offer better services and the application tooling has been built to accommodate the process. Database tooling has been a bit slower to develop; however, in...

23 Juni 20211h 9min

Episode 226: SQL Server IaaS Agent Extension

Episode 226: SQL Server IaaS Agent Extension

Let's say you have completed a lift and shift VM hosting to the cloud. Great—you now use Iaas services. While you don't have to worry about the hardware, managing the software can be problematic. T...

9 Juni 202158min

Episode 225: Dashboard Design Principles

Episode 225: Dashboard Design Principles

Have you ever created a report in a visualization tool, spent all this time and energy creating something that looked really cool, went through more edits than you could remember only to deliver the r...

26 Maj 202156min

Episode 224: The Standup Meeting

Episode 224: The Standup Meeting

Carlos, Kevin, and Eugene reconnect after some time away with a new streaming time.  Long form conversation on a single topic is also the place we want to get back to in our podcast.  The show notes a...

28 Apr 202124min

Populärt inom Utbildning

rss-bara-en-till-om-missbruk-medberoende-2
historiepodden-se
det-skaver
alska-oss
harrisons-dramatiska-historia
nu-blir-det-historia
not-fanny-anymore
johannes-hansen-podcast
roda-vita-rosen
sektledare
allt-du-velat-veta
rss-viktmedicinpodden
i-vantan-pa-katastrofen
sa-in-i-sjalen
rss-max-tant-med-max-villman
rss-sjalsligt-avkladd
rss-basta-livet
rss-om-vi-ska-vara-arliga
sex-pa-riktigt-med-marika-smith
rss-pa-insidan-med-bjorn-rudman