Are these both Windows auth credentials? I don't think you can easily do this as there is a single account running the overall package.

Can you use SQL Auth for one?

Yeah, need to specify a version here. I used SQL 2022 and that shows this reacts differently.

100 was the value for a few years, but I think that is different...

• This reply was modified 1 months, 2 weeks ago by Steve Jones - SSC Editor.

PRs are a good way to try and catch issues early. Running all deployed code through a PR doesn't necessarily prevent what you've listed, but it does give someone a...

Wow. The silence indicates whoever reads these post has not given much thought to finances and retirement. The sooner you think about it and make financial plans the better...

Watching costs is a challenge. Even for companies where they have a person(s) doing this.

The spot VM is a good idea. It's also good to learn how to script this...

Two tests I think about. Was told this by an interviewer while in Uni.

1. Would I have a beer with you after work?

2. Would I be willing to drive on...

Self Driving is dead in the water? that's news to me. I live in the Phoenix metropolitan area and I have been using Self Driving Waymos for years now,...

Who remembers when XML was going to revolutionise databases? Or Blockchain? That was going to revolutionise everything as well. AI is another tech bubble, it will burst (some people...

Haven't used this in a long time, but it has some capabilities: https://dbdiagram.io/home

Most tools that work well require payment

Added the Agent service account? Or DB Engine service account?

Apologies, edited. Awarding back points as well.

I should have included the command, but was rushing and not paying attention

Not sure of the issue, but easy to set a SQL Agent job to run an ALTER EVENT SESSION .. STATE = START to run this with a one-time schedule....

Networking inside work is certainly something that matters. I often work outside the lines, with permission, to try and help make things better for others as well as for myself.

Wow, just realized this thread has been very quiet.

Hope everyone is doing well as we move into fall.

When you need to change an old procedure for the first time and decide to format it or make some other cosmetic changes, to this stuff first and check...