Consultant Delivery Guide
Draft
Table of Contents
1Introduction
2References and additional resources
3Channel 9
4Blogs
1
1Introduction
To successfully deliver High Availability (HA), Disaster Recovery (DR) and Backup for SQL Server on Microsoft AzureVirtual Machines (VMs),a high level of knowledge and experience with HADR and backup for SQL Server on Microsoft Azure VMs is required. This document will help delivery consultantsto familiarize themselves with the various area of expertise related to HADR and backup related to. It can also be used by Engagement Managers to set expectations for the resources delivering the offering.
It includes links to training and other readiness material that is focused on the offering and will serve as a launching point to update your knowledge and skills as necessary.
This guide contains links to internal and external sources. Keep in mind that links to sources might not be up to date or even unavailable.
2References and additional resources
High Availability and Disaster Recovery
High Availability and Disaster Recovery for SQL Server in Microsoft Azure Virtual Machines
Disaster Recovery and High Availability for Microsoft Azure Applications
Microsoft Microsoft Azure Disaster Recovery Options for On-Premises SQL Server
SQL Server High Availability and Disaster Recovery on Microsoft Azure VMs (IaaS)
SQL Server 2014 AlwaysOn Availability Groups - Add Azure Replica wizard in action
Microsoft SQL Server 2012/2014 AlwaysOn HA/DR - Mission Critical Deployments and Lessons Learned
AlwaysOn
SQL Server AlwaysOn template in the Microsoft Azure Portal Gallery
AlwaysOn Availability Group in Microsoft Azure VM: Client Connectivity Scenarios
AlwaysOn Availability Groups, Listener, Named Instances, Port Numbers, etc.
AlwaysOn Availability Groups: Comparing On-Premises Deployments and Azure VM Deployments
AlwaysOn Availability Groups Troubleshooting and Monitoring Guide for SQL Server 2014
Configure SQL Server AlwaysOn Availability Group
Guide/Tutorial
Step-By-Step: Creating a SQL Server AlwaysOn Availability Group(Applies to SQL 2014 as well)
Implementing HA/DR with Microsoft SQL Server 2014 AlwaysOn Availability Groups
Tutorial: Log Shipping for Disaster Recovery in Hybrid IT
Backup
Microsoft® SQL Server® Backup to Microsoft Windows® Azure®Tool
SQL Server Backup and Restore with Microsoft Azure Blob Storage Service
SQL Server Database Backup in Azure IaaS: performance tests
Backup and Restore enhancements with Windows Azure storage in SQL Server 2014
Azure
Getting Started with SQL Server in Microsoft Azure Virtual Machines
Performance Guidance for SQL Server in Microsoft Azure Virtual Machines
Application Patterns and Development Strategies for SQL Server in Microsoft Azure Virtual Machines
Allocating Static IP Addresses to your VMs
3Channel 9
All presentations of TechEd, ALM Summit and Build conferences are available on Channel 9. Search on “hadr” or “sql server azure iaas” and you will find lots of presentations which can be watched on demand.
Some interesting ones:
General IaaS
Best Practices from Real Customers: Deploying to Microsoft Azure Infrastructure Services (IaaS)
Data Center (MDC)-B361#fbid=HXConkFs07x
Building Your Lab, Dev, and Test Scenarios in Microsoft AzureInfrastucture Services (IaaS)
Infrastructure Services on Microsoft Azure: Virtual Machines and Virtual Networks with Mark Russinovich
Microsoft Azure Internals
Getting the Most out of Microsoft Azure Storage
Network and Connectivity, Hybrid and DR
Hybrid Networking Offerings in Microsoft Azure
Achieve High Availability with Microsoft SQL Server on Microsoft Azure Virtual Machines
Designing and Building Disaster Recovery Enabled Solutions in Microsoft Azure
Specific Applications (SQL Server and SharePoint)
IaaS: Hosting a Microsoft SharePoint 2013 Farm on Microsoft Azure
Performance Tuning Microsoft SQL Server in Microsoft Azure Virtual Machines
Virtualizing & Managing SQL Server with the Microsoft Cloud OS: (01) The Cloud OS & Scalability and Performance Reports
4Blogs
SQL Server CAT (Customer Advisory Team)
AlwaysOn Availability Groups: Comparing On-Premises Deployments and Azure VM Deployments
1