How do you kick this off? Is a user doing this or does it need to trigger on some change in your existing database?

The designation of a file as .mdf or .ldf or .ndf is arbitrary and by convention. There isn't any reason you must have the files names with these extensions. I...

All transactions are replayed on the mirror, so log space is used. You have an alert on the DR server looking for the log being above 80%. Not sure what...

You should stop using SSMS for 208R2. Download SSMS 17.9, which is free and will work fine for SQL Server 2008 R2.
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017

Second, I'm guessing you...

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.