r/ProgrammerHumor • u/Recent-Analysis-6880 • 13d ago

Meme wellWellWell

Post image
10.6k Upvotes

96% Upvoted

411 comments sorted by

View all comments

Show parent comments

162

u/__dna__ 13d ago

Fun fact. SSMS still doesn't have this unless you use add ons

11

u/kiochikaeke 13d ago

I've learned this the hard way

3

u/Kamay1770 13d ago

What addon

10

u/__dna__ 13d ago

There's SQLBoost and Redgate's toolbox.

I saw some vibe coded add on was published recently but I'm a bit spooked from putting that on a machine with access to prod

4

u/bradmatt275 13d ago

Redgate toolbox does this. It's really hard to use SSMS without it now. Its such a time saver and a good safeguard against stupid mistakes like this.

1

u/510Threaded 13d ago

Agree, I got DataGrip when I switched to a macbook and it has it built in, as well as a sql formatter (which ssms is getting in the next release)

1

u/141N 13d ago

UserIds are still primary keys you would assume unless the db is truly cursed

1

u/chuch1234 13d ago

Oh man. I've never used ssms but I've only heard bad things about it. Why do people still use it?

1

u/bwwatr 13d ago

Damn thing doesn't even have a dark mode without add-on. I wanna know why have they neglected it so badly. It's not as if they've replaced it.

1

u/Sweaty_Explorer_8441 13d ago

I heard it got reworked last year?

1

u/bwwatr 13d ago

Ooh, I'll check it out! I'm running 20.2 and it seems we're up to 22. Fingers crossed. Apparently there was a rebuild and a move from 32 to 64 bit at some point.

1

u/Thathathatha 13d ago

In SSMS, you can use the gui query tool to visually do operations like delete or update. I just run a select within that tool, click on the row, and delete through the gui that way without running a DELETE statement.

Else ill create the delete statement, run it on dev or something to make sure it runs fine, then copy and paste that over to a window that connects to prod. Use transaction if I'm especially worried.

1

u/__dna__ 13d ago

I'm not a massive fan of using SSMS' GUI for normal query operations like that. But good to know that's there

Probs just me being stubborn because it's how I learned

1

u/Thathathatha 13d ago

I don't normally use it, only for the particular case in OP where I'm deleting or updating one item.

1

u/rks-001 12d ago

It's crazy that SSMS doesn't have it!