Glad it's working. I assume you added the drive as a dependency and found the folders?

Rename is good, either way, disrupt access so someone calls you. The thing I worry about with renaming is that a smart ad hoc used might notice the new database...

Limited security. Sorry, was typing too fast. We don't want unsecured sensitive data in the system too long. I'd limit permissions on the staging table and truncate it to prevent...

Glad you like these. The idea is to think for a minute and test yourself or learn something.

If you lost the e: drive, adding it back doesn't necessarily mean the same e: drive mounts correctly. You need to find the mdf/ldf files first, or restore from backup.

Actually, the source has to support encryption. Excel won't.

My advice, load the hundreds into a staging table that has very limited read writes. Then query this table with...

I would search for any usage. If there is none, or you see no wait stats from queries, I'd set this offline first. See if you break anything, and I'd...

In the import wizard, you cna write a query for the values, and you could probably use a function in there. Structuring this for the Excel can be cumbersome. You...

Please don't grant to the user. Use a database role.