I wanna say its a bit like SSIS packages, drag and drop the things you need into the designer pane set the connection to the correct agent, give it the...

Might be a bit to powerful for what you need but check out dSeries workload automation from Broadcom, used that in the past for this type of centralised job management/scheduling.

Yeah what Jeffrey said.

Audit you need to be very explicit each new clause must be its own individual filter.

(
    [server_principal_name] <> 'MyDomain\User1'
  ...

If you want to exclude them, then you need a NOT operator instead of an EQUALS operator.

WHERE server_principal_name <> 'MyDomain\MyUser'

Does db_ssisoperator not give the right access for that?

S/I/U/D options are only available at the Database Audit Specification level, they are not at the Server Audit Specification level

Want to track logins at the instance level use Successful Login...

https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/create-or-configure-an-availability-group-listener-sql-server?view=sql-server-ver16

Google is your friend

It depends what setting you have for RegisterAllProvidersIP

If setting is True then you should have all the IPs the listener can use

If setting is False then you should only have...

Use group policy to set it, best it is done in AD then you have a global source to filter it down to where you need it via OUs.

But look...

Probably not using the default fallback cert.

But still you should be upgrading. 2016 is a dead product now in terms of MSFT.

SSMS - Right click db - tasks - generate scripts.

Follow the wizard, ensure you set the right scripting options you need etc.

But yeah if in devops, should be a DB...

Get rid of all the replace stuff, you're non-sargable it has to scan the entire table to make that work, bigger the table longer it will take to complete

Hi sir, the problem is that as a practice we have be never used SSL certificate trusted by a CA in our SQL instances, what should we do in...

What edition of SSRS do you have installed, and what permissions to the SSRS site and folder do you have?

Standard/Enterprise/Developer?

Do you have Content Manager / My Reports / Publisher access...

Then yeah your setup is right.  Usually see /24s not /26s so my bad there.

So yeah use a driver which supports MultiSubnetFailover connection string attribute and add that to the...