Azure SQL DB Samples and Best Practices

Samples and Best practices to use Azure SQL DB to build modern, mission critical applications, with ease and confidence.

Running the samples

Make sure you have an Azure SQL DB database to use. If you don't have an Azure account you, you can create one for free that will also include a free Azure SQL DB tier:

https://azure.microsoft.com/en-us/free/free-account-faq/

To create a new database, follow the instructions here:

Create Azure SQL Database

or, if you're already comfortable with Azure CLI, you can just execute (using Powershell or Command Prompt, Bash, via WSL, a Linux environment or Azure Cloud Shell)

az group create -n <my-resource-group> -l WestUS2
az sql server create -g <my-resource-group> -n <my-server-name> -u <my-user> -p <my-password>
az sql db create -g <my-resource-group> --server <my-server-name> -n DevDB --service-objective BC_Gen5_2

Once the database is created, you can connect to it using Azure Data Studio. If you need help in setting up your first connection to Azure SQL with Azure Data Studio, this quick video will help you:

How to connect to Azure SQL Database from Azure Data Studio

Azure Data Studio supports Jupyter Notebooks. They will be used in some samples. If you never used them before, take a look here:

Introduction to Azure Data Studio Notebooks

Sample Index

Create Database: Create an Azure SQL database
Restore Database: Restoring a database in Azure SQL
Resilient Connections: How to create resilient solutions with Azure SQL
Work with JSON: Working with JSON data in Azure SQL
Graph Models: Graph model sample and references
GeoSpatial Support: Working with GeoSpatial data in Azure SQL
Key-Value Store: How to implement a Key-Value store with In-Memory tables
Network Latency: How to minimize the impact of network latency with using Azure SQL
Read Committed Snapshot: With Azure SQL default isolation level writers will not block readers
External Data Access: Importing or using external data with Azure SQL
Partitioning: Work In Progress
Updates and Deletes: Work In Progress
Temporal Tables: Work In Progress
Change Tracking: Using Change Tracking to detected changed rows
Change Data Capture: Using Change Data Capture to detected changed data
Columnstore: Work In Progress
Data Masking: Work In Progress
Ledger Tables: Work In Progress
Row Level Security: Work In Progress
Grouping Sets: Work In Progress
Windowing Functions: Work In Progress
Views: Work In Progress
Stored Procedures: Work In Progress
User Defined Functions: Work In Progress

Learn More

If you want to learn more on how to create modern scalable applications with Azure SQL you should read this book:

Practical Azure SQL Database for Modern Developers

that comes loaded with samples too: https://github.com/yorek/practical-azure-sql-db-for-modern-developers

License

yorek/azure-sql-db-samples

ErrorLooks like something went wrong!

About

Resources

License

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Uh oh!

Error
Looks like something went wrong!

Packages