SQL Server 2014 的線上叢書Books Online for SQL Server 2014

歡迎使用 MicrosoftMicrosoft MicrosoftMicrosoft® 的《SQL Server 2014SQL Server 2014® 線上叢書》。Welcome to MicrosoftMicrosoft® Books Online for MicrosoftMicrosoft SQL Server 2014SQL Server 2014®. 《線上叢書》包含工作描述和參考文件集,描述如何使用 [SQL Server]SQL Server執行資料管理及商業智慧工作。Books Online contains the task descriptions and reference documentation that describes how to perform data management and business intelligence work by using [SQL Server]SQL Server.

SQL Server 2016 和更新版本中,記載此處SQL Server 2016, and later versions, are documented here. SQL Server 2012 和較舊版本,都記載此處SQL Server 2012, and older versions, are documented here.

現在就試試看:Try it out:
Azure 虛擬機器小型 擁有 Azure 帳戶嗎?Azure Virtual Machine small Have an Azure account? 接著前往 此處 到已安裝 SQL Server 2014 Service Pack 1 (SP1) 的虛擬機器的加速。Then go Here to spin up a Virtual Machine with SQL Server 2014 Service Pack 1 (SP1) already installed. 如需有關 SQL Server 2014 (SP1) 的詳細資訊,請參閱 < SQL Server 2014 Service Pack 1 版本資訊For more information on SQL Server 2014 (SP1), see SQL Server 2014 Service Pack 1 release information.

SQL Server 技術SQL Server Technologies

[SQL Server]SQL Server 包含數種資料管理和分析技術。includes several data management and analysis technologies. 按下表中的連結,以尋找每項技術的功能、工作及參考文件集。Click on the links in the following table to find the feature, task, and reference documentation for each technology.

Database Engine 圖示Database Engine icon 資料庫引擎Database Engine

Database Engine 是用於儲存、處理和保護資料的核心服務。The Database Engine is the core service for storing, processing and securing data. 它提供受控制的存取和快速交易處理,可滿足您企業內部最嚴苛的資料取用應用程式需求。The Database Engine provides controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming applications within your enterprise. Database Engine 還提供豐富的支援以維持高可用性。The Database Engine also provides rich support for sustaining high availability.
BOL 首頁主題的 DQS 標誌DQS Logo for BOL home topic Data Quality ServicesData Quality Services

SQL Server Data Quality Services (DQS) 提供您知識驅動的資料清理方案。SQL Server Data Quality Services (DQS) provides you with a knowledge-driven data cleansing solution. DQS 可讓您建立知識庫,然後使用該知識庫透過電腦輔助及互動式方法,對您的資料執行資料更正及刪除重複資料。DQS enables you to build a knowledge base, and then use that knowledge base to perform data correction and deduplication on your data, using both computer-assisted and interactive means. 您可以使用雲端式參考資料服務,也可以建立資料管理方案,將 DQS 與 SQL Server Integration Services 和 Master Data Services 進行整合。You can use cloud-based reference data services, and you can build a data management solution that integrates DQS with SQL Server Integration Services and Master Data Services.
Analysis Services 圖示Analysis Services icon Analysis Services (英文)Analysis Services

Analysis ServicesAnalysis Services 是一套適用於個人、團隊和企業商業智慧的分析資料平台與工具組。is an analytical data platform and toolset for personal, team, and corporate business intelligence. 伺服器和用戶端設計工具支援傳統的 OLAP 方案、新的表格式模型方案,以及使用 PowerPivot、Excel 和 SharePoint Server 環境的自助式分析與共同作業。Servers and client designers support traditional OLAP solutions, new tabular modeling solutions, as well as self-service analytics and collaboration using PowerPivot, Excel, and a SharePoint Server environment. Analysis ServicesAnalysis Services 也包含資料採礦,讓您能夠發現隱藏在大量資料內部的模式和關聯性。also includes Data Mining so that you can uncover the patterns and relationships hidden inside large volumes of data.
Integration Services 圖示Integration Services icon Integration ServicesIntegration Services

Integration ServicesIntegration Services 是一個平台,用於建立高效能資料整合方案,包括提供資料倉儲之擷取、轉換和載入 (ETL) 處理的封裝。is a platform for building high performance data integration solutions, including packages that provide extract, transform, and load (ETL) processing for data warehousing.
mds_cm_iconmds_cm_icon Master Data ServicesMaster Data Services

Master Data ServicesMaster Data Services 是用於主要資料管理的 [SQL Server]SQL Server 方案。is the [SQL Server]SQL Server solution for master data management. 建立在 Master Data ServicesMaster Data Services 上的方案可協助確保報表和分析乃依據正確的資訊。A solution built on Master Data ServicesMaster Data Services helps ensure that reporting and analysis is based on the right information. 使用 Master Data ServicesMaster Data Services可建立主要資料的中央儲存機制,並且在資料隨時間改變時,維持可稽核且安全的記錄。Using Master Data ServicesMaster Data Services, you create a central repository for your master data and maintain an auditable, securable record of that data as it changes over time.
複寫圖示Replication icon 複寫Replication

複寫是一組技術,用於將資料和資料庫物件從某個資料庫複製和散發到另一個資料庫,然後在兩個資料庫之間進行同步處理以維護一致性。Replication is a set of technologies for copying and distributing data and database objects from one database to another, and then synchronizing between databases to maintain consistency. 使用複寫,您可以透過區域網路、廣域網路、撥號連接、無線連接及網際網路,將資料散發到不同的位置以及遠端或行動使用者。By using replication, you can distribute data to different locations and to remote or mobile users by means of local and wide area networks, dial-up connections, wireless connections, and the Internet.
Reporting Services 圖示Reporting Services icon Reporting ServicesReporting Services

Reporting Services 提供了啟用 Web 的企業級報表功能,讓您可以建立從各種資料來源取得內容的報表、以各種格式發行報表,以及集中管理安全性和訂閱。Reporting Services delivers enterprise, Web-enabled reporting functionality so you can create reports that draw content from a variety of data sources, publish reports in various formats, and centrally manage security and subscriptions.

網站上的 SQL Server 資訊SQL Server Information on the Web

MicrosoftMicrosoft 在幾個網站中發行有關 [SQL Server]SQL Server 的其他資訊。publishes additional information about [SQL Server]SQL Server in several Web sites.

SQL Server 網站SQL Server Web Sites

SQL Server 2005、 2008、 2012、 2016年 +SQL Server 2005, 2008, 2012, 2016+

我們會在一組封存網頁中累積及保留非常舊版 SQL Server 的文件。We accumulate and retain documentation for very old versions of SQL Server in a set of archive webpages. 搜尋引擎,例如 Bing.com 和 Google.com 不會處理已封存的網頁。The archived webpages are not processed by search engines, such as Bing.com and Google.com. 但您可以看到這些在我們的文件的封存_先前版本 /_ 位址:But you can see these archives at our Docs previous-versions/ address:

這些封存的文件至少包含在下列的較舊版本:These archives include the documentation for at least the following older versions:

  • SQL Server 2012SQL Server 2012
  • SQL Server 2008 R2SQL Server 2008 R2
  • SQL Server 2008SQL Server 2008
  • SQL Server 2005SQL Server 2005

SQL Server 2014 文件仍會處理透過搜尋引擎。SQL Server 2014 documentation is still processed by search engines.

SQL Server 2016 和更新版本中,記載此處SQL Server 2016, and later versions, are documented here.

另請參閱See Also

SQL Server 組態管理員說明SQL Server Configuration Manager Help