I don't think you're passing in a varchar, but somewhere in your data there is an implicit conversion taking place, which gets a varchar ("No") and can't cast this to...

That was interesting, so I ran some numbers. The first answer is correct 22% of the time.

SQL Server can handle this, but there isn't queueing per se. Instead, you potentially get blocking at the page level. In order to perform an insert, a process acquires a...

It could be both. Fragmenting things across pages could mean more pages are needed, but most of the time this is more CPU as you must search the disk and...

I've seen this type of thing before. Often this is some cached credential being used, either from the service or the DC, and depending on when updates invalidate the cache,...

This is called salting the password. As Eddie noted, the authenticator is a good way to handle this. You could use something like adding the second letter of the user...

Thanks and that's a good point. I'll update the article to note this is positives only.

No plans right now. We're updating the main site in a few ways, and that will change some APIs. Once that's done, I'll see about what can be done here.

Ugh, edit error. Capture data on the performance of the database queries.

Query Store captures metrics on queries that run often. It can determine which plans were used and...