Need to do more. graph has been on my list for some time and keep ignoring it

I assume you mean someone accessing a web URL will then cause a stored procedure to execute?

SQL Server isn't built to function as a web server. You would build a...

Enjoy yourself. If you swing the recordings, you can not worry about which sessions you see, or you can change your mind. There can be lots of walking, as the...

Please read the links. This is explained in the links, especially the first one from Gail. There is a clustered index, data stored in this order, and non-clustered indexes, which...

AFAIK, no. since this requires a lot of hardware to get this working. If you don't have virtualization, then you can set up an Azure or AWS account with 2...

No, you can't restore from the backup, aFAIK.

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.