Re:Software Engineers: What was your biggest ever f*ck up?
by Jeremy1026 on Wednesday February 27, 2013 @09:17PM
(#5296538)
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.
[ Parent
| on HN ]
Re:Software Engineers: What was your biggest ever f*ck up?
by xauronx on Wednesday February 27, 2013 @10:00PM
(#5296702)
As 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.
Re:Software Engineers: What was your biggest ever f*ck up?
by Jeremy1026 on Wednesday February 27, 2013 @10:02PM
(#5296708)
Fortunately 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?
Re:Software Engineers: What was your biggest ever f*ck up?
by xauronx on Wednesday February 27, 2013 @10:11PM
(#5296735)
A very very small one that I'm too ashamed to mention :) it's mostly medical billing though.
Re:Software Engineers: What was your biggest ever f*ck up?
by Jeremy1026 on Wednesday February 27, 2013 @10:16PM
(#5296751)
I hope they have better security than the one I use http://www.jcurcio.com/posts/obscurity-is-not-security/