Discover this podcast and so much more

Podcasts are free to enjoy without a subscription. We also offer ebooks, audiobooks, and so much more for just $11.99/month.

Good Practices for Software Development

Good Practices for Software Development

FromVoice of the DBA


Good Practices for Software Development

FromVoice of the DBA

ratings:
Length:
2 minutes
Released:
Apr 24, 2014
Format:
Podcast episode

Description

Would you post your password on a wall in your office? Of course not, because other employees, the cleaning crew, even guests walking around your office would be able to access your system with your account. When I read Brian Kelly's post on passwords in files, that's what I thought of. Sticking credentials in a file, where they're subject to any kind of search, is a bad idea.
However this happens all the time. Combine this with a few other "common practices" like using sa to connect to a database and building dynamic SQL, and you might as well just set blank passwords and invite someone to have fun with your database. It's sad that we continue to see these types of software development practices in 2014, and especially poor to see them from companies that sell software.
 
Read the rest of "Good Practices for Software Development" at SQLServerCentral.
Released:
Apr 24, 2014
Format:
Podcast episode

Titles in the series (89)

A series of episodes that look at databases and the world from a data professional's viewpoint. Written and recorded by Steve Jones, editor of SQLServerCentral and The Voice of the DBA.