【文章內(nèi)容簡(jiǎn)介】
Express Edition. The first is SQL Server Express with Tools, which includes SQL Server Management Studio Basic. SQL Server Express with Advanced Services adds fulltext search capability and reporting services. Specialized editions Azure Microsoft SQL Azure Database is the cloudbased version of Microsoft SQL Server, presented as software as a service on Azure Services Platform. Compact (SQL CE) The pact edition is an embedded database engine. Unlike the other editions of SQL Server, the SQL CE engine is based on SQL Mobile (initially designed for use with handheld devices) and does not share the same binaries. Due to its small size (1 MB DLL footprint), it has a markedly reduced feature set pared to the other editions. For example, it supports a subset of the standard data types, does not support stored procedures or Views or multiplestatement batches (among other limitations). It is limited to 4 GB maximum database size and cannot be run as a Windows service, Compact Edition must be hosted by the application using it. The version includes supports Synchronization Services. SQL CE does not support ODBC connectivity, unlike SQL Server proper. Developer SQL Server Developer Edition includes the same features as SQL Server Datacenter Edition, but is limited by the license to be only used as a development and test system, and not as production server. This edition is available to download by students free of charge as a part of Microsoft39。s DreamSpark program. Embedded (SSEE) SQL Server 2021 Embedded Edition is a specially configured named instance of the SQL Server Express database engine which can be accessed only by certain Windows Services. Evaluation SQL Server Evaluation Edition, also known as the Trial Edition, has all the features of the Enterprise Edition, but is limited to 180 days, after which the tools will continue to run, but the server services will stop. Fast Track SQL Server Fast Track is specifically for enterprisescale data warehousing storage and business intelligence processing, and runs on referencearchitecture hardware that is optimized for Fast Track. Parallel Data Warehouse (PDW) A massively parallel processing (MPP) SQL Server appliance optimized for largescale data warehousing such as hundreds of terabytes. Architecture Protocol layer Protocol layer implements the external interface to SQL Server. All operations that can be invoked on SQL Server are municated to it via a Microsoftdefined format, called Tabular Data Stream (TDS). TDS is an application layer protocol, used to transfer data between a database server and a client. Initially designed and developed by Sybase Inc. for their Sybase SQL Server relational database engine in 1984, and later by Microsoft in Microsoft SQL Server, TDS packets can be encased in other physical transport dependent protocols, including TCP/IP, Named pipes, and Shared memory. Consequently, access to SQL Server is available over t