Learn How To Become an Azure SQL Database Architect

Let's take a high level look at the layout of the portal.

We will cover the basics of navigating SQL Database.

Let's create a database in this lecture using the portal.

Most DBAs will be using SSMS to manage their cloud instances.

Let's walk through the 2 key steps you'll need to take before you can connect to your azure database.

Let's restore a database we created earlier.

The steps are quite different compared to our on premise database.

Microsoft has come up with a novel way to measure database usage.

They call it a DTU. Let's examine what that is in this lecture.

There are two approaches to DR and HA using Azure SQL Database.

They are Geo-Restore and Geo-Replication.

Let's talk about them in this lecture.

In this lecture we will do three things.

1. Set up Geo-Replication between the West and East Region.
2. Fail the West Region over to the East Region.
3. Remove it.

Threat Detection is a great approach Microsoft is using to primarily stop SQL Injections.

Let's discuss it and set it up in this lecture.

TDE for Azure SQL Databases.

It's been there for awhile with on-premise databases now they have it in the cloud.

Let's cover that in this lecture.

In this lecture let's learn what Elastic Database Pools are.

The will really help us control groups of databases with varying degrees of usage.

In this lecture lets set up an elastic database pool.

This is a very simple setup and I'm sure it will be widely used for real world applications.

In this lecture let's define and then set up data masking.

This is a great technique for hiding credit card numbers and social security numbers.

Let's set up a simple CPU alert and create some monitoring dashboards.

Just like with our on-premise database we will want to restrict access for specific users.

Let's learn how to do that in this brief video.

Let's cover the new vernacular from this section.

Let's wrap up what we've covered in this section.

In this lecture we will create a new environment for our databases.

We will spin up a bare bones instance so we can begin migrating our databases to Azure.

Let's walk through the most simple way we can move our schema and data to Azure.

In this lecture let's create a copy of a database using SSMS on our cloud instance.

Let's move data from our on premise environment to Azure SQL Database using SSIS.

Import from BACPAC to SQL Database using SSMS

Let's wrap up what we've covered.

Final thoughts and a thank you.