SQL Server 2016 adds new support for the JSON format when ... You can also force nested objects into your result by using aliases with dots in their names. Columns with similar aliases will be grouped ...

We've got a DNS alias in our DNS server so that we can reference the SQL Server via a generic easy to remember name. It's used in our client app's ODBC connection. The thought process being ...