SQL Server 2019SQL Server 2019 的新功能What's new in SQL Server 2019SQL Server 2019

適用於: 是SQL Server 否Azure SQL Database 否Azure SQL 資料倉儲 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

SQL Server 2019SQL Server 2019 是以舊版本為基礎,可讓 SQL Server 成長為平台,以供您選擇開發語言、資料類型、內部部署或雲端以及作業系統。builds on previous releases to grow SQL Server as a platform that gives you choices of development languages, data types, on-premises or cloud, and operating systems.

本文摘要說明 SQL Server 2019SQL Server 2019 的新功能和增強功能。This article summarizes new features and enhancements for SQL Server 2019SQL Server 2019.

如需詳細資訊和已知問題,請參閱 SQL Server 2019SQL Server 2019 版本資訊For more information and known issues, see the SQL Server 2019SQL Server 2019 Release Notes.

使用最新的工具以獲得 SQL Server 2019SQL Server 2019 的最佳體驗。Use the latest tools for the best experience with SQL Server 2019SQL Server 2019.

CTP 3.2 2019 年 7 月CTP 3.2 July 2019

Community Technical Preview (CTP) 3.2 是 SQL Server 2019SQL Server 2019 的最新公開版本。Community technology preview (CTP) 3.2 is the latest public release of SQL Server 2019SQL Server 2019. 這個版本對先前的 CTP 版本做了改進,以修正 Bug,提升安全性,以及將效能最佳化。This release includes improvements from previous CTP releases to fix bugs, improve security, and optimize performance. 如需 SQL Server 2019SQL Server 2019 CTP 3.2 之前每個 CTP 版本中引進或改善的功能清單,請參閱 SQL Server 2019SQL Server 2019 CTP 公告封存For a list of features introduced or improved in each of the CTP releases before SQL Server 2019SQL Server 2019 CTP 3.2, see SQL Server 2019SQL Server 2019 CTP announcement archive.

巨量資料叢集的新功能New in big data clusters

新功能或更新New feature or update 詳細資料Details
公開預覽Public preview 在 CTP 3.2 之前,已將 SQL Server 巨量資料叢集提供給註冊的早期採用者使用。Prior to CTP 3.2, SQL Server big data cluster was available to registered early adopters. 此版本讓任何人都能體驗 SQL Server 巨量資料叢集的功能。This release allows anyone to experience the features of SQL Server Big data clusters.

請參閱開始使用 SQL Server 巨量資料叢集See Get started with SQL Server big data clusters.
azdata CTP 3.2 引進了 azdata,這是一種以 Python 編寫的命令列公用程式,可讓叢集管理員透過 REST API 啟動程序和管理巨量資料叢集。CTP 3.2 introduces azdata - a command-line utility written in Python that enables cluster administrators to bootstrap and manage the big data cluster via REST APIs. azdata 取代了 mssqlctlazdata replaces mssqlctl. 請參閱安裝 azdataSee Install azdata.
PolyBasePolyBase 外部資料表資料行名稱現在可用來查詢 SQL Server、Oracle、Teradata、MongoDB 和 ODBC 資料來源。External table column names are now used for querying SQL Server, Oracle, Teradata, MongoDB, and ODBC data sources. 在先前的 CTP 版本中,資料行僅根據目的地上的序數進行繫結,而不會使用外部資料表定義中的資料行名稱。In previous CTP releases, the columns were bound only based on ordinal on the destination and column names in external table definition was not used.
HDFS 階層重新整理HDFS tiering refresh 針對 HDFS 階層處理引進了重新整理功能,以便能夠針對遠端資料的最新快照集重新整理現有的裝載。Introducing refresh functionality for HDFS tiering so that an existing mount can be refreshed for the latest snapshot of the remote data. 請參閱 HDFS 階層處理See HDFS tiering
以筆記本為基礎的疑難排解Notebook-based troubleshooting CTP 3.2 引進了 Jupyter Notebook,用來協助您針對 SQL Server 巨量資料叢集中的元件進行開發探索、診斷和疑難排解CTP 3.2 introduces Jupyter notebooks to assist with deployment and discovery, diagnosis, and troubleshooting for components in a SQL Server big data cluster.
   

Analysis Services 的新功能New in Analysis Services

