sql-server-samples README

The project's README from github.com/microsoft/sql-server-samples. As one markdown file: README.md.

Azure Data SQL Samples Repository

This GitHub repository contains code samples that demonstrate how to use Microsoft's Azure Data products including SQL Server, Azure SQL Database, Azure Synapse, and Azure SQL Edge. Each sample includes a README file that explains how to run and use the sample.

Please note that specific features, such as In-Memory OLTP, are edition-specific for SQL Server. These features will only be available if the edition that supports them is used to run the sample.

Releases in this repository

Releases provide convenient downloads of sample databases and applications, eliminating the need to build them from source code. This SQL Server samples repository offers the following notable releases:

To see the complete list of resources in this repository, navigate to Releases (this now includes an entity diagram of Northwind database) to help visual learners.

Working in GitHub

To contribute on GitHub, follow these steps:

Each sample should be in its own folder with a README.md file that follows the template. Generated files (e.g., .exe or .bacpac) and user configuration settings (e.g., .user) should not be committed to GitHub.

Cloning only a subset of the repo (with sparse checkout)

You can follow the steps below to clone individual files from the sql-server-samples git repo. Note: The following script clones only the files under the features and demos folders.

git clone -n https://github.com/Microsoft/sql-server-samples
cd sql-server-samples
git config core.sparsecheckout true
echo samples/features/*| out-file -append -encoding ascii .git/info/sparse-checkout
echo samples/demos/*| out-file -append -encoding ascii .git/info/sparse-checkout
git checkout

For more information about sparse checkout please visit this stackoverflow thread.

Code of Conduct

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.

License

These samples and templates are all licensed under the MIT license. See the license.txt file in the root.

Questions

Email questions to: [email protected].

sql-server-samples (microsoft/sql-server-samples)

Searching Database…

11.3K ·GitHub
Sql-server-samples
这是什么？这是微软官方的代码示例仓库，演示如何使用 SQL Server、Azure SQL Database、Azure Synapse 和 Azure SQL Edge，内容包括示例数据库、演示程序和功能讲解。
这是单个示例项目，还是很多示例的合集？是合集：每个示例都放在自己的文件夹里，并附有单独的 README，说明如何运行，涵盖示例数据库、性能演示和物联网场景等内容。
我该怎样让这些示例运行起来？在仓库的 Releases 页面下载现成的示例数据库和应用程序（如 Wide World Importers 或 AdventureWorks），无需从源码自行构建，然后按照每个示例文件夹中的 README 操作即可。
所有示例都必须使用特定版本的 SQL Server 吗？部分示例依赖特定版本才有的功能，例如 In-Memory OLTP，只有在支持该功能的 SQL Server 版本上运行才能正常使用。
我能只克隆其中一个示例，而不是整个仓库吗？可以，使用 git sparse checkout 只克隆指定的文件夹（例如只克隆 features 和 demos 文件夹），无需下载整个仓库。
这个仓库主要适合哪些人？适合正在学习或评估 SQL Server、Azure SQL、Azure Synapse 或 Azure SQL Edge 功能的开发人员和数据库管理员，通过可实际运行的示例上手，而不只是阅读文档。
Wide World Importers 是什么？它是 SQL Server 2016 和 Azure SQL Database 的主要示例数据库，同时包含 OLTP 和 OLAP 两个数据库。
这里的 AdventureWorks 有什么用？它是一个示例数据库，提供 OLTP、数据仓库和轻量级数据库三种版本，用于学习和测试相关场景。
这个仓库涵盖物联网场景吗？涵盖。IoT Smart Grid 示例展示了 SQL Server 如何接收来自物联网设备和传感器的数据，并对其进行分析。
What are similar projects?efcore, orm, sequelize, beekeeper-studio, directus, chartdb, eShopOnWeb, dsh-data-agent
Which topics is it in?mssql, sql-server, mit-license, data, azure, powershell, examples, microsoft, iot, analytics, mysql, sql
Creator
microsoft
Size
496 MB
Stars
11.3K
Updated
CommitOct 14Releasesql-ml-language-extensions-tutorialsMay 01
Age
10y
Commits · 90 Days