To .create, .alter, or .create-or-alter an external table using managed identity authentication requires Database Admin permissions. This method is supported for SQL Server and Cosmos DB external ...

SQL Server documentation tells us explicitly that update statistics is not supported on external tables! When creating external table statistics, SQL Server imports the external table into a temporary ...

While temporal data support is something that has existed in the past within other database platforms, it is a newly available feature with the RTM version of SQL Server 2016. In case you haven't ...