I love the "or so". Does that mean 99.99% or 90% or maybe 50%. I mean, so isn't exactly a precise measurement

I think the most days at home, some days in the office is a good plan. We may do that at Redgate when things open in the UK, which is...

I worry that you have some underlying storage issue with the files themselves being corrupt. Can you point your log backups, or maybe for one db that has issues, to...

Or maybe ProductLocation, PersonLocation, etc.

create table Geolocation (...)

Sorry about your dog, Ralph. I hope he does well with treatment.

It is hard to tell if this was employees or not. The wording from Marriott is very ambiguous.

There is only one master key in each database, which provides the basis for all encryption objects in that database. You don't need to drop this, thought you can use...

https://www.sqlservercentral.com/forums/topic/how-to-grant-permissions-to-run-a-specific-sql-agent-job

Short answer, create aw proc to run  the job, give users permission to the proc. The proc needs EXECUTE AS

There are some shared items, but overall, no effect from one instance to the other other than resource usage (you're sharing memory, cPU, etc. )

On my workstation, I typically keep...

Short example:

DECLARE
    @m VARCHAR(10) = 'July', @y INT = 2019, @mnum TINYINT;
SELECT @mnum = CASE
         ...

You should have a set of smoke tests, things that verify the system meets your needs. A few things listed above, but here's the type of things I look for:

...

Not sure with the same hardware you'll see better performance. In addition to memory, there are CPU limits. 24 cores for standard. Also memory for columnstore and hekaton are different...

No tools that I know of that will help here.

I'm sorry, but the English here doesn't quite make sense.

I assume you are saying you host all the servers now in your company (on premises). Now you want to have...