I've never seen that. I wonder if someone changed yours from AD Group Policy? It's certainly strange.

Reminds me of a tech support run I did at the nuclear plant with my boss. A manager complained their PC wouldn't turn on. We walked over to the office,...

That's a good idea, and a nice sentiment. I've volunteered for things my kids have been involved in over the years, and doing less now as they've gotten older, but...

You can certainly add logging to your app that captures start of query and then when the datareader/datatable fills. I don't know of anything directly that does this natively in...

I agree that doing a POST is a bit overkill for something like that. Must have been timing but it was quite strange. Might also be a good...

I use the snippet like this, but I still now have to go...

AFAIK, Azure doens't provide anything like SES from AWS. In fact, the few references I've seen note that SMTP is blocked for Azure IPs. You'd need a relay. Most people...

So the extension is changed in Windows? You didn't state that. If you run "dir" on the folder, you see .ndf?

That is a file type extension that Windows Explorer renders....

AFAIK, no utility exists. SQL Server is designed to just do this. Most third party vendors, like Redgate with SQL Backup, do provide a utility so SQL Server can read...

You can account for those items by using multiple REPLACE() statements for tabs, CRLF, etc.

This can help: https://www.sqlservercentral.com/articles/how-to-change-the-file-extension-for-a-data-file

SQL Server has the file(s) locked, so it can't rename anything. Neither can you. You need to stop the database engine for that datbaase to rename the files. You can...

You're asking for exact matches, which means exact matches. Are you tolerating matches if there are no spaces? If so

replace(HOC.Desc, ' ', '') = replace(Lo.Desc, ' ',...

Email is email. You need a client that can read from an address.  I would never have SQL Server receive the email because rogue emails to this address could open...

+1 for Grant's advice to use XE.