新功能或更新New feature or update 詳細資料Details
Power BI 快取重新整理的治理設定。Governance setting for Power BI cache refreshes. Power BI 服務會快取儀表板磚的資料和報表資料,以進行 Live Connect 報表的初始載入,進而導致將過多的快取查詢提交給 SSAS,且在極端情況下使伺服器超載。The Power BI service caches dashboard tile data and report data for initial load of Live Connect report, causing an excessive number of cache queries being submitted to SSAS, and in extreme cases overload the server. 此版本引進了 ClientCacheRefreshPolicy 屬性。This release introduces the ClientCacheRefreshPolicy property. 這個屬性可讓您在伺服器層級覆寫此行為。This property allows you to override this behavior at the server level. 若要深入了解,請參閱一般屬性To learn more, see General Properties.
線上附加Online attach 此功能可讓您將表格式模型附加為線上作業。This feature provides the ability to attach a tabular model as an online operation. 線上附加可用於同步處理內部部署查詢擴充環境中的唯讀複本。Online attach can be used for synchronization of read-only replicas in on-premises query scale-out environments. 若要深入了解,請參閱線上附加的詳細資料。To learn more see Online attach in Details.
   

語言延伸模組的新功能New in Language extensions

新功能或更新New feature or update 詳細資料Details
新增預設 JAVA 執行階段New default Java Runtime SQL Server 現在在整個產品中包含 Azul 系統適用於 JAVA 的 Zulu Embedded 支援。SQL Server now includes Azul System's Zulu Embedded for Java support throughout the product. 如需詳細資訊,請參閱 Free supported Java in SQL Server 2019 is now available (現已推出 SQL Server 2019 中的免費支援 JAVA)。For more information, see Free supported Java in SQL Server 2019 is now available.

Linux 上 SQL Server 的新功能New in SQL Server on Linux

新功能或更新New feature or update 詳細資料Details
異動資料擷取 (CDC) 支援Change Data Capture (CDC) support 在 Linux 上現在已針對 SQL Server 2019 支援異動資料擷取 (CDC)。Change Data Capture (CDC) is now supported on Linux for SQL Server 2019.

依元件列出的 SQL Server 2019SQL Server 2019 功能SQL Server 2019SQL Server 2019 features by component

下列各節將重點說明在舊版 SQL Server 2019SQL Server 2019 中增強的新元件和功能。The following sections highlight new components and features that were enhanced in earlier releases of SQL Server 2019SQL Server 2019.

巨量資料叢集Big data clusters

新功能或更新New feature or update 詳細資料Details
可擴充的巨量資料解決方案Scalable big data solution 為 Kubernetes 上執行的 SQL Server、Spark 和 HDFS 容器部署可擴充叢集Deploy scalable clusters of SQL Server, Spark, and HDFS containers running on Kubernetes

讀取、寫入及處理來自 Transact-SQL 或 Spark 的巨量資料Read, write, and process big data from Transact-SQL or Spark

輕鬆結合及分析含有大量巨量資料的高價值關聯式資料Easily combine and analyze high-value relational data with high-volume big data

查詢外部資料來源Query external data sources

在 SQL Server 的受控 HDFS 中儲存巨量資料Store big data in HDFS managed by SQL Server

透過叢集查詢來自多個外部資料來源的資料Query data from multiple external data sources through the cluster

使用 AI、機器學習服務和其他分析工作的資料Use the data for AI, machine learning, and other analysis tasks

在巨量資料叢集中部署及執行應用程式Deploy and run applications in big data clusters
   

如需詳細資料,請參閱什麼是 SQL Server 巨量資料叢集For more details, see What are SQL Server big data clusters

SQL Server 2019SQL Server 2019 (CTP) 公告封存包含此功能所有先前 CTP 版本所公告和變更的功能清單。SQL Server 2019SQL Server 2019 (CTP) announcement archive contains a list of features announced and changed for all previous CTP releases of this feature.

資料庫引擎Database engine

SecuritySecurity

