Exactly.

There's a connection to the database. That's what that error is telling you. I'll bet money it's SSMS. However, to find out, just open a query window, not connected to...

You're a pretty strong candidate for moving that database to the cloud. As you say, you don't have expertise in hardware or operating systems in house. Moving the database to...

You can check the encryption status of your databases:

SELECT 
db.name AS database_name, 
db.is_encrypted, 
dm.encryption_state, 
dm.percent_complete, 
dm.key_algorithm, 
dm.key_length 
FROM 
sys.databases db 
LEFT OUTER JOIN 
sys.dm_database_encryption_keys dm 
ON 
db.database_id...

Hey Rod,

I do not have a good answer.

Probably, especially considering we're talking security, you'd be better off migrating out of the existing thing, whether it works or not. However, I...

There can be no other connections to the database when you run a restore. That includes SSMS. So, if you have that database open in front of you and you...

In the real world, one has to hope for the best, plan for the worst and insure for anything else! 😎 Weather is just one of the many factors,...

Good gosh. That's incredible. Well...

You've described the scenario, but I don't see much in the way of solutions. Do you have a question? If not, expand this out, provide some solutions, and submit it...

Not a clue. I haven't seen something like this before. However, I'd suggest not bothering to look at the proc cache any more. Look elsewhere. What the heck is using...

There's a login event that will let you know when a login has been completed. You can also look for login errors. Here's an article on the concept. Here's...

You could try forcing the processing over to the remote server through OPENQUERY so that filtering is done there. Otherwise, the way your code is written, yep, it's moving everything...

Do you have monitoring in place to understand why the CPU is maxing out? Without more data, I'd just be guessing.

Strictly talking INSERT, and nothing else. Assuming the data being inserted is coming from an identical structure. That structure does, in fact, have foreign keys in place. Those keys are...

Pretty sure the answer to using the Microsoft backups is that your choices are:

• Portal
• Powershell
• Azure CLI
• REST API

That's per the documentation.

The issue is simple, that stuff is...