That does not answer the question.

Colouring a column is a visualisation issue, which is solved in the client not the query or stored procedure.

What "client" do you need this visualisation...

Going to need more information, more specifically in which application do you require to colour this column?

Azure Data Studio?

SQL Server Management Studio?

SSRS?

PowerBI?

Tableu?

Grafana?

Something else?

Raising a support ticket with MSFT is your best way to get this resolved I'm afraid.

They will need to do some sort of engineering fix to make the agent compatible...

I would also switch to using  the built in check function "sys.fn_hadr_is_primary_replica" instead also.

https://learn.microsoft.com/en-us/sql/relational-databases/system-functions/sys-fn-hadr-is-primary-replica-transact-sql?view=sql-server-ver16

I have seen cases in the past where custom primary checking functions have caused issues especially when...

No unfortunately not.

The file is encrypted in a rudimentary way so no easy way to get the contents, and it's also not in a nice format.

Your best bet is to...

Good article.  Just one thing to note is that, "sp_changedbowner" is on the depreciated list, so I wouldn't be advertising to use that option any further and use the ALTER...

Before you do that enable query store (if you haven't already), run with the option on for the moment to collect data, then disable the option to see what regresses...

I would visit the market place directly and download the extensions you need for the right version of VS you have.

SSMS always try to have the latest, v19 is the...

Did you install the correct extensions into VS 2022?

There are two copies of each extension now, one for 2019 and one for 2022, so you need to ensure you use...

As it's an FCI the failover is controlled at the WSFC level not SQL, so you will need to write something in PowerShell, using Move-ClusterGroup to move the resource between...

Yes indeed.

Going up versions is totally supported, so backup 2016, restore to 2019 is all good.

However going down versions is NOT supported, so if you have an issue with the...

Thanks,...

Yes it is possible to install a SQL FCI on a single node WSFC.

Can you detail what is failing, may give more to go on.

The item path is the reportURL, you would just need to tag on the http part as a concatenation if you wanted it as a full clickable URL

Yeah that was what I was getting at to use dateadd to minus the 17 from the hour, it was rough pseudo code, to steer the OP in the right...