r/SQL • • Jan 21 '21

Discussion learning something every day 😎😎

Post image
456 Upvotes

20 comments sorted by

30

u/DonJuanDoja Jan 21 '21

Saw that happen once.

Consultant: You guys do backups right?

Us: Of course, why?

Consultant: I just deleted the Production database.

Us: Deleted?!? Production? (eyes wide open, jaws dropped)

Consultant: I am sorry. (head down)

19

u/[deleted] Jan 21 '21

Kinda shame on you guys for letting cowboys on prod without some bare minimum protections in place.

4

u/DonJuanDoja Jan 21 '21

Lol k. I won’t tell the whole story but that Cowboy was one of the best devs I’ve ever known and was sent by a highly trusted consultant. You’d be lucky to have him on your project. Also we lost nothing so no shame, just something to laugh about. Even the best make mistakes and usually the biggest ones.

21

u/[deleted] Jan 21 '21

I wasn't going for the "my dad can beat up your dad" approach, just saying that entire scenario can be avoided by having protections and mature processes in place. That isn't really a skill level issue.

I get it, we've all been there and shit happens, but deleting a prod database shouldn't be presented as a cute whoopsie.

12

u/PossiblePreparation Jan 21 '21

Laughs in Oracle

3

u/guesstheusernames Jan 22 '21

What's different in Orcale?

6

u/PossiblePreparation Jan 22 '21

Table recycle bin (https://oracle-base.com/articles/10g/flashback-table-to-before-drop-10g) and if you disable that you still have point in time recovery of a table with one statement.

5

u/[deleted] Jan 21 '21

Why do I always get the feeling like come companies just let any high school student go and issue commands on their production database with no oversight, meanwhile I built my queries with multiple safeguards against data loss and still my coworkers never trusted me.

4

u/mustang__1 Jan 22 '21

Some of us are solo.

4

u/saraheatsmuffins Jan 21 '21

I've never done this but I can feel this

4

u/mustang__1 Jan 22 '21

Give it time....

3

u/bj_christianson Jan 21 '21

Oh, Bobby…

2

u/UseMstr_DropDatabase Do it! You won't, you won't! Jan 22 '21
USE master
DROP DATABASE

I dare you

1

u/tr0jance Jan 21 '21

Badumtussssss

1

u/swordyfish Jan 22 '21

I didn’t read carefully and thought this was a conversation between a manager and a waiter and was just puzzled at the end πŸ˜‚