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 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:
- Wide World Importers sample database v1.0 is the main sample for SQL Server 2016 and Azure SQL Database. It contains both an OLTP and an OLAP database.
- AdventureWorks is a sample database with OLTP, data warehouse and lightweight database options.
- In-Memory OLTP Performance Demo v1.0 illustrates the performance benefits of the In-Memory OLTP technology built into SQL Server and Azure SQL Database.
- IoT Smart Grid sample v1.0 illustrates how SQL Server can be leveraged to ingest data from IoT devices and sensors, and how you can run analytics on that data.
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.
To contribute on GitHub, follow these steps:
- Visit https://github.com/microsoft/sql-server-samples and fork the repository.
- Work in your forked repository.
- When you're ready to make changes or publish your sample for the first time, submit a pull request into the 'master' branch of 'sql-server-samples'.
- One of the approvers will review your request and either accept or reject the pull request.
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.
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.
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.
These samples and templates are all licensed under the MIT license. See the license.txt file in the root.
Email questions to: [email protected].