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 15 Working at a University

Episode 15 Working at a University

Corporate culture is a BIG deal when it comes to job satisfaction, and it is interesting to see how different sectors can be.  Today we talk with Doug Purnell, DBA at Elon College in North Carolina an...

28 Okt 201525min

Episode 14: SQL Server Clustering

Episode 14: SQL Server Clustering

Clustering is a now tried and true technology to help increase the availability of your SQL Server environment.  I talk with Paul Popovich about his experiences with clustering and how his approach ha...

21 Okt 201523min

Episode 13 Apply Yourself

Episode 13 Apply Yourself

I attended Kevin Feasel's SQLSaturday session entitled Apply Yourself and thought it was pretty funny. While not close friends, I have know Kevin for a while and knew he had good stuff. He there sha...

14 Okt 201530min

Episode 12: Database Corruption

Episode 12: Database Corruption

Database corruption is something that will eventually come to all data professionals.  While I have been fortunate to only come across is a handful of times, I was glad that I was able to get back the...

7 Okt 201531min

Episode 11: SQL Server Statistics

Episode 11: SQL Server Statistics

So it turns out an old dog can learn new tricks--or at least that is what happened to me when I chatted with Grant Fritchey from Red Gate software about SQL Server Statistics.  Always taking an opport...

30 Sep 201534min

Episode 10: Test Anxiety and Test Preparation

Episode 10: Test Anxiety and Test Preparation

We mix things up a bit as I chat with Thomas Frank from collegeinfogeek.com about test anxiety and test preparation.  Taking a test can be a big deal and it is always interesting to get other options ...

23 Sep 201532min

Episode 09: Database Automation

Episode 09: Database Automation

Joey D'Antoni has been doing quite a bit with database automation and I caught with him to discuss his experiences about how database automation has helped him be more efficient and have fewer support...

16 Sep 201529min

Episode 08: Database Design

Episode 08: Database Design

I chat will Louis Davidson about database design and get his thoughts on some strategies about how to go about making your design and what tools are available to help you.  It may surprise you that, a...

9 Sep 201533min

Populärt inom Utbildning

historiepodden-se
rss-bara-en-till-om-missbruk-medberoende-2
det-skaver
alska-oss
harrisons-dramatiska-historia
nu-blir-det-historia
not-fanny-anymore
roda-vita-rosen
johannes-hansen-podcast
rss-foraldramotet-bring-lagercrantz
rss-viktmedicinpodden
i-vantan-pa-katastrofen
sa-in-i-sjalen
sektledare
rss-max-tant-med-max-villman
allt-du-velat-veta
rikatillsammans-om-privatekonomi-rikedom-i-livet
rib-podcast
rss-sjalsligt-avkladd
rss-basta-livet