What's New and Changed

New

These Protocols documents have not been previously released.

Updated

These Protocols documents were previously released and have been revised to reflect the functionality of the latest product versions.

New Protocols Documentation

The following SQL Server Protocols documents are new for Microsoft SQL Server 2017.

Specification

Description

Release Date

[MS-SQLRS]: SQL Server Remote Services Profile

Specifies information regarding the implementation for hosting SQL Server databases on Server Message Block (SMB) shares.

This document was updated to combine the content for the IOCTL_VOLUME_GET_GPT_ATTRIBUTES and IOCTL_STORAGE_QUERY_PROPERTY control codes in former sections 2.2.3 and 2.2.4 into new section 2.2.3 in accordance with a change in the supporting normative reference to [MS-FSCC].

September 2017

Updated Protocols Documentation

The following SQL Server Protocols documents were previously released and have been updated for SQL Server 2017.

Specification

Description

Release Date

[MS-SSAS]: SQL Server Analysis Services Protocol

Specifies the SQL Server Analysis Services Protocol, which provides methods for a client to communicate with and to perform operations on an analysis server.

This document was updated to add two server properties: one that identifies a default compatibility level when a level is not explicitly set and another that exposes a list of all supported compatibility levels. Additionally, the discovery of calculation dependencies against databases was extended to include Tabular mode models at compatibility levels 1200 and higher.

August 2017

[MS-SSAS-T]: SQL Server Analysis Services Tabular Protocol

Specifies an extension of the SQL Server Analysis Services protocol [MS-SSAS] by specifying the methods for a client to communicate with and perform operations on an analysis server that uses Tabular databases that are at compatibility level 1200 or higher.

This document was updated to define new Data Sources and Expressions for M (Power Query Formula Language) sources. M sources provide the ability to connect to many new data sources and to leverage the power of the M expression language to extract and transform data. Related updates include support for Structured DataSource objects to authenticate connections to the M data sources, and partitions can now refer to an Expression object that uses the M language. The ability to pass Options to M-based Structured DataSources has been introduced, along with support for out-of-line bindings to Structured DataSources, M Partitions, and Expressions. Another update allows a Hierarchy object to define that a hierarchy contains leaf members at different levels. Other updates include object level security (OLS) at a table and column level and drillthrough.

August 2017

Show: