I'd actually create a new filegroup and move objects in what way.

You cannot create a session without events, but you can remove all events from an existing session container. Strange, but you can.

We haven't refreshed it in a long time. I think we used whatever version of ADW was out at that time.

There is going to be some blocking. I think that if you change the sync_method parameter to concurrent (default native), this can help: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-changepublication-transact-sql?view=sql-server-2017

CREATE TABLE MyUsers( dbname VARCHAR(200), principalname VARCHAR(200), principalSID VARBINARY(MAX))
INSERT MyUsers
exec sp_MSforeachdb 'select ''?'', name, sid from ?.sys.sysusers'

Glad you liked it

Yep, grab the substring, compare length with length of missing Xs.

I'm not completely sure if I understand. Do you mean that given a date, you want to sum all the reviews conducted and the reviews passed. However you need to...

Is that the message from job history?

You should ensure the job creates a log, and examine that. The insert might fail, but that won'd necessarily fail the job....

Here might be a better way to check how Sean's code works. I use tsqlt for repeatable testing. You could certainly download the framework, which would allow you to test...

My kid did a Python course and then another programming one. I think they did a good job teaching programming fundamentals, but not for the real world. No VCS, no...