SQL Server là một phần trung tâm của nền tảng dữ liệu Microsoft. SQL Server là giải pháp hàng đầu trong các hệ thống quản lý cơ sở dữ liệu hoạt động (ODBMS). Tài liệu này giúp bạn cài đặt, định cấu hình và sử dụng SQL Server trên cả Windows và Linux. Nội dung bao gồm các ví dụ từ đầu đến cuối, mẫu mã và video. Đối với các chủ đề ngôn ngữ SQL Server, xem Tham khảo ngôn ngữ.
- SQL Server 2014 và các phiên bản cũ hơn bao gồm SQL Server 2005, cũng có sẵn tài liệu tại đây.
- Tài liệu 2019 sẽ có mặt sớm sau khi MS cung cấp
What’s new | Release notes |
---|---|
What’s New in SQL Server 2017 | SQL Server 2017 Release Notes |
SQL Server 2019 preview đã sẵn sàng. For more information, Xem What’s New in SQL Server 2019.
Dùng thử SQL Server!
Nhận các SQL Tools
- Download SQL Server Management Studio (SSMS)
- Download SQL Server Data Tools (SSDT)
- Download Azure Data Studio
Công nghệ của SQL Server Technologies
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. The Database Engine also provides rich support for sustaining high availability. |
|
Machine Learning Services
Microsoft Machine Learning Services supports integration of machine learning, using the popular R and Python languages, into enterprise workflows. 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 Server provides enterprise-scale support for R and Python, without requiring SQL Server. |
|
Integration Services
Integration Services is a platform for building high performance data integration solutions, including packages that provide extract, transform, and load (ETL) processing for data warehousing. |
|
Analysis Services
Analysis Services is an analytical data platform and toolset for personal, team, and corporate business intelligence. Servers and client designers support traditional OLAP solutions, new tabular modeling solutions, as well as self-service analytics and collaboration using Power Pivot, Excel, and a SharePoint Server environment. Analysis Services also includes Data Mining so that you can uncover the patterns and relationships hidden inside large volumes of data. |
|
Reporting Services
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
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 Services
SQL Server Data Quality Services (DQS) provides you with a knowledge-driven data cleansing solution. 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. 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 Services is the SQL Server solution for master data management. A solution built on Master Data Services helps ensure that reporting and analysis is based on the right information. Using Master 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. |
|
Cập nhật các phiên bản SQL Server
- SQL Server Update Center links and information for all supported versions
Ví dụ
- Wide World Importers sample database
- AdventureWorks sample databases and scripts for SQL Server 2016
- SQL Server samples on GitHub
SQL Server 2014, 2012, 2008, 2005
We accumulate and retain documentation for very old versions of SQL Server in a set of archive webpages. 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 2012
- SQL Server 2008 R2
- SQL Server 2008
- SQL Server 2005
SQL Server 2014 documentation is still processed by search engines.
Hỗ trợ
- UserVoice – Suggestion to improve SQL Server?
- Setup and Upgrade – MSDN Forum
- SQL Server Data Tools – MSDN forum
- Transact-SQL – MSDN forum
- SQL Server Security – MSDN Forum
- DBA Stack Exchange (tag sql-server) – ask SQL Server questions
- Stack Overflow (tag sql-server) – also has some answers about SQL development
- Reddit – general discussion about SQL Server
- Microsoft SQL Server License Terms and Information
- Support options for business users
- Contact Microsoft
- All the ways to get help
Contribute SQL documentation
Bạn có biết rằng bạn có thể tự chỉnh sửa nội dung? Nếu bạn làm như vậy, không chỉ tài liệu của chúng tôi sẽ được cải thiện mà bạn còn được ghi nhận là người đóng góp cho chúng.
Link gốc: https://docs.microsoft.com/en-us/sql/sql-server/sql-server-technical-documentation?view=sql-server-2017
Biên tập: PACISOFT.vn