[MS-SSSO-Diff]: SQL Server System Overview
![[MS-SSSO-Diff]: SQL Server System Overview](/img2/34/5bms-ssso-5d-200305-diff.webp)
[MS-SSSO-Diff]:SQL Server System OverviewIntellectual Property Rights Notice for Open Specifications Documentation Technical Documentation. Microsoft publishes Open Specifications documentation (“thisdocumentation”) for protocols, file formats, data portability, computer languages, and standardssupport. Additionally, overview documents cover inter-protocol relationships and interactions.Copyrights. This documentation is covered by Microsoft copyrights. Regardless of any otherterms that are contained in the terms of use for the Microsoft website that hosts thisdocumentation, you can make copies of it in order to develop implementations of the technologiesthat are described in this documentation and can distribute portions of it in your implementationsthat use these technologies or in your documentation as necessary to properly document theimplementation. You can also distribute in your implementation, with or without modification, anyschemas, IDLs, or code samples that are included in the documentation. This permission alsoapplies to any documents that are referenced in the Open Specifications documentation.No Trade Secrets. Microsoft does not claim any trade secret rights in this documentation.Patents. Microsoft has patents that might cover your implementations of the technologiesdescribed in the Open Specifications documentation. Neither this notice nor Microsoft's delivery ofthis documentation grants any licenses under those patents or any other Microsoft patents.However, a given Open Specifications document might be covered by the Microsoft OpenSpecifications Promise or the Microsoft Community Promise. If you would prefer a written license,or if the technologies described in this documentation are not covered by the Open SpecificationsPromise or Community Promise, as applicable, patent licenses are available by contactingiplg@microsoft.com.License Programs. To see all of the protocols in scope under a specific license program and theassociated patents, visit the Patent Map.Trademarks. The names of companies and products contained in this documentation might becovered by trademarks or similar intellectual property rights. This notice does not grant anylicenses under those rights. For a list of Microsoft trademarks, visitwww.microsoft.com/trademarks.Fictitious Names. The example companies, organizations, products, domain names, emailaddresses, logos, people, places, and events that are depicted in this documentation are fictitious.No association with any real company, organization, product, domain name, email address, logo,person, place, or event is intended or should be inferred.Reservation of Rights. All other rights are reserved, and this notice does not grant any rights otherthan as specifically described above, whether by implication, estoppel, or otherwise.Tools. The Open Specifications documentation does not require the use of Microsoft programmingtools or programming environments in order for you to develop an implementation. If you have accessto Microsoft programming tools and environments, you are free to take advantage of them. CertainOpen Specifications documents are intended for use in conjunction with publicly available standardsspecifications and network programming art and, as such, assume that the reader either is familiarwith the aforementioned material or has immediate access to it.Support. For questions and support, please contact dochelp@microsoft.com.1 / 44[MS-SSSO-Diff] - v20200305SQL Server System OverviewCopyright 2020 Microsoft CorporationRelease: March 5, 2020
Revision /20100.1MajorFirst release.4/21/20100.1.1EditorialChanged language and formatting in the technical content.6/4/20100.1.2EditorialChanged language and formatting in the technical content.9/3/20100.1.2NoneNo changes to the meaning, language, or formatting of thetechnical content.2/9/20110.1.2NoneNo changes to the meaning, language, or formatting of thetechnical content.7/7/20110.1.2NoneNo changes to the meaning, language, or formatting of thetechnical content.11/3/20110.1.2NoneNo changes to the meaning, language, or formatting of thetechnical content.1/19/20120.1.2NoneNo changes to the meaning, language, or formatting of thetechnical content.2/23/20120.1.2NoneNo changes to the meaning, language, or formatting of thetechnical content.3/27/20120.1.2NoneNo changes to the meaning, language, or formatting of thetechnical content.5/24/20120.1.2NoneNo changes to the meaning, language, or formatting of thetechnical content.6/29/20121.0MajorUpdated and revised the technical content.7/16/20121.0NoneNo changes to the meaning, language, or formatting of thetechnical content.10/8/20122.0MajorUpdated and revised the technical content.10/23/20122.0NoneNo changes to the meaning, language, or formatting of thetechnical content.3/26/20132.0NoneNo changes to the meaning, language, or formatting of thetechnical content.6/11/20132.0NoneNo changes to the meaning, language, or formatting of thetechnical content.8/8/20132.0NoneNo changes to the meaning, language, or formatting of thetechnical content.12/5/20132.0NoneNo changes to the meaning, language, or formatting of thetechnical content.2/11/20143.0MajorUpdated and revised the technical content.5/20/20143.0NoneNo changes to the meaning, language, or formatting of thetechnical content.5/10/20164.0MajorSignificantly changed the technical content.2 / 44[MS-SSSO-Diff] - v20200305SQL Server System OverviewCopyright 2020 Microsoft CorporationRelease: March 5, 2020
.0MajorSignificantly changed the technical content.3/16/20185.1MinorClarified the meaning of the technical content.3/5/20206.0MajorSignificantly changed the technical content.3 / 44[MS-SSSO-Diff] - v20200305SQL Server System OverviewCopyright 2020 Microsoft CorporationRelease: March 5, 2020
Table of Contents1(Updated Section) Introduction. 61.1(Updated Section) Glossary . 71.2(Updated Section) References . 92Functional Architecture . 112.1Overview . 112.1.1Network Connectivity and Application Development . 122.1.2Master Data Services . 132.1.3Reporting Services . 142.1.4Analysis Services . 152.1.5Database Engine . 162.1.6Complex Event Processing Engine . 162.1.7Manageability . 172.1.8(Updated Section) Big Data Clusters . 172.2Protocol Summary . 182.2.1Network Connectivity and Application Development . 182.2.2Master Data Services . 192.2.3Reporting Services . 202.2.4Analysis Services . 212.2.5(Updated Section) Database Engine . 212.2.6CEP Engine . 222.2.7Manageability . 222.2.8(Added Section) Big Data Clusters . 222.3Environment . 222.3.1Dependencies on This System . 222.3.2Dependencies on Other Systems or Components . 232.3.3Communications within the System. 232.3.4Assumptions and Preconditions . 232.4Use Cases . 232.4.1Network Connectivity and Application Development Use Cases . 232.4.1.1SQL Server Instance Discovery Use Case . 232.4.1.2Named SQL Server Instance Resolution/Enumeration . 242.4.1.3Client Connection (TDS, SSTDS, or SSNWS) . 252.4.2MDS Integration Use Cases . 262.4.2.1Use the MDS UI to Query . 262.4.2.2Query a List from the MDS Store. 272.4.3Reporting Services Use Cases. 272.4.3.1Report Authoring, Management, and Viewing with Native Report Portal . 272.4.3.2Mobile Report Authoring, Management, and Viewing with Native Report Portal282.4.3.3Report Authoring, Management, and Viewing with External Report Portal . 282.4.4Analysis Services Use Cases . 292.4.4.1Authentication with the Analysis Server . 292.4.4.2Information Discovery . 292.4.4.3Sending an MDX Query . 292.4.4.4Sending a DAX Query . 292.4.4.5Usage Reporting . 292.4.5Database Engine Use Cases . 302.4.5.1Authentication with the Database Engine . 302.4.5.2Information Discovery . 302.4.5.3Sending a Query . 302.4.6CEP Engine Use Case . 302.4.7Manageability Use Case . 312.4.8(Added Section) Big Data Cluster Protocols Use Cases . 312.4.8.1(Added Section) Control Plane REST API Use Cases . 312.4.8.1.1(Added Section) Provision a Big Data Cluster . 314 / 44[MS-SSSO-Diff] - v20200305SQL Server System OverviewCopyright 2020 Microsoft CorporationRelease: March 5, 2020
2.52.62.72.82.4.8.1.2(Added Section) Retrieve Big Data Cluster Endpoints . 312.4.8.2(Added Section) Hive Metastore HTTP Use Cases . 32Versioning, Capability Negotiation, and Extensibility . 32Error Handling . 32Coherency Requirements . 32Security . 323Examples . 333.1Configuring and Administering Multiple Servers. 333.1.1Analysis Services Authoring and Management . 343.1.2Reporting Services Authoring and Management . 343.1.3MDS Management. 343.1.4(Updated Section) Database Engine Management . 353.2Obtaining Data . 353.2.1Obtaining Data via Analysis Services . 353.2.2Obtaining Data via Reporting Services . 353.2.3Obtaining Data via MDS. 364(Updated Section) Microsoft Implementations . 374.1(Updated Section) Product Behavior . 375Change Tracking . 386Index . 395 / 44[MS-SSSO-Diff] - v20200305SQL Server System OverviewCopyright 2020 Microsoft CorporationRelease: March 5, 2020
1(Updated Section) IntroductionThe SQL Server System Overview document provides an overview of the client and server protocolsthat are used by Microsoft SQL Server. This document covers protocols that are commonly shared bySQL Server components and those protocols that are used only by specific components. Whereappropriate, this document describes the relationships between protocols and provides examplescenarios to show how they are used.SQL Server is a data platform that includes several data management and analysis technologies. Thisdocument covers those elements of the platform that require protocols that interoperate. Master Data Services: The Master Data Services (MDS) service and API provide a service-orienteddesign architecture (SOA) that encapsulates and modularizes the internal workings of SQL Server,in addition to a standard API to interact and integrate with SQL Server Master Data Services. TheSQL Server MDS framework ensures that the internal functions of the product are bettermodularized to support both an API and a modular component development. For moreinformation, see [MSDN-MDS]. Reporting Services: Reporting Services delivers enterprise, web-enabled reporting functionality forcreating reports that draw content from a variety of data sources, for publishing reports in variousformats, and for centrally managing security and subscriptions. For more information, see [MSDNSSRS]. Analysis Services: Analysis Services supports high performance analytical applications by enablingan implementer to design, create, manage, and query Multidimensional and Tabular data models.For more information, see [MSDN-ASMD]. Database Engine: The Database Engine is the core service for storing, processing, and securingdata. The Database Engine provides controlled access and rapid transaction processing to meetthe requirements of the most demanding data-consuming applications within an enterprise. TheDatabase Engine also provides rich support for sustaining high availability. For more information,see [MSDN-SSDBEng]. Complex event processing: Complex event processing (CEP) is the continuous and incrementalprocessing of event (data) streams from multiple sources based on declarative query and patternspecifications with near-zero latency. The goal is to identify meaningful patterns, relationships,and data abstractions from among seemingly unrelated events and to trigger immediate responseactions. Typical event stream sources include data from manufacturing applications, financialtrading applications, web analytics, and operational analytics. The CEP Engine provides adedicated web service to handle requests from client applications for managing the system. Big data clusters: Big data clusters provide the ability to deploy scalable clusters of SQL Servercontainers that can combine and analyze high-value relational data with high-volume big data.This flexibility of interaction with big data lets the user query external data sources, store big datain external file systems managed by SQL Server, or query data from multiple external datasources through the cluster. For more information, see [MSDOCS-SSBDC].To deliver these functionalities, SQL Server uses seveneight major sets of protocolstechnologies: Network connectivity and application development Master Data Services Reporting Services Analysis Services Database Engine6 / 44[MS-SSSO-Diff] - v20200305SQL Server System OverviewCopyright 2020 Microsoft CorporationRelease: March 5, 2020
Complex event processing engine Manageability Big data clustersThis document provides an overview of the protocols that can be used by one or more of the SQLServer products that are listed in Microsoft Implementations (section 4). Specific release informationfor each protocol is indicated in the individual technical specifications only, unless otherwise indicatedin the summary information provided in section 2.2.1.1(Updated Section) GlossaryThis document uses the following terms:Active Directory: A The Windows implementation of a general-purpose network directory service.Active Directory also refers to the Windows implementation of a directory service., which usesLDAP as its primary access protocol. Active Directory stores information about a variety ofobjects in the network. User such as user accounts, computer accounts, groups, and all relatedcredential information used by the Windows implementation of Kerberos are stored in ActiveDirectory.[MS-KILE]. Active Directory is either deployed as Active Directory Domain Services(AD DS) or Active Directory Lightweight Directory Services (AD LDS). [MS-ADTS] describes bothforms. For more information, see [MS-AUTHSOD] section 1.1.1.5.2, Lightweight DirectoryAccess Protocol (LDAP) versions 2 and 3, Kerberos, and DNS), which are both described in [MSADOD]: Active Directory Protocols Overview.analysis server: A server that supports high performance and complex analytics for businessintelligence applications.Apache Knox: A gateway system that provides secure access to data and processing resources inan Apache Hadoop cluster.big data cluster: A grouping of high-value relational data with high-volume big data that providesthe computational power of a cluster to increase scalability and performance of applications.common language runtime (CLR): The core runtime engine in the Microsoft .NET Framework forexecuting applications. The common language runtime supplies managed code with servicessuch as cross-language integration, code access security, object lifetime management, anddebugging and profiling support.complex event processing (CEP): The continuous and incremental processing of event streamsfrom multiple sources, based on declarative query and pattern specifications with near-zerolatency.connection string: A series of arguments, delimited by a semicolon, that defines the location of adatabase and how to connect to it.control plane: A logical plane that provides management and security for a Kubernete
The SQL Server System Overview document provides an overview of the client and server protocols that are used by Microsoft SQL Server. This document covers protocols that are commonly shared by SQL Server components and those protocols that are used only by specific components. Where
Server 2005 , SQL Server 2008 , SQL Server 2008 R2 , SQL Server 2012 , SQL Server 2014 , SQL Server 2005 Express Edition , SQL Server 2008 Express SQL Server 2008 R2 Express , SQL Server 2012 Express , SQL Server 2014 Express .NET Framework 4.0, .NET Framework 2.0,
MS SQL Server: MS SQL Server 2017, MS SQL Server 2016, MS SQL Server 2014, MS SQL Server 2012, MS SQL Server 2008 R2, 2008, 2008 (64 bit), 2008 Express, MS SQL Server 2005, 2005 (64 bit), 2005 Express, MS SQL Server 2000, 2000 (64 bit), 7.0 and mixed formats. To install the software, follow the steps: 1. Double-click Stellar Repair for MS SQL.exe.
SQL Server 2005 SQL Server 2008 (New for V3.01) SQL Server 2008 R2 (New for V3.60) SQL Server 2012 (New for V3.80) SQL Server 2012 R2 (New for V3.95) SQL Server 2014 (New for V3.97) SQL Server 2016 (New for V3.98) SQL Server 2017 (New for V3.99) (Recommend Latest Service Pack) Note: SQL Server Express is supported for most situations. Contact .
4395 querying data with transact -sql (m20761) microsoft sql server 6552 querying microsoft sql server 2014 (m20461) microsoft sql server 1833 sql server performance tuning and optimization (m55144) microsoft sql server 4394 updating your skills to sql server 2016 (m10986) microsoft sql server
install the SQL Server Reporting Services 2019 or 2017 installation program. For more information, see Installing SQL Server Reporting Services for SQL Server 2019 and SQL Server 2017 To use the SQL Installer to install a full version of SQL Server software (for example, SQL Server 2019 Standard editio
4. To upgrade SQL Server 2008 SP3 Express to SQL Server 2012 SP2 Express, launch th e installer for SQL Server 2012 SP2 Express, and then follow the wizard. 5. Select the Upgrade from SQL Server 2005, SQL Server 2008 or SQL Server 2008R2 option under the Installation option. The Upgrade to SQL
SQL Server supports ANSI SQL, which is the standard SQL (Structured Query Language) language. However, SQL Server comes with its own implementation of the SQL language, T-SQL (Transact- SQL). T-SQL is a Microsoft propriety Language known as Transact-SQL. It provides further capab
Accounting is an art of recording financial transactions of a business concern. There is a limitation for human memory. It is not possible to remember all transactions of the business. Therefore, the information is recorded in a set of books called Journal and other subsidiary books and it is useful for management in its decision making process. AcroPDF - A Quality PDF Writer and PDF Converter .
