Your state may already have a law about it. I was just talking to the IT staff of another state and they had one. I think most states do. But...

There I was, with a written, thank the gods, command, "Whenever a developer asks for a copy of production, give it to them."

A developer asked and I hooked him up.

Said...

Thank you all for the feedback and comments.

I would like to point out that I did emphasize "collectively" we stink. Individually, there were people running Crowdstrike on Windows who weren't...

Think of it as a toggle. Instead of off to on, it's like to unlike. So you hit like, it marks it as a like, but changes it to unlike...

They are pretty desperate to make this not about them. It isn't... but it also is.

Steve, Ryan and I were traveling on Friday. It was a mess, but Steve and I made it home....

Unless you have some kind of direct evidence that anything is causing a problem, leave it alone. Don't kill sessions without knowledge of there being an issue.

There isn't a single correct answer to this. Here's my list of "I'm gonna need this" software:

SQL Server Management Studio

Azure Data Studio

VS Code

Git

Docker

Redgate Toolbelt (yes, I work for them, but...

If you really want performance, create a wrapper proc that determines if you're doing an INSERT/UPDATE/DELETE and then a proc for each. MERGE generally stinks on performance. Period.

Happens to everyone. No worries.

Yeah, I was thinking something similar. I wonder if it's the unicode string that's causing the issue.

Database projects are more than a little difficult to work with in source control, and I do source control my databases. So, external tools are generally better. For free, when...

Bad news is, probably not. I mean, do run validations on all your hardware, because that could be the issue. However, data corruption can be from external sources. Power surges...

Thanks Grant

I accept your point - why is the system giving me a "select permission denied" when using the scalar variable in a select statement, when the user is...

The key difference is a result set. Scalar functions return a value, not a result set. So they're not being "selected" from, they're being executed.