Never Again

Which One Is for Production?

Better make sure...especially when you're working with credit card information.

At my first job as a DBA and developer, I was working on an application designed to automatically charge credit cards. I was provided with a set of credit-card numbers to use for testing.

I edited some customer records in the development database to use the test numbers and submitted charges to the bank to test the application. However, I failed to change the connection string to point to the development database, so I was running up some huge bills on a few customer accounts before I caught my mistake. I contacted the bank and got them to back the charges out before they went through or appeared on anyone's statements, but I never heard if I obligated enough credit that anyone had real transactions declined.

What's Your Worst IT Nightmare?

Write up your story in 300-600 words and e-mail it to Editor at Large Jeff Schwartz at jschwartz@redmondmag.com. Use "Never Again" as the subject line and be sure to include your contact information for story verification.

I was saved by the fact that I immediately recognized my error. The development database was simply a restored backup of the production database and our volume was low enough so that the credit-card information was unchanged since the backup was made. I was able to update the production data from the development database.

The moral of the story? Always double-check when switching between development and production data. Always keep current backups of data, and never, ever let a rookie DBA be the sole DBA and developer on any project.

The good thing that came out of all this for me was I didn't do any permanent damage and it made me extremely gun-shy very early in my career.

About the Author

Byron Sisson is an IT professional from Orlando, Fla.

Featured

  • Microsoft Bolsters Windows IoT with NXP and SQL Server Support

    Microsoft's Internet of Things (IoT) product line is continuing to grow, with a few new developments highlighted this week.

  • Tamper Protection Now Available to Microsoft Defender ATP Subscribers

    The Microsoft Defender Advanced Threat Protection (ATP) E5 subscription plan now has an optional "tamper protection" security feature, Microsoft announced on Monday.

  • Exploring OCR, a New Way To Get Data into Excel

    Microsoft recently added a new optical character recognition feature to Excel that lets users import data from a photograph taken from a smartphone. Here's how to use it.

  • Microsoft Authenticator App To Get Real-Time Phishing Protections

    Microsoft is working on adding capabilities to its Microsoft Authenticator app to help defeat security breaches enabled by advanced attack techniques, including phishing and man-in-the-middle methods.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.