新功能或更新New feature or update 詳細資料Details
加密索引的資料行Index encrypted columns 可在使用隨機加密方式以及啟用記憶體保護區的索引鍵所加密的資料行上建立索引,改善雜雜查詢 (使用 LIKE 與比較運算子) 的效能。Create indexes on columns encrypted using randomized encryption and enclave-enabled keys, to improve the performance of rich queries (using LIKE and comparison operators). 請參閱具有安全記憶體保護區的 Always EncryptedSee Always Encrypted with Secure Enclaves.
暫止和繼續透明資料加密 (TDE) 的初始掃描Suspend and resume initial scan for Transparent Data Encryption (TDE) 請參閱透明資料加密 (TDE) 掃描 - 暫止和繼續See Transparent Data Encryption (TDE) scan - suspend and resume
SQL Server 組態管理員中的憑證管理Certificate management in SQL Server Configuration Manager 請參閱憑證管理 (SQL Server 組態管理員)See Certificate Management (SQL Server Configuration Manager)
   

圖表Graph

新功能或更新New feature or update 詳細資料Details
邊緣條件約束串聯刪除動作Edge constraint cascade delete actions 在圖表資料庫的邊緣條件約束中定義串聯刪除動作。Define cascaded delete actions on an edge constraint in a graph database. 請參閱邊緣條件約束SeeEdge constraints.
新的圖形函式 - SHORTEST_PATHNew graph function - SHORTEST_PATH 可使用 MATCH 中的 SHORTEST_PATH,尋找圖形中兩個節點之間最短的路徑,或是執行任意長度的周遊。Use SHORTEST_PATH inside MATCH to find the shortest path between any 2 nodes in a graph or to perform arbitrary length traversals.
分割區資料表與索引Partition tables and indexes 分割區資料表與索引的資料,會分成可分散於圖形資料庫中多個檔案群組之間的單位。The data of partitioned tables and indexes is divided into units that can be spread across more than one filegroup in a graph database.
在圖形比對查詢中使用衍生資料表或檢視別名Use derived table or view aliases in graph match query 請參閱圖表邊緣條件約束See Graph Edge Constraints.
   

索引Indexes

新功能或更新New feature or update 詳細資料Details
OPTIMIZE_FOR_SEQUENTIAL_KEY 可在能協助改善對索引進行高並行插入之輸送量的資料庫引擎內,開啟最佳化。Turns on an optimization within the database engine that helps improve throughput for high-concurrency inserts into the index. 此選項適用於可能出現最後一頁插入競爭的索引,通常是具有循序鍵 (例如識別資料行、序列或日期/時間資料行) 的索引。This option is intended for indexes that are prone to last-page insert contention, typically seen with indexes that have a sequential key such as an identity column, sequence, or date/time column. 如需詳細資訊,請參閱 CREATE INDEXSee CREATE INDEX for more information.
線上建置和重建叢集資料行存放區索引Build and rebuild online clustered columnstore index 請參閱線上執行索引作業See Perform Index Operations Online.
   

記憶體內部資料庫In memory databases

新功能或更新New feature or update 詳細資料Details
混合式緩衝集區的 DDL 控制項DDL control for hybrid buffer pool 透過混合式緩衝集區,坐落在置於持續性記憶體 (PMEM) 裝置上之資料庫檔案上的資料庫頁面,可在必要時直接存取。With hybrid buffer pool, database pages sitting on database files placed on a persistent memory (PMEM) device will be directly accessed when required.
經記憶體最佳化的 tempdb 中繼資料Memory-optimized tempdb metadata 請參閱記憶體最佳化的 TempDB 中繼資料See Memory-Optimized TempDB Metadata
   

連結的伺服器Linked servers

新功能或更新New feature or update 詳細資料Details
連結的伺服器支援 UTF-8字元編碼方式。Linked Servers support UTF-8 character encoding. 定序與 Unicode 支援Collation and Unicode Support
   

PolyBasePolyBase

新功能或更新New feature or update 詳細資料Details
PolyBasePolyBase 外部資料表資料行名稱現在可用來查詢 SQL Server、Oracle、Teradata、MongoDB 和 ODBC 資料來源。External table column names are now used for querying SQL Server, Oracle, Teradata, MongoDB & ODBC data sources.
   

定序Collation

