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

  • RAMBleed Side-Channel Attack Method Disclosed by Researchers

    Academic researchers this week published information about another side-channel attack method, called "RAMBleed," that can expose information from memory chips, including encryption key information.

  • Penguin

    Windows 10 Preview Build 18917 Shows Off New Linux Integration

    Microsoft's latest Windows 10 "fast-ring" preview release is showcasing a coming Delivery Optimization enhancement, along with the ability to try the newly emerged Windows Subsystem for Linux version 2.

  • Customizing Microsoft Office 365

    While the overall look and feel of Office 365 is pretty standard across organizations, there are several ways to personalize it and make it fit better with your company's specific needs.

  • Microsoft 365 Business Tenants Getting Conditional Access and Trouble-Ticket Features

    Microsoft added its conditional access security service to Microsoft 365 Business subscriptions, according to a Wednesday announcement, and it also added new trouble-ticket features for Microsoft 365 administrators.

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.