Skip to content

Latest commit

 

History

History
402 lines (224 loc) · 28 KB

README.md

File metadata and controls

402 lines (224 loc) · 28 KB

Awesome Azure SQL resources Awesome

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

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

  • Data replication on Azure SQL Databases: Learn about logical data replication solutions (Change data capture (CDC), SQL Data Sync, and Change tracking) for data tracking, loading, replicating, and streaming that you can use to synchronize data changes from your Azure SQL Database to other destinations.

  • 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

Shows

Community

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

AI

Vectors

Code Samples

Generic

AI

Big Data

Change Stream

Data Loading

DevOps

Dynamic Schema

Full Stack

Geospatial

Graph

GraphQL

Jamstack

REST

ScriptDOM

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

Streaming

Vectors

Articles

Scripts

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.

  • sqlcmd-go: Modern sqlcmd tool to manage and query SQL Server and Azure SQL from the command line.

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

Sync

  • Dotmim.Sync: A brand new database synchronization framework, multi platform, multi databases, developed on top of .Net Standard 2.0.

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

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.

Security

Videos

Azure Friday

Microsoft Build 2023

Conferences

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

Books

Blogs

Official

Social Media

  • Twitter: The official Twitter account for Azure SQL.

  • YouTube: The official YouTube channel for Azure SQL.

GraphQL

Reference