新功能或更新New feature or update 詳細資料Details
支援 UTF-8 字元編碼Support UTF-8 character encoding 已針對 BIN2 定序啟用 (Latin1_General_100_BIN2_UTF8)。Enabled for a BIN2 collation (Latin1_General_100_BIN2_UTF8). 請參閱定序與 Unicode 支援See Collation and Unicode Support.
在安裝期間選取 UTF-8 定序作為預設Select UTF-8 collation as default during setup 請參閱定序與 Unicode 支援See Collation and Unicode Support.
   

伺服器設定Server settings

新功能或更新New feature or update 詳細資料Details
可於安裝期間設定 MINMAX 的伺服器記憶體值Set MIN and MAX server memory values at setup 在安裝期間,您可設定伺服器記憶體的值。During setup, you can set server memory values. 可以使用預設值、導出的建議值,若您已選擇 [建議] 選項 Server Memory Server Configuration Options,也可以手動指定您自己的值。Use the default values, the calculated recommended values, or manually specify your own values once you've chosen the Recommended option Server Memory Server Configuration Options.
SQL Server 安裝程式啟用 MAXDOP 設定SQL Server Setup enables MAXDOP settings 新建議遵循記載的指導方針。請設定 [平行處理原則的最大程度] 伺服器組態選項New recommendations follow the documented guidelines.Configure the max degree of parallelism Server Configuration Option
混合式緩衝集區Hybrid buffer pool 這是 SQL Server 資料庫引擎的新功能,其中坐落在位於持續性記憶體 (PMEM) 裝置資料庫檔案上的資料庫頁面,會在必要時被直接存取。New feature of the SQL Server database engine where database pages sitting on database files placed on a persistent memory (PMEM) device will be directly accessed when required. 請參閱混合式緩衝集區See Hybrid buffer pool .
   

效能監控Performance monitoring

新功能或更新New feature or update 詳細資料Details
純量 UDF 內嵌Scalar UDF inlining 將純量使用者定義函式 (UDF) 自動轉換成關聯運算式,並將它們內嵌在呼叫 SQL 查詢中。Automatically transforms scalar user-defined functions (UDF) into relational expressions and embeds them in the calling SQL query. 請參閱純量 UDF 內嵌See Scalar UDF Inlining.
sys.dm_exec_requests 資料行 commandsys.dm_exec_requests column command SELECT 正在等候同步統計資料更新作業完成以繼續查詢執行的情況下,顯示 SELECT (STATMAN)Shows SELECT (STATMAN) if a SELECT is waiting for a synchronous statistics update operation to complete prior to continuing query execution. 請參閱 sys.dm_exec_requestsSee sys.dm_exec_requests.
WAIT_ON_SYNC_STATISTICS_REFRESH sys.dm_os_wait_stats 動態管理檢視中的新等候類型。New wait type in sys.dm_os_wait_stats dynamic management view. 它會顯示花費在同步統計資料重新整理作業上的累積執行個體層級時間。It shows the accumulated instance-level time spent on synchronous statistics refresh operations. 請參閱 sys.dm_os_wait_statsSee sys.dm_os_wait_stats.
查詢存放區的自訂擷取原則Custom capture policy for the Query Store 啟用後,即可在新的查詢存放區擷取原則設定下使用額外查詢存放區設定,來微調特定伺服器中的資料收集。When enabled, additional Query Store configurations are available under a new Query Store Capture Policy setting, to fine-tune data collection in a specific server. 如需詳細資訊,請參閱 ALTER DATABASE SET 選項For more information, see ALTER DATABASE SET Options.
sys.dm_exec_query_plan_stats 新 DMF 在大多數查詢中會傳回最後一個已知實際執行計畫的對等項目。New DMF returns the equivalent of the last known actual execution plan for most queries. 請參閱 sys.dm_exec_query_plan_statsSee sys.dm_exec_query_plan_stats.
LAST_QUERY_PLAN_STATS 可啟用 sys.dm_exec_query_plan_stats 的新資料庫範圍設定。New database scoped configuration to enable sys.dm_exec_query_plan_stats. 請參閱 ALTER DATABASE SCOPED CONFIGURATIONSee ALTER DATABASE SCOPED CONFIGURATION.
LIGHTWEIGHT_QUERY_PROFILING 新的資料庫範圍設定。New database scoped configuration. 請參閱 LIGHTWEIGHT_QUERY_PROFILINGSee LIGHTWEIGHT_QUERY_PROFILING.
query_post_execution_plan_profile 不同於使用標準分析的 query_post_execution_showplan,擴充事件會根據輕量型分析收集實際執行計畫的對等項目。Extended Event collects the equivalent of an actual execution plan based on lightweight profiling, unlike query_post_execution_showplan which uses standard profiling. 請參閱查詢分析基礎結構See Query profiling infrastructure.
資料列模式記憶體授與意見反應。Row mode memory grant feedback. 資料列模式記憶體授與意見反應Row mode memory grant feedback
資料表變數延後編譯。Table variable deferred compilation. 資料表變數延後編譯Table variable deferred compilation
近似的 COUNT DISTINCTApproximate COUNT DISTINCT. 近似查詢處理Approximate query processing
資料列存放區上的批次模式。Batch mode on rowstore. 資料列存放區上的批次模式Batch mode on rowstore

語言延伸模組Language extensions

新功能或更新New feature or update 詳細資料Details
新增 Java 語言 SDKNew Java language SDK 簡化可從 SQL Server 執行的 Java 程式開發。Simplifies development of Java programs that can be run from SQL Server. 請參閱 SQL Server 機器學習服務的新功能See What's new in SQL Server Machine Learning Services.
SQL Server 語言擴充功能 - Java 語言擴充功能 (英文)SQL Server Language Extensions - Java language extension Microsoft SQL Server 中適用於 Java 的 Microsoft 擴充性 SDK 現已提供開放原始碼且可在 GitHub 上取得The Microsoft Extensibility SDK for Java for Microsoft SQL Server is now open source and available on GitHub.
註冊外部語言Register external languages 新的 DDL CREATE EXTERNAL LANGUAGE 在 SQL Server 中註冊外部語言,如同 Java。New DDL, CREATE EXTERNAL LANGUAGE, registers external languages, like Java, in SQL Server. 請參閱建立外部語言See CREATE EXTERNAL LANGUAGE.
Java 資料類型的支援Support for Java data types 請參閱 Java 資料類型See Java data types.

空間Spatial

新功能或更新New feature or update 詳細資料Details
新增空間參考識別碼 (SRID)New spatial reference identifiers (SRIDs) 澳洲 GDA2020 提供更強大且精確的資料,可與全球定位系統更加緊密結合。Australian GDA2020 provides more robust and accurate datum which is more closely aligned to global positioning systems. 新的 SRID 包含:The new SRIDs are:

- 7843 - 地理 2D- 7843 - geographic 2D
- 7844 - 地理 3D- 7844 - geographic 3D

sys.spatial_reference_systems 檢視包含新 SRID 的定義。sys.spatial_reference_systems view contains definitions of new SRIDs.
   

效能Performance

新功能或更新New feature or update 詳細資料Details
加速資料庫復原Accelerated database recovery 啟用每個資料庫的加速資料庫復原。Enable accelerated database recovery per-database. 請參閱加速資料庫復原See Accelerated database recovery.
強制執行向前快轉及靜態資料指標Forcing fast forward and static cursors 查詢存放區計畫強制支援向前快轉及靜態資料指標。Query Store plan forcing support for fast forward and static cursors. 請參閱計畫強制支援向前快轉及靜態資料指標See Plan forcing support for fast forward and static cursors.
減少對工作負載的重新編譯Reduced recompilations for workloads 改善跨多個範圍使用暫存資料表的功能。Improves using temporary tables across multiple scopes. 請參閱減少對工作負載的重新編譯See Reduced recompilations for workloads
間接檢查點延展性Indirect checkpoint scalability 請參閱改善的間接檢查點延展性See Improved indirect checkpoint scalability.
   

可用性群組Availability groups

新功能或更新New feature or update 詳細資料Details
最多五個同步複本Up to five synchronous replicas SQL Server 2019SQL Server 2019 會將同步複本的數目上限,從 SQL Server 2017 (14.x)SQL Server 2017 (14.x) 中最多為 3 的狀態增加至 5。increases the maximum number of synchronous replicas to 5, up from 3 in SQL Server 2017 (14.x)SQL Server 2017 (14.x). 您可以設定這五個複本的群組,使其在群組內具備自動容錯移轉。You can configure this group of five replicas to have automatic failover within the group. 有一個主要複本,再加上四個同步次要複本。There is one primary replica, plus four synchronous secondary replicas.
次要到主要複本連線重新導向Secondary-to-primary replica connection redirection 可將用戶端應用程式連線導向至主要複本,而不論連接字串中指定的目標伺服器為何。Allows client application connections to be directed to the primary replica regardless of the target server specified in the connection string. 如需詳細資料,請參閱次要到主要複本讀取/寫入連線重新導向 (Always On 可用性群組)For details, see Secondary to primary replica read/write connection redirection (Always On Availability Groups).
   

錯誤訊息Error messages

新功能或更新New feature or update 詳細資料Details
詳細資訊截斷警告Verbose truncation warnings 截斷錯誤訊息預設為包含資料表和資料行名稱,以及被截斷的值。Truncation error message defaults to include table and column names, and truncated value. 請參閱 VERBOSE_TRUNCATION_WARNINGSSee VERBOSE_TRUNCATION_WARNINGS.
   

Linux 上的 SQL ServerSQL Server on Linux

新功能或更新New feature or update 詳細資料Details
新的容器登錄New container registry 開始使用 Docker 上的 SQL Server 容器Get started with SQL Server containers on Docker
具有 Kubernetes 之 Docker 容器上的 Always On 可用性群組Always On Availability Group on Docker containers with Kubernetes 容器的 Always On 可用性群組Always On Availability Groups for containers
複寫支援Replication support Linux 上的 SQL Server 複寫SQL Server Replication on Linux
Microsoft Distributed Transaction Coordinator (MSDTC) 支援Support for the Microsoft Distributed Transaction Coordinator (MSDTC) 如何在 Linux 上設定 MSDTCHow to configure MSDTC on Linux
第三方 AD 提供者的 OpenLDAP 支援OpenLDAP support for third-party AD providers 教學課程:在 Linux 上搭配使用 Active Directory 驗證與 SQL ServerTutorial: Use Active Directory authentication with SQL Server on Linux
Linux 上的機器學習Machine Learning on Linux 在 Linux 上設定機器學習服務Configure Machine Learning on Linux
Tempdb 的改進內容Tempdb improvements 根據預設,在 Linux 上進行新的 SQL Server 安裝,會依據邏輯核心的數目 (最多 8 個資料檔案),建立多個 tempdb 資料檔。By default, a new installation of SQL Server on Linux creates multiple tempdb data files based on the number of logical cores (with up to 8 data files). 此情況不適用於就地次要或主要版本升級。This does not apply to in-place minor or major version upgrades. 每個 tempdb 檔為 8 MB,且可自動成長到 64 MB。Each tempdb file is 8 MB with an auto growth of 64 MB. 此行為類似於 Windows 上的預設 SQL Server 安裝。This behavior is similar to the default SQL Server installation on Windows.
Linux 上的 PolyBasePolyBase on Linux 在 Linux 上為非 Hadoop 連接器安裝 PolyBaseInstall PolyBase on Linux for non-Hadoop connectors.

PolyBase 類型對應PolyBase type mapping.
   

SQL Server 機器學習服務SQL Server Machine Learning Services

新功能或更新New feature or update 詳細資料Details
分割區型模型Partition-based modeling 使用新增至 sp_execute_external_script 的參數,處理您資料每個資料分割的外部指令碼。Process external scripts per partition of your data using the new parameters added to sp_execute_external_script. 此功能支援訓練許多小型模型 (每個資料的資料分割一個模型),而不是一個大型模型。This functionality supports training many small models (one model per partition of data) instead of one large model. 請參閱建立分割區型模型See Create partition-based models
Windows Server 容錯移轉叢集Windows Server Failover Cluster 在 Windows Server 容錯移轉叢集上設定機器學習服務的高可用性。Configure high availability for Machine Learning Services on a Windows Server Failover Cluster.
   

Master Data ServicesMaster Data Services

新功能或更新New feature or update 詳細資料Details
支援 Azure SQL Database 受控執行個體資料庫。Supports Azure SQL Database managed instance databases. 在受控執行個體上裝載 Master Data ServicesMaster Data ServicesHost Master Data ServicesMaster Data Services on a managed instance. 請參閱 Master Data ServicesMaster Data Services 安裝和設定See Master Data ServicesMaster Data Services installation and configuration.
新增 HTML 控制項New HTML controls HTML 控制項取代所有先前的 Silverlight 元件。HTML controls replace all former Silverlight components. 已移除 Silverlight 相依性。Silverlight dependency removed.
   

Analysis ServicesAnalysis Services

新功能或更新New feature or update 詳細資料Details
表格式模型中的計算群組Calculation groups in tabular model 表格式模型中的計算群組Calculation groups in tabular model
MDX 查詢支援具有計算群組的表格式模型MDX query support for tabular models with calculation groups 請參閱計算群組See Calculation groups.
使用計算群組的量值動態格式Dynamic formatting of measures using calculation groups 這項功能可讓您依條件變更具有計算群組之量值的格式字串。This feature allows you to conditionally change format strings for measures with calculation groups. 例如,透過貨幣轉換,量值可以使用不同的外幣格式顯示。For example, with currency conversion, a measure can be displayed using different foreign currency formats.
表格式模型中的多對多關聯性Many-to-many relationships in tabular models 表格式模型中的多對多關聯性Many-to-many relationships in tabular models
資源管理的屬性設定Property settings for resource governance 資源治理的屬性設定Property settings for resource governance
   

已啟用部署案例Enabled deployment scenarios

CTP 3.2 可啟用下列案例:CTP 3.2 enables the following scenarios:

  • 並存安裝。Side-by-side installation. 安裝 SQL Server 2019 CTP 3.2 執行個體,以及 SQL Server 2012 到 SQL Server 2017 的執行個體,或是 SQL Server 2019 CTP 3.0 或更高版本的其他執行個體。Install instances of SQL Server 2019 CTP 3.2 with instances of SQL Server 2012 through SQL Server 2017, or other instances SQL Server 2019 CTP 3.0 or higher.

    注意

    雖然 SQL Server 2008 和 2008 R2 不會禁止並存安裝,但它們與 SQL Server 2019 之間並沒有一般支援的 Windows 作業系統版本。While side-by-side is not blocked with SQL Server 2008 and 2008 R2, there are no commonly supported Windows Operating system versions between them and SQL Server 2019.

  • 就地升級。In-place upgrade. 從 SQL Server 2012 到 SQL Server 2017 和 SQL Server CTP 3.0 的執行個體,升級至 SQL Server 2019 CTP 3.2 的執行個體。Upgrade instances of SQL Server 2019 CTP 3.2 from instances of SQL Server 2012 through SQL Server 2017 and SQL Server CTP 3.0. 不支援從 3.0 以下的 SQL Server 2019 CTP 進行升級,必須執行新的安裝。Upgrade from a SQL Server 2019 CTP below 3.0 is not supported, a new installation must be performed.

    注意

    雖然不會禁止從 SQL Server 2008 和 2008 R2 進行就地升級,但它們與 SQL Server 2019 之間並沒有一般支援的 Windows 作業系統版本。While in-place upgrade from SQL Server 2008 and 2008 R2 is not blocked, there are no commonly supported Windows Operating system versions between them and SQL Server 2019.

支援Support

SQL Server 2019 CTP 3.2 是預覽版軟體。SQL Server 2019 CTP 3.2 is preview software. 這不是公開支援運作的軟體。It is not publicly supported for operations. 參與 SQL 早期採用者計劃的客戶,可能透過與 Microsoft 協商的特殊合約支援執行 SQL Server 2019 CTP 3.2。Customers who are in the SQL Early Adopter Program, may have support to run SQL Server 2019 CTP 3.2 by special agreement, in consultation with Microsoft.

您可以在下列其中一個位置,找到針對非早期採用方案客戶提供的有限支援:Limited support for customers not in the early adoption program may be found at one of the following locations:

請試用 SQL Server 2019SQL Server 2019Try SQL Server 2019SQL Server 2019!

如需從支援中排除之特定功能的資訊,請參閱版本資訊For specific features excluded from support, see the release notes.

此外,也為 SQL Server 2019SQL Server 2019 CTP 3.2 新增或強化了下列功能。In addition, the following features are added or enhanced for SQL Server 2019SQL Server 2019 CTP 3.2.

另請參閱See also

後續步驟Next steps

info_tip 取得說明Get Help