The system databases are not mirrored - so any information on backups would need to be combined across all nodes in the AG to be able to see the history.

First - the secondary must be configured for read-only or read-intent, and you must have Read-Only Routing defined for each node in the AG.

If you have both of those, then...

I don't think making this SARGable is going to help performance - but you also have another issue.  Using DATEADD(DAY, 1, SYSDATETIME()) returns tomorrow's date with the time set to...

I don't think the OP is asking about how to shrink the file - rather, the VLF's are not getting cleared and marked as reusable.

First...

It always makes me wonder why someone would use SSIS to call code in SQL Server that references a linked server to a third-party database system.  That just adds complexity...

Maybe use OUTER APPLY?

I would add to Perry's statements - ideally you should be using MSA or gMSA accounts to run SQL Server services.

What storage array are you using - and did they configure the storage using some type of tiering architecture?

I had a similar issue where everything worked fine the first time...

I think the only way you can get that 'delayed validation' would be to use dynamic SQL.

With that said - the real problem here is that you are even using...

You can use the menu option File | Save or File | Save As to save the .sql file to any location you want.  By default - there will be...

CHOOSE is really just short-hand for a simple case expression:

CASE CatID
     WHEN 1 THEN 'Laptops'
     WHEN 2 THEN 'PCs'
...

VS 2017 or VS 2022?

You stated you installed the 2022 SSIS extension - but then stated you cannot open a project in VS 2017.  If you are using VS 2017...

Generally - changes to objects in SQL will be performed using code.  All the GUI does is generate the code for you and then execute that code.

What I would recommend...

No worries

On the off chance you didn't do this - try refreshing object explorer.

If you have already tried that, then try opening the system databases - then master database - and...