Some Course Reviews from Similar Courses:
"I've also looked at the database with multiple system monitoring products. But really where do I go from here? and when I find the problem what do I really need to do? Mike really shows you the nitty gritty."
"This was just the course I have been waiting for. Mike's demos and scripts have helped me become a confident tuner. The best thing about this course was that I was able to improve our server performance straightaway."
"I already have a great deal of DBA related experienced in the real world. What this course did for me was help me establish a model, and strategy for database tuning and performance monitoring."
Thank you reviewers for your kind feedback.
IMPORTANT: In Microsoft nomenclature there are two portals: Classic Portal and Azure Portal. The Classic one is being phased out. This Course is entirely based on Azure Portal, which is the newest version.
Additionally, this course is NOT for any of the current Microsoft Certifications.
In this course we are going to cover Azure SQL Database. Azure SQL Database is Microsoft’s cloud database service.
Based on SQL Server database technology and built on Microsoft’s Windows Azure cloud computing platform, SQL Azure enables organizations to store relational data in the cloud and quickly scale the size of their databases up or down as business needs change. Data is hosted, managed and provisioned in Microsoft data centers.
This course takes a hands on, real world approach to working with Azure SQL Databases. While there is some theory most the course will be focused on working with the latest version of Windows Azure.
This course will give YOU the foundation to become more comfortable working inside Windows Azure.
As a SQL Server Consultant I can tell you that many of my customers are MOVING to Windows Azure’s various cloud offerings.
As a matter of fact, 30% of Fortune 500 companies use Azure at some level.
There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.
The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Azure SQL Database. Windows Azure patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.
Enroll Now. Let’s Get Started!!!
In this lecture let's introduce the course.
This course is very specific.
We are going to cover Microsoft's cloud platform SQL Server database called Azure SQL Database.
Is this course right for you?
I want to make sure you know exactly what's in this course.
Let's learn what we are going to cover in this brief lecture.
Before we can migrate our on premise databases to the cloud we will need to create an on premise environment.
You may already have a recent version of SQL Server installed. (SQL Server 2012 on up will do)
If you have an instance already feel free to move to the next lecture.
Before we get our hands dirty we are going to need a Microsoft account.
Let's learn how to create one in this lecture.
You'll need to have an account before you can move forward.
There aren't that many new terms in this lesson.
Let's go over them.
In this lecture let's wrap up what we've learned.
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.
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.
I've been a production SQL Server DBA most of my career.
I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.
Experience, education and passion
I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.
Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).
Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.