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)

mssql
Searching Database…

11.3K ·GitHub
Sql-server-samples
What is this?This is Microsoft's official repository of code samples demonstrating how to use SQL Server, Azure SQL Database, Azure Synapse, and Azure SQL Edge, including sample databases, demos, and feature walkthroughs.
Is this a single sample project or a collection of many samples?It is a collection: each sample lives in its own folder with its own README explaining how to run it, covering things like sample databases, performance demos, and IoT scenarios.
How do I get the samples running?Browse the repo's Releases page to download ready-made sample databases and applications (like Wide World Importers or AdventureWorks) instead of building from source, then follow the README inside each sample folder.
Do I need a specific SQL Server edition for all samples?Some samples rely on edition-specific features, such as In-Memory OLTP, which only work if you run them on a SQL Server edition that supports that feature.
Can I clone just one sample instead of the whole repo?Yes, you can use git sparse checkout to clone only specific folders (e.g. just the features and demos folders) instead of pulling down the entire repository.
Who is this repo mainly useful for?Developers and DBAs learning or evaluating SQL Server, Azure SQL, Azure Synapse, or Azure SQL Edge features through hands-on, runnable examples rather than documentation alone.
What is Wide World Importers?It is the main sample database for SQL Server 2016 and Azure SQL Database, containing both an OLTP and an OLAP database.
What is AdventureWorks used for here?It is a sample database offered with OLTP, data warehouse, and lightweight database options for learning and testing scenarios.
Does the repo cover IoT scenarios?Yes, the IoT Smart Grid sample shows how SQL Server can ingest data from IoT devices and sensors and run analytics on it.
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