SQL Server 技術文件SQL Server Technical Documentation

本主題適用於:是SQL Server (從 2016 年起)否Azure SQL Database否Azure SQL 資料倉儲 否平行處理資料倉儲THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

如需舊版的 SQL Server 相關的內容,請參閱安裝 SQL Server 2014For content related to previous versions of SQL Server, see Installation for SQL Server 2014.

可協助您安裝、設定和使用 SQL Server 的文件。Documentation to help you install, configure, and use SQL Server. 內容包括端對端範例、程式碼範例和視訊。The content includes end-to-end examples, code samples, and videos. 如需 SQL ServerSQL Server 語言的主題,請參閱 語言參考For SQL ServerSQL Server language topics, see Language Reference.

您也可以使用說明檢視器離線檢視 SQL Server 文件。You can also view SQL Server documentation offline by using the Help Viewer. 如需詳細資訊,請參閱 SQL Server 說明檢視器與離線內容For more information, see Help Viewer and Offline Content for SQL Server.

SQL Server 2017SQL Server 2017

SQL Server 2016:SQL Server 2016:

SQL Server 技術SQL Server Technologies

SQL 資料庫引擎SQL database engine Database EngineDatabase 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.
R ServerR Server R ServicesR Services

Microsoft R Services 提供多種方法來將受歡迎的 R 語言併入企業工作流程中。Microsoft R Services provides multiple ways to incorporate the popular R language into enterprise workflows.

R 服務 (資料庫內)R Services (In-Database) 會整合 R 語言和 SQL ServerSQL Server,以便藉由呼叫 Transact-SQLTransact-SQL 預存程序輕鬆建立、重新定型以及為模型評分。 stored procedures.

Microsoft R Server 在企業中提供 R 的多平台、可擴充支援,並且支援 Hadoop 和 Teradata 等資料來源。Microsoft R Server provides multi-platform, scalable support for R in the enterprise, and supports data sources such as Hadoop and Teradata.
Data Quality ServicesData Quality Services 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.
Integration ServicesIntegration Services 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.
Master Data Services Master Data ServicesMaster Data Services

Master Data ServicesMaster Data Services 是用於主要資料管理的 SQL ServerSQL 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.
Analysis ServicesAnalysis Services Analysis ServicesAnalysis Services

Analysis ServicesAnalysis Services 是一套適用於個人、團隊和企業商業智慧的分析資料平台與工具組。 is an analytical data platform and toolset for personal, team, and corporate business intelligence. 伺服器和用戶端設計工具支援傳統的 OLAP 方案、新的表格式模型方案,以及使用 Power PivotPower Pivot、Excel 和 SharePoint Server 環境的自助式分析與共同作業。Servers and client designers support traditional OLAP solutions, new tabular modeling solutions, as well as self-service analytics and collaboration using Power PivotPower Pivot, 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.
複寫服務Replication services 複寫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 ServicesReporting Services 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 版本Earlier SQL Server versions

範例資料庫Sample databases

需要協助嗎?需要協助嗎?MSDN 論壇StackoverflowConnectNeed help? Need help? MSDN Forum, Stackoverflow, Connect