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...

I thought this was fun. I keep stopping to think about how it works, so good reminder for me as well.

It was a good ride, but ended with Ben getting hurt and his replacement sending all the points to the Schuster kid. Oh well, a fun season.

Still not sure where to use this, but it is an interesting function. Glad you all enjoyed it.