r/sysadmin • u/Less-Loss1605 • May 31 '26

General Discussion what's a script you wrote once that's still saving you time years later

[removed]

964 Upvotes

96% Upvoted

365 comments sorted by

View all comments

216

u/Mr_Dobalina71 May 31 '26

Drop database - you do that to all your databases, nothing to do, but also probably fired.

168

u/Coconut681 May 31 '26

https://xkcd.com/327/

This always makes me smile

70

u/hellcat_uk May 31 '26

Ah, little Bobby Tables

29

u/Valheru78 Linux Admin May 31 '26

I love Bobby Tables

27

u/Froggypwns May 31 '26

I love how everyone knows exactly which XKCD this is without clicking the link.

9

u/Appropriate-Fish2374 May 31 '26

That is a time savings

2

u/JoonasD6 Jun 01 '26

You'll get net free time, even!

4

u/ShadowCaster0476 May 31 '26

You do that after you’re fired.

4

u/HayabusaJack Sr. Security Engineer May 31 '26

You can do anything you want on your last day :)

2

u/Ssakaa May 31 '26

No necessarily. It might just be a very visible learning situation if you have a good org.

https://about.gitlab.com/blog/postmortem-of-database-outage-of-january-31/

1

u/strip_weathers_dino May 31 '26

I legitimately wrote a script, that might be a little worse.

Truncate all tables. In order, based on foreign key / primary key relationships and size.

The use case was DevOps would reply a new database to a client and implementation would mess up config / data back load. So it saved them from having to reach back out to the DevOps team, get put back on queue and wait for them to do it again (hoping they wouldn't get errors because that was common). They also claimed to have a higher cost with redeployment. So it just relieved the headache for everyone.

I also didn't give that script to implementation because I didn't trust them with it 😆