It may not be. Chances are if you migrated things over and back, the application and vendor would never realize this.

Often when someone doesn't support something like...

Hardcoded filegroups? Once the app is running, how would the app know about filegroups? I could easily migrate from Primary to filegroup1, then redo primary to reset file sizes, then...

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