4 ms·
I work at with a medical office management company. We handle the billing, training, hiring, and IT for various medical offices in the area. Included in the IT
by Jeremy1026 14y ago
I work at with a medical office management company. We handle the billing, training, hiring, and IT for various medical offices in the area. Included in the IT portion where I am, is the hub of the electronic medical records. One day while working on a new web application to tie into the EMR system I was fiddling with some SQL. After confirming I was logged into the development database I ran some select statements. I moved to a new query window in SQL Server Management Studio and ran a delete statement on a large (100,000,000+ records) table. I forgot to include a where clause so the entire table was wiped. Which was no big deal because it was the development database and it'd be restored in the overnight copy, except that the 2nd query window was connected to the production database. Oops.
- xauronx 14y agoAs someone who works in the same industry, doing the same type of work, I cringed hard. I hope you were able to save your ass.
- Jeremy1026 14y agoFortunately it happened early in the morning. So the previous nights copy on the development server was close enough that it could be pushed back to live while causing only very minor issues. What EMR system do you deal with?
- xauronx 14y agoA very very small one that I'm too ashamed to mention :) it's mostly medical billing though.
- Jeremy1026 14y agoI hope they have better security than the one I use http://www.jcurcio.com/posts/obscurity-is-not-security/ http://www.jcurcio.com/posts/obscurity-is-not-security/
- xauronx 14y agoHaha, a little bit better than that.