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.

SQL Server will automatically uncompress the files. This is to ensure compatability.

As a near-senior citizen, I’d like to know how one goes about protecting and remembering 30 or 40 different accounts/passwords. Password vaults are only as secure as the password...

Enjoy. I think native intellisense is...

Hmm....seems we (or at least I) don't have the ability to flag posts as spam anymore. Other posts on that thread can be reported. What's the deal here???...

Seems like that works for me.