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 [email protected]. 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

  • How To Configure Windows 10 for Intel Optane Memory

    Intel's Optane memory technology can significantly improve the performance of your Windows 10 system -- provided you enable it correctly. A single mistake can render the system unbootable. Here's how to do it the right way.

  • Microsoft and SAP Enhance Partnership with Teams Integration

    Microsoft and SAP this week described continuing partnership efforts on Microsoft Azure, while also planning a Microsoft Teams integration with SAP's enterprise resource planning product and other solutions.

  • Blue Squares Graphic

    Microsoft Previews Azure IoT Edge for Linux on Windows

    Microsoft announced a preview of Azure IoT Edge for Linux on Windows, which lets organizations tap Linux virtual machine processes that also work with Windows- and Azure-based processes and services.

  • How To Automate Tasks in Azure SQL Database

    Knowing how to automate tasks in the cloud will make you a more productive DBA. Here are the key concepts to understand about cloud scripting and a rundown of the best tools for automating code in Azure.

comments powered by Disqus