SQL Server 文件集SQL Server Documentation

本主題的適用對象: 是SQL Server沒有Azure SQL Database沒有Azure SQL 資料倉儲沒有Parallel Data WarehouseTHIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

SQL Server 是 Microsoft 資料平台的核心。SQL Server is a central part of the Microsoft data platform. SQL Server 是操作資料庫管理系統 (ODBMS) 的業界領導者。SQL Server is an industry leader in operational database management systems (ODBMS). 本文件可協助您在 Windows 和 Linux 上安裝、設定及使用 SQL Server。This documentation helps you install, configure, and use SQL Server on both Windows and Linux. 內容包括端對端範例、程式碼範例和視訊。The content includes end-to-end examples, code samples, and videos. 如需 SQL Server 語言主題,請參閱語言參考For SQL Server language topics, see Language Reference.

SQL Server 是 Microsoft 資料平台的核心。SQL Server is a central part of the Microsoft data platform. SQL Server 是操作資料庫管理系統 (ODBMS) 的業界領導者。SQL Server is an industry leader in operational database management systems (ODBMS). 本文件可協助您在 Windows 上安裝、設定及使用 SQL Server。This documentation helps you install, configure, and use SQL Server on Windows. 內容包括端對端範例、程式碼範例和視訊。The content includes end-to-end examples, code samples, and videos. 如需 SQL Server 語言主題,請參閱語言參考For SQL Server language topics, see Language Reference.

新功能What's new 版本資訊Release notes
SQL Server 2017 的新功能What's New in SQL Server 2017 SQL Server 2017 版本資訊SQL Server 2017 Release Notes
SQL Server 2016 的新功能What's New in SQL Server 2016 SQL Server 2016 版本資訊SQL Server 2016 Release Notes

info_tip SQL Server 2014 內容即將合併至 .docs 網站。The SQL Server 2014 content will soon be merged into the .docs site. 現在,請先參閱:For now, see:

新功能What's new 版本資訊Release notes
SQL Server 2017 的新功能What's New in SQL Server 2017 SQL Server 2017 版本資訊SQL Server 2017 Release Notes
新功能What's new 版本資訊Release notes
SQL Server 2016 的新功能What's New in SQL Server 2016 SQL Server 2016 版本資訊SQL Server 2016 Release Notes

試用 SQL Server!Try SQL Server!

試用 SQL Server!Try SQL Server!

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 機器學習服務Machine Learning Services

Microsoft Machine Learning 服務支援將機器學習 (使用受歡迎的 R 和 Python 語言) 整合到企業的工作流程。Microsoft Machine Learning Services supports integration of machine learning, using the popular R and Python languages, into enterprise workflows.

Machine Learning 服務 (資料庫內) 將 R 和 Python 與 SQL Server 整合,藉由呼叫預存程序,以輕鬆建立、重新定型模型,以及為模型評分。Machine Learning Services (In-Database) integrates R and Python with SQL Server, making it easy to build, retrain, and score models by calling stored procedures. Microsoft Machine Learning 伺服器提供企業規模的 R 和 Python 支援,而不需要 SQL Server。Microsoft Machine Learning Server provides enterprise-scale support for R and Python, without requiring SQL Server.
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.
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.
Reporting ServicesReporting Services Reporting ServicesReporting Services

Reporting Services 提供啟用 Web 的企業級報告功能。Reporting Services delivers enterprise, Web-enabled reporting functionality. 您可以建立從各種資料來源取得內容的報表、以各種格式發行報表,以及集中管理安全性和訂閱。You can create reports that draw content from a variety of data sources, publish reports in various formats, and centrally manage security and subscriptions.
複寫服務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.
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.
Master Data Services Master Data ServicesMaster Data Services

Master Data ServicesMaster Data Services 是用於主要資料管理的 SQL ServerSQL Server 方案。 is the 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.

移轉並移動資料Migrate and move data

移轉並移動資料Migrate and move data

更新您 SQL Server 的版本Update your version of SQL Server

範例Samples

info_tip 取得說明Get Help

編輯內容 參與 SQL 文件Contribute SQL documentation