SQL Server: Implementing a Hybrid Cloud Solution in Azure

The course will show you how to create, manage, and scale Azure VMs for SQL Server workloads, implement Azure SQL Database, and work with them from your on-premises SQL Server for a complete Hybrid SQL Server solution.
Course info
Rating
(16)
Level
Beginner
Updated
Dec 8, 2017
Duration
2h 20m
Table of contents
Course Overview
Introduction
Understanding Azure IaaS
Understanding Hybrid Solutions
Understanding How to Create and Manage Azure VMs
Migrating Databases to Azure VMs and Scaling
Understanding Azure SQL Database and Stretch Databases
Monitoring Options with Azure Portal and SSMS
Description
Course info
Rating
(16)
Level
Beginner
Updated
Dec 8, 2017
Duration
2h 20m
Description

Have you been wondering what Azure Virtual Machines or Azure SQL Databases are and what they mean for you as a production DBA or developer? The Azure platform has become an Enterprise-worthy environment that can provide Infrastructure as a Service and a database Platform as a Service. In this course, SQL Server: Implementing a Hybrid Cloud Solution in Azure, you'll learn the fundamentals of Azure virtual machines and Azure SQL Database from a DBA perspective. First, you'll start with an overview of what the Azure platform encompasses and then dive straight into how to connect and configure your Azure environment. You'll then learn about VM networking, storage, configuration management, images and disk, monitoring, deploying workloads, and scaling. Next, you'll explore Azure SQL Database and Stretch Database, including how to configure networking and security, discuss features, migration methods, and scaling. Finally, you'll discover methods for monitoring using the Azure Portal or Management Studio. When you've finished this course, you'll have the skills and knowledge to implement a Hybrid SQL Server solution leveraging Azure. If you've been considering extending your SQL Server environment to Azure, this course is for you!

About the author
About the author

Tim is a Principal Consultant with SQLskills. He has worked with SQL server for the past 15 years, in a variety of roles including DBA, Lead DBA, and multi-department manager, which have given him extensive experience planning and implementing large-scale environment changes and upgrades.

More from the author
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello, my name is Tim Radney, and welcome to my course, SQL Server: Implementing a Hybrid Cloud Solution in Azure. I am a SQL Server consultant with SQLskills, as well as a Microsoft Data Platform MVP. As a consultant who works a lot with Azure, I've been fortunate to help numerous companies incorporate Microsoft Azure into their environment. More and more organizations are realizing that leveraging Microsoft Azure is a low cost and easy-to-implement solution for scaling their organization or building out a disaster recovery site. This course will give you a deeper understanding of what Azure Infrastructure as a Service consists of. Azure is vast, and includes just about everything an organization needs to run their operations fully in the cloud. You'll learn about the parts of Infrastructure as a Service that apply to building and scaling out hybrid SQL Server solutions, including backup to URL, managed backups, stretch database, availability groups, Azure SQL Database, and Azure virtual machines. If you've been curious how to build and scale out Azure virtual machines, this course will help to eliminate any fears or concerns on being able to do just that. You'll learn about the prerequisites for creating virtual machines, and several options of being able to scale out storage, CPU, and memory. You'll also learn about migration strategies, including several methods of getting your on-premises SQL Server instances and databases into Azure virtual machines. The course also looks at Azure SQL Database and discusses some of the top features built into the product, as well as taking a deep dive into stretch databases. Lastly, you'll learn about the various ways to monitor systems in Azure, including the various dashboards built into the Azure portal, as well as SQL Server Management Studio. I hope you'll join me as we explore extending on-premises solutions into Azure in this course, SQL Server: Implementing a Hybrid Cloud Solution in Azure, Here on Pluralsight.