If you have Windows logins as logins, that's fine.

I'd create app role groups and add the logins in here, and grant the permissions needed for each functional role. The execute...

You should do more yoga 😉

The amazing thing is that not all robots need to be human shaped. They could have 2 (or 3) hands on an arm and fix...

It's not that someone leaving is unnoticed. It's that we forget to revoke all their access.

When someone leaves, I'm usually thinking about other things (workload I pick up or what...

Sample of what Scott said, using the Alerts section in SQL Server Agent. This is slightly fragile as you configure each instance separately and need to maintain this.

I'm ready for Yahoo to draft my players. I'll likely be around, but if previous years are any predictor, I'll forget to join

No idea if this is required for the local AzDO server, but it might be. People upload things and there is likely some FTS used to search through documents or...

In addition to what Frederico notes, what about separations/terminations? Easy to leave a security hole as the DBAs aren't notified as people move/leave.

I would always have windows auth/Kerberos if possible....

I completely think there is a possibility that a number of engineers will lose their jobs. If you can't guide an llm, if you aren't smarter than it and get...

Agreed. It's an amazing lever.

It's sad this is the state of the world.

funny enough, I got an unsolicited check for $3k lastnight, saying I'd agreed to an auto wrap program, so I should deposit...

I see a Crucial 4TB one in the US for $377. I've never needed that much space. A Samsung m.2 is $575, so cheaper here, but definitely more expensive. Quite...

It's wild how prices have shifted. It's even more wild to see something like an m.2 card, which I bought for my desktop a few years ago. Smaller than an...

apologies for the typos. Kept going back and forth between the query and the editing of the question.

Typos fixed, points awarded back

It's a risk. I've had it go smoothly, and not smoothly. The risk is downtime while you sort out OS issues. If the company doesn't want to pay for separate...

Lucid makes great cars ..well two. Air and Gravity in various flavors. Too bad they started with Air...just as people were deciding they want SUVs. I expect they'll stay...