Is this what you are looking for?  https://mssqltrek.com/2020/02/12/always-on-availability-groups-rolling-upgrades/

And...the added features that are available in Enterprise Edition would also be well worth the extra cost.  Data-driven subscriptions would be a large advantage to reporting solutions.

You cannot utilize the Enterprise scale-out feature on a Standard instance - but, there is nothing that I am aware of that requires the databases to be hosted on Enterprise...

You can use this site: https://www.brentozar.com/pastetheplan/instructions/

I find it is much easier than having the .sqlplan posted here.

How does the EXE return these two variables values in Powershell?  Can you show the Powershell commands that you are using to get these variables?

Generally - executing a process (Process.Start)...

What is the Powershell script doing - could it be changed to a script task using C#?  Maybe you can use a script task and the something like the following?

You missed the point.  The stored procedure would be called from a trigger on the table.

The stored procedure would generate the function and the function would be hard-coded based on...

It all depends on the SAN though - so check with the storage team on what is available.  It may require reconfiguring your instance - as you really do not...

Are all of the checks in this test_table based on variables only?  If so - you might be able to generate a function based on the values in the table...

I would also look at the specific driver you are using - I would expect anything going to RDS has an x64 driver and that is the one you should...

You stated you are now getting an error related to a service broker - which means one or more are enabled.  And yes, if you have a service broker in...

The error that your reported - 1117 - indicates an issue with the I/O subsystem.  If that issue has not been corrected it can and will occur again.  One of...

Thank you. Looking at the databases about three have service broker set as false or 0. Would this be the cause of the message? Also, does it need to...

You still need to review the storage system - or this could happen again.

Either continue the 'max' out to the maximum number of possible members in a department - or you have to use dynamic SQL to determine the number of maximum members.