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.

Getting started

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

Labs & Workshops

• sqlworkshops: Lab and Workshops on Azure SQL (and more)

Microsoft Learn

• 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.

Community

• Azure Data Community

Code Samples

• 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
• Creating API to securely access data using Azure SQL Row Level Security
• Creating a REST API with .NET Core and Azure SQL
• Creating a REST API with Python and Azure SQL
• Todo Backend Implementation with Azure Functions, Node and Azure SQL
• TodoMVC Sample App Full Stack Implementation
• Using Change Tracking API to sync data between Apps and the Cloud
• Serverless REST API with Azure Functions, Node and Azure SQL

Graph

• Azure SQL & GraphQL Samples
• Million Song Dataset in Azure SQL DB / SQL Server: Using Graph object in Azure SQL with the Million Song dataset

DevOps

• 📘 Azure SQL Database CI/CD Pipeline with GitHub Actions: Official documentation
• 📄 DevOps for Azure SQL: Everything you want to know around how to apply DevOps to databases, Azure SQL DB in particular
• 📺 Getting Started with DevOps for Azure SQL: What is Data DevOps and a discussion around the first option: migration based deployment
• 📺 Using Azure Pipelines for Azure SQL Deployments: Discussion state based deployment, and full demo on using Azure Pipelines to deploy the database

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

Geospatial

• Monitor GeoFences in real-time using Azure SQL and Stream Analytics
• Real-Time Serverless GeoSpatial Public Transportation GeoFencing Solution

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
• ScriptDOM Samples: Samples on how to use the ScriptDOM parser to parse T-SQL statements

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.
• Smart Bulk Copy: High-Speed Bulk Copy tool to move data from one Azure SQL / SQL Server database to another

Libraries

.NET

• Dapper: A simple object mapper for .Net
• SqlKata: A fluent SQL query builder for C#

Node

• node-mssql: Microsoft SQL Server client for Node.js
• Knex.js: "Batteries included" SQL query builder
• 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

Videos

• Azure SQL for Beginners: 61 small videos to learn everything to get started
• Data Exposed Playlist: an ongoing series to learn everything about the Azure Data platform, Azure SQL included
• 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. Video is free but registration (free too) is required.

Books

• Practical Azure SQL Database for Modern Developers: Building Applications in the Microsoft Cloud with Azure SQL
• Azure SQL Revealed: A Guide to the Cloud for SQL Server Professionals

Blogs

Official

• Azure SQL Devs’ Corner: Azure SQL team blog with focus on developers
• Azure SQL @ TechCommunity: Azure SQL team blog with focus on IT Pros