Right there with you Jeff & Andrew. Stuff like this makes so many things more difficult.

Agreed. When we start reaching a limit, we should reconsider the approach. I can only assume someone needing that many parameters is trying to process a lot of data...

Ha! Yeah, no kidding. However, someone, with a bunch of money, went...

Your best bet is to use the Azure Pricing Calculator or directly contact support. And remember, it's not just storage costs. Are you moving data OUT of Azure? That...

Export, backup, whatever. It's going to look & act like a drive inside the VM.

If you create a container inside your storage account, you can then use the mount command to mount it as NFS storage inside the VM.

Something like this (example code from...

I couldn't agree more about being prepared ahead of time. When I read your post, what immediately came to mind were two words: Crowdstrike 🙂    That horrible morning...

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...