Awesome Azure SQL resources

A curated awesome list of resources for taking advantage of everything Azure SQL has to offer, useful for the beginners and the veterans.

Please note that the readme file is autogenerated. Check out here to learn how to contribute (hint: it's super easy!).

• Getting Started
• Labs & Workshops
• Microsoft Learn
• Best Practices
• Shows
• Community
• Code Samples
  • Generic
  • Big Data
  • Change Stream
  • Data Loading
  • DevOps
  • Dynamic Schema
  • Full Stack
  • Geospatial
  • Graph
  • GraphQL
  • REST
  • ScriptDOM
  • Streaming
• Articles
• Scripts
• Tools
• Libraries
  • .NET
  • Node
  • Python
• DevOps
• Administration
• Migration
• Videos
  • Azure Friday
• Conferences
• Books
• Blogs
  • Official
• Social Media

Getting Started

• :tv: Azure SQL for Beginners: 61 small videos to learn everything to get started

Labs & Workshops

• :bar_chart: SQL Workshops: labs and workshops on Azure SQL (and more)

Microsoft Learn

• Azure SQL fundamentals: Learn how to translate your existing SQL Server expertise to Azure SQL including Azure SQL Database and Azure SQL managed instance.

• Azure SQL Modules @ Microsoft Learn: all the Microsoft Learn modules related to Azure SQL. From security to development, from performances to maintenance.

• Build Serverless Full Stack Apps on Azure: learn how to create, build, and deploy modern full stack applications in Azure by using the language of your choice (Python, Node.js, or .NET) and with a Vue.js frontend. Topics covered include modern database capabilities, CI/CD and DevOps, backend API development, REST, and more.

• Deploy IoT solutions with Azure SQL Database: learn how Azure SQL Database provides a price-performant backend for IoT applications. You'll also deploy a template that includes Azure SQL Database, Azure VMs, Azure Functions, and Power BI which simplifies deploying and configuring IoT solutions.

Best Practices

• 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

• Azure SQL Tips: get tips to improve database design, health, and performance right from the Azure SQL product group

• :tv: Data Loading Best Practices on Azure SQL DB: 20 minutes video dedicate on the explanation on the best practices to load data into Azure SQL as fast as possible

Shows

• :tv: Data Exposed Live: Data Exposed Live, Wednesdays 9AM PT

Community

• Azure Data Community: list of user groups and community resources like events, recordings, blogs and so on.

Code Samples

Generic

• Azure SQL Database Hyperscale Named Replicas OLTP Scale-Out Samples: sample of a massively scalable OLTP backed taking advantage of database secondary replicas to offload read-only workload

• 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

• Azure SQL Hyperscale Autoscaler: how to create a serverless solution to automatically scale Azure SQL Hyperscale, based on detected workload

Big Data

• Fast Data Loading in Azure SQL DB using Azure Databricks: samples and best practices on how use Azure SQL with Azure Databricks

Change Stream

• Azure SQL Change Stream with Debezium: set up a change stream from Azure SQL using the open source tool Debezium

Data Loading

• Azure SQL DB Import Data Samples: samples on how to import data (JSON, CSV, Flat-Files, etc) into Azure SQL

• Fast Data Loading in Azure SQL DB using Azure Databricks: samples and best practices on how use Azure SQL with Azure Databricks

DevOps

• Azure SQL Database CI/CD Pipeline with GitHub Actions: a sample on how to deploy Azure SQL using the open source DbUp and running test using NUnit

Dynamic Schema

• Dynamic Schema Management With Azure SQL: samples on how efficiently to handle dynamic schemas in Azure SQL

Full Stack

• Build serverless, full stack applications in Azure: full stack solution using Vue.js, Azure Static Web Apps, Azure Function, Azure SQL Database and a microservice architecture to monitor in real-time public transportation data, create a geofence and send notification when geofence is activated

• REST & GraphQL TodoMVC Sample App Full Stack Implementation with Directus: full Stack TodoMVC Sample app, with REST and GraphQL support, using Directus, Azure Web Apps, Vue.Js and Azure SQL

• REST & GraphQL TodoMVC Sample App Full Stack Implementation with Prisma: full-stack end-to-end implementation - both with REST and GraphQL support - with Azure SQL and Prisma.io of the well-known To-do list sample

• TodoMVC Sample App Full Stack Implementation: Full-Stack implementation of the famous ToDoMVC: Vue.js, .NET Core REST API, Azure SQL

Geospatial

• Monitor GeoFences in real-time using Azure SQL and Stream Analytics: end-to-end solution to processing incoming public transportation data using Azure SQL, Azure Functions, Events Hubs and Stream Analytics

• Real-Time Serverless GeoSpatial Public Transportation GeoFencing Solution: end-to-end solution to processing incoming public transportation data using Azure SQL and Azure Functions

Graph

• Million Song Dataset in Azure SQL DB / SQL Server: using graph objects and columnstore in Azure SQL with the Million Song dataset

GraphQL

• Azure SQL & GraphQL Samples: samples on how to create a GraphQL solution using Azure SQL using .NET, Python or Node

• REST & GraphQL TodoMVC Sample App Full Stack Implementation with Directus: full Stack TodoMVC Sample app, with REST and GraphQL support, using Directus, Azure Web Apps, Vue.Js and Azure SQL

• REST & GraphQL TodoMVC Sample App Full Stack Implementation with Prisma: full-stack end-to-end implementation - both with REST and GraphQL support - with Azure SQL and Prisma.io of the well-known To-do list sample

REST

• Azure SQL Database Hyperscale Named Replicas OLTP Scale-Out Samples: sample of a massively scalable OLTP backed taking advantage of database secondary replicas to offload read-only workload

• Build serverless, full stack applications in Azure: full stack solution using Vue.js, Azure Static Web Apps, Azure Function, Azure SQL Database and a microservice architecture to monitor in real-time public transportation data, create a geofence and send notification when geofence is activated

• Creating a REST API with .NET Core and Azure SQL: create a REST API using Azure SQL, Dapper and .NET

• Creating a REST API with Python and Azure SQL: create a REST API using Azure SQL, Python and Flask

• Creating API to securely access data using Azure SQL Row Level Security: using the Row Level Security feature of Azure SQL to create secure REST API with Python, Flask and JWT

• Dynamic Schema Management With Azure SQL: samples on how efficiently to handle dynamic schemas in Azure SQL

• REST & GraphQL TodoMVC Sample App Full Stack Implementation with Directus: full Stack TodoMVC Sample app, with REST and GraphQL support, using Directus, Azure Web Apps, Vue.Js and Azure SQL

• REST & GraphQL TodoMVC Sample App Full Stack Implementation with Prisma: full-stack end-to-end implementation - both with REST and GraphQL support - with Azure SQL and Prisma.io of the well-known To-do list sample

• Serverless REST API with Azure Functions, Node and Azure SQL: create a serverless REST API using Azure Functions, Node and Azure SQL

• TodoMVC Backend Implementation with Azure Functions, Node and Azure SQLL: create a REST API using Azure SQL, Azure Functions and Node

• TodoMVC Backend Implementation with Azure WebApps, .Net Core and Azure SQL: implementation of the Todo Backend API using ASP.NET Core, JSON, Dapper and Azure SQL

• TodoMVC Sample App Full Stack Implementation: Full-Stack implementation of the famous ToDoMVC: Vue.js, .NET Core REST API, Azure SQL

• Using Change Tracking API to sync data between Apps and the Cloud: create a Python REST API to return only changed data from last sync using the Change Tracking feature of Azure SQL

ScriptDOM

• ScriptDOM Samples: samples on how to use the ScriptDOM parser to parse T-SQL statements

Streaming

• Streaming at Scale: end-to-end solution to implement a streaming at scale scenario

Articles

• Bandwidth-friendly Query Profiling for Azure SQL Database: using Extended Events to profile query execution

• How to use batching to improve application performance: an explanation of batching techniques that can be used to improve performance by a lot

Scripts

• Azure SQL Diagnostic Queries: comprehensive diagnostic and health-check queries

• Azure SQL Tips: get tips to improve database design, health, and performance right from the Azure SQL product group

• sp_whoisactive: comprehensive activity monitoring stored procedure

Tools

• Azure SQL Monitoring: solution for near-realtime monitoring using Grafana and the Telegraf SQL plugin

• dbatools: dbatools is a free PowerShell module with over 500 SQL Server administration, best practice and migration commands included.

• Smart Bulk Copy: high-Speed Bulk Copy tool to move data from one Azure SQL / SQL Server database to another

• sqlpackage.exe: SqlPackage.exe is a command-line utility that automates common database development and deployment tasks

Libraries

.NET

• Dapper: a high-performance micro object mapper for .Net

• EF Core: native .NET Core OR/M mapping tool.

• SqlKata: a fluent SQL query builder for C#

Node

• Knex.js: "Batteries included" SQL query builder

• node-mssql: Microsoft SQL Server client for Node.js

• Prisma: Next-generation ORM for Node.js and TypeScript

• Sequelize: A promise-based Node.js ORM

Python

• SQLAlchemy: Python SQL toolkit and Object Relational Mapper

DevOps

• 📄 Advanced automated deployment of Azure SQL Database with Azure DevOps: detailed tutorial on how to deploy Azure SQL with Azure DevOps

• 📄 Continuous Delivery for Azure SQL DB using Azure DevOps Multi-stage Pipelines: how to create a CD pipeline using Azure DevOps

• 📄 DevOps for Azure SQL: what is DevOps and how it can be applied to Azure SQL

• :tv: DevOps for Azure SQL (1 of 2): Getting Started: what is Data DevOps and a discussion around the first option: migration based deployment

• :tv: DevOps for Azure SQL (2 of 2): Using Azure Pipelines for Azure SQL Deployments: discussion on state based deployment, and full demo on using Azure Pipelines to deploy the database

• sqlpackage.exe: SqlPackage.exe is a command-line utility that automates common database development and deployment tasks

• :blue_book: Use GitHub Actions to connect to Azure SQL Database: official Azure SQL GitHub Actions documentation

Administration

• dbatools: dbatools is a free PowerShell module with over 500 SQL Server administration, best practice and migration commands included.

Migration

• dbatools: dbatools is a free PowerShell module with over 500 SQL Server administration, best practice and migration commands included.

Videos

• :tv: Azure SQL Bootcamp: interactive Azure SQL learning with Anna Hoffman and Bob Ward. Get your Azure SQL questions answered, learn to solve real-world scenarios, and more.

• :tv: Azure SQL for Beginners: 61 small videos to learn everything to get started

• :tv: Create secure API with .NET, Dapper and Azure SQL: Live coding recording of development of a backend API with security, full CI/CD - test included and unexpected requirements, just like the real world.

• :tv: Data Exposed Show: an ongoing series to learn everything about the Azure Data platform, Azure SQL included

• :tv: Data Loading Best Practices on Azure SQL DB: 20 minutes video dedicate on the explanation on the best practices to load data into Azure SQL as fast as possible

• :tv: Serverless Full-Stack Kickstart: recording of the session delivered at the Serverless conference, on how to create a full-stack application from scratch using Azure Static Web Apps, Azure Functions and Azure SQL

• :tv: Taming Dynamic Schemas: three different design tecniques to manage dynamic schemas in Azure SQL ranging from a pure relational solution to a full document/JSON one.

Azure Friday

• :tv: Azure Friday: Azure SQL Database: A developer's best friend: an introduction to some features of Azure SQL Database what you want to start to use right now

• :tv: Azure Friday: Azure SQL Database: An introduction to temporal tables: temporal tables helps to automatically track and query the changes that happends on your data in your database

• :tv: Azure Friday: Azure SQL Database: Multi-model features: Azure SQL Database is relational, modern, multi-model database, with supports for JSON, Graph and Geospatial models

Conferences

• SQLBits: One of the most popular conference on Azure SQL and SQL Server. More than 1000 recordings available for free.

Books

• Azure SQL Revealed: a guide to the cloud for SQL Server Professionals

• Practical Azure SQL Database for Modern Developers: building applications in the Microsoft cloud with Azure SQL

Blogs

Official

• Azure SQL @ TechCommunity: Azure SQL team blog with focus on IT Pros

• Azure SQL Devs’ Corner: Azure SQL team blog with focus on developers

Social Media

• Twitter: official Twitter account for Azure SQL

• YouTube: official YouTube channel for Azure SQL