AFAIK, no. You need to use two hosts. You can use virtualization, but you can't have two instances on one host.

You can check lots of them here: https://www.microsoft.com/en-us/download/details.aspx?id=39083, but you have the idea in the general sense

IP would be: 1.1.1.1,33333, where 3333 is the port. IF you have dynamic ports, I suspect that the browser doesn't help here. Could be wrong, but you can get the...

I was thinking more local firewall here. Certainly could be a routing issue or some naming. Are you connecting with

a-server/host name

b - ip

c-fqdn

Any difference in connecting in any way? Make...

In 2008, there is not return of data in JSON format. You can construct something, but you'd have to provide more information.

Query your table to return the data, using the...

These aren't terms that are often used. There are system tables, which are really materialized when queried. There used to be real system tables in SQL Server, and these were...

Yes, differentials are not logs. You still need the log backups.

Differentials are closer to partial full backups. Logs are transaction lists. They work together, but one does not eliminate the...

Firewall?

Ping IP? Ping network name?

I'd think networking here.

Thanks, expected behavior, IMHO, but you never know with SQL Server. Some language behaviors are strange.

It's used a lot in code, here's a few examples.

https://annevankesteren.nl/2009/09/utf-8-reasons

I've never run into it in my career, but I've primarily been a US English data pro, so not a...

Here's what I got about the query of capturing percentage of time:

"I don't believe so IIRC, as the revert is all done down in the file manager level (read from...

end of summer break

You also might read through this series: https://www.sqlservercentral.com/stairways/stairway-to-sqlclr

In asking a few people, they say that using 3rd parties doesn't involve any more issues than you might have with your own code. If you are 2017+, you might...

SSC Fantasy Football league has at least one opening : https://www.sqlservercentral.com/forums/topic/ssc-fantasy-football-2019

Drop a note in the thread above if you want to play.