Azure SQL Demos, Reference Architectures & Best Practices

This repository is meant to organize Carl's Microsoft's Open Azure SQL based repositories for customer ready demos.

Keywords

Azure, Azure SQL, Azure Elastic Scale, Azure Hyper Scale, Azure Synapse, Azure SQL Migration

Table of contents

1. Getting Started
2. Azure SQL Migration Demo
3. Azure SQL Performance Tuning Demo
4. Azure SQL MI CLR Demo
5. Azure SQL Database DB (Coming Soon)
6. Azure Elastic Scale Demo(Coming Soon)
7. Azure Hyper Scale Demo(Coming Soon)
8. Azure Synapse Demo(Coming Soon)
9. Azure SQL MI Demo(Coming Soon)

Getting Started

This repository is arranged as submodules so you can either pull all the tutorials or simply the ones you want. To pull all the tutorials run:

git clone --recurse-submodules https://github.com/microsoft/ai

if you have git older than 2.13 run:

git clone --recursive https://github.com/microsoft/ai.git

To pull a single submodule (e.g. DeployDeepModelKubernetes) run:

git clone https://github.com/microsoft/ai
cd ai
git submodule init submodules/DeployDeepModelKubernetes
git submodule update

Azure SQL Migration Demos

Updated: 06/12/2020
I will demonstrate how to utilize the Data Migration Service (DMS) to Migrate from On-Premise SQL to the following Azure SQL PaaS Offerings:

Azure SQL Performance Tuning Demo

Updated: 06/12/2020
These demos discuss the monitoring Azure SQL Databases using Metrics and diagnostics logging, Query performance Insight, Azure SQL Analytics for Advance performance Monitoring, and contrast this with On-premise vs PaaS approaches

Azure SQL MI CLR Demo

Updated: 06/12/2020
This demo will cover how to deploy a CLR Assembly to SQL Managed Instance

Azure SQL Database DB (Coming Soon)

Azure Elastic Scale Demo(Coming Soon)

Azure Hyper Scale Demo(Coming Soon)

Azure Synapse Demo(Coming Soon)

Azure Synapse Demo(Coming Soon)