with cmn as (
select
  a.a
from TableA a
inner join TableB b on a.a = b.a and a.b =...

Double check that the remote is running and listening on 1433. Check the errorlog.

The driver for connection is generic. 2014 should connect to 2016. Maybe try using the...

You might try grouping on the ID and ordering by the index, but as Thom noted, your description doesn't quite make sense.

Don't use GETDATE(), use SYSDATETIME(). It's the more modern function, though in practicality they work the same.

Second, I assume that if this fails, you don't really care as...

In terms of failover, you'd need to write scripting to ensure that an instance fails over if it detects the other instance has failed.

However, I'm not sure that...

Are these on the same machine? If not, you could have firewall issues. Even if they are, you might not be connecting with the same protocol, or the browser might...

You can set the alias in the first SELECT and it will work. Doesn't need to be in both.

I see both sides. If the data is moved/masked, not sure there is a reason not to keep this metadata. Developers need to know this for work, to handle requirements...

Glad you enjoyed it.

The first argument is optional in that if you pass in one argument, it is for the second parameter. If you pass two, then the first is the first parameter...

There are some good R tutorials out there. Can't remember the one I was using to get started now, but I've been going through various resources online that help me...

#$%#@$@# Ben

I owe you lunch. Hopefully in Sactown, but anywhere is fine.

I do. It will gain adoption over time, so documenting and explaining this better is something we'd like to do.

I'd say you want to be patched because you never know if malware or a misconfigured firewall will give access to a system. Especially these days where people take laptops...