First - you need to validate that each certificate is the same.  To do that - open the certificate and view the details.  In the details you need to look...

If you need everything in a single row - then yes, you can use charindex and substring, along with reverse...and rtrim/ltrim to eliminate unwanted spaces.

Declare @testTable Table...

Why are you invoking a SQL command - and then within that script executing sqlcmd?  What is the purpose of this script?

But is that the correct certificate?  Unless you open the certificate and verify...

Just having the certificate on the server doesn't do anything - the certificate needs to be bound to an address.  Since SSRS uses its own internal web server - you...

Http load balancer is working , but I am getting the error when I try to access the secured site https://, do you still think it could be something...

You just need a LEFT OUTER JOIN:

 Select [week] = coalesce(tt.[week], 1)
      , al.Account
      , tt.[value]
 ...

Not sure why you think you need separate databases.  You most likely can resolve your issues by using separate schemas instead of creating separate databases.

And - as was stated previously,...

You need to uninstall it - apparently the bug is related to database snapshots and CHECKDB uses that feature.  Not sure about these other components, but you only need to...

Are you sure the load balancing is actually routing to both servers?

How are you load balancing - is it through Netscaler, F5 or something else and are both servers up...

What does this mean?

What would...

50 GB at 40% free...

Jeff - I was reading your article(https://www.red-gate.com/simple-talk/opinion/opinion-pieces/jeff-moden-dba-of-the-day/) and wanted to ask, what are some of the books or resources you felt like are great resouces to master Tsql. I...

If the user can enter multiple items in the text box - is it up to the user to insert a pipe in the string?  Or do  you have some...

To add to what Grant has posted - unless you have made changes to the instance configuration's TCP/IP settings you don't need to change anything.  The default configuration isn't locked...