fair enough, I was being flippant and referring to other free plugins. I looked again and the redgate toolkit is 1300, not 1500. I wouldn't consider that significantly less expensive...

That's not...

I have had mixed results getting it to restyle code for things that can't be restyled with a styling tool - such as standardizing aliasing to AS aliasing,...

I think you are better off using 1NF and then implement a status and status change date for historical locations of files, use filtered indexes even for active and historical...

Any other options if want to for example to synchronize the database every 1 hour. The reason we do this is because we have another database in oracle end,...

You need a failover cluster for an AAG. Managed Instance Link may have fewer requirements, but the feature is still unstable.

To replicate SQL data offsite, you do not need an...

I've found it to be extremely frustrating for generating new, functioning code. From one prompt to another, it will change its formatting style, will frequently not compile, sometimes produce code...

That does suggest a permissions problem.

How do you know permissions didn't change? Is it because you didn't change any, or because every permission relevant to SQL is configured by group...

I would take log shipping any day over replication, but your primary and secondaries have to be the same version in order to read the log shipped replica. When replication...

Container type name is in a lookup table, even if there is an index on the foreign key, the key won't be ordered in the alphabetical order of lookup name....

If your SQL server has more than one processor and your application is not purely OLTP, CX waits are good.

CXSYNC_PORT is a new wait type in 2022, it was happening...

Don't change the CASTing for the bits in the WHERE clause, leave as is.  Otherwise I believe SQL will default to a different data type which would force a...

I do believe that the database level setting overrides the instance level setting.

Is this a purely/high majority OLTP application? The problem could be excessive parallelism.

High SOS scheduler yield waits with...

You didn't get any nonclustered index definitions on here, but one problem I see:

CAST(1 as bit) and CAST(0 as bit) if it is even sargable, will mess up cardinality.

Are most...

Does the virtual host have at least one physical core per virtual processor provisioned to all guest VMs on the host?

You can of course oversubscribe processor resources to a degree,...