Partner Practice Enablement Overview Module 1 Introduction to

Partner Practice Enablement - Overview Module 1 – Introduction to Microsoft Azure Module 2 – Microsoft Azure Virtual Machines Module 3 – Microsoft Azure Networking Module 4 – Microsoft Azure Active Directory Module 5 - Cloud Services and Web Sites Module 6 - SQL Server and Share. Point Module 7 - Management and Monitoring In this session students will learn how to properly deploy, manage and scale SQL Server and Share. Point Server in Microsoft Azure Infrastructure Services. SQL Database will also be introduced. Topics such as automation, capacity planning and high availability will be discussed. Audience: IT Professionals, Architects and Developers

About the Instructor CEO & Co-Founder of Opsgility, Experts in Instructor-Led Microsoft Azure Training. Prior to starting Opsgility Michael was a Principal Cloud Architect with a leading Solution Integrator and a fifteen year Microsoft veteran. While at Microsoft Michael's roles included being a Senior Program Manager on the Microsoft Azure Runtime team and a Senior Technical Evangelist for Microsoft Azure Infrastructure Services. Michael Washam Microsoft Azure Trainer http: //www. opsgility. com Twitter: @MWasham. TX michael@Opsgility. com Michael was the original developer of the Microsoft Azure Power. Shell Cmdlets and is a globally recognized speaker for conferences such as Tech. Ed and BUILD.

SQL Server and Share. Point on Microsoft Azure

Agenda SQL Server in Microsoft Azure Introducing Azure SQL Database Share. Point Server in Microsoft Azure

SQL Server and Microsoft Azure

SQL Server and Microsoft Azure Virtual Machines Supported Versions SQL Server 2014, 2012, 2008 R 2 Supported Features All SQL Server features supported SQL Server Provisioning Cloud-first using stock images, bring your own server / VHD, capture cloud images SQL Server Licensing Pay by the hour or migrate your own license via Software Assurance **

Bring your own License Create your own Image 1. Create a VM based on base Windows Server image 2. RDP into server 3. Follow instructions for creating a sysprepped image of SQL Server: http: //technet. microsoft. com/enus/library/ee 210664. aspx 4. Run Sys. Prep and Shutdown the Virtual Machine 5. Capture the VM

Full Production Environment Development and Test Environments Common Scenarios Cloud-based backup of on-premises data SQL Server Always On w/ cloudbased secondary's

Running SQL Server in a Microsoft Azure VM Storage Recommendations Verify Disk Cache Settings on Data Disks (See whitepaper link below) Avoid using OS drive for databases Put database and transaction log files on separate drives Use SQL Server File Groups instead of Disk Striping Database Recommendations Consider using database page compression to reduce I/O High Availability Recommendations Consider latency between primary and replica when choosing sync mode Use Availability Sets More at http: //go. microsoft. com/fwlink/? Link. Id=306266

More on Storage Performance Considerations Do not use the temporary disk (D: ) (including for Temp. DB) Use SQL file groups across multiple disks instead of disk striping Put logs, data and backup on separate disks Disable geo-replication on storage account for consistency Remember storage account capacity planning. 20, 000 IOPS per Storage Account – 500 IOPS per disk Consider compressing any data files when transferring in/out of Microsoft Azure. More at http: //go. microsoft. com/fwlink/? Link. Id=306266

Migrating to Microsoft Azure Right-size the VMs Cost impact – will pay compute, storage and bandwidth charges Data Import and Export service for large data sets: http: //www. windowsazure. com/en-us/documentation/articles/storage-import-export-service Supported Versions Bring your own – 2008, 2008 R 2, 2014 Platform – 2008 R 2, 2014 Licensing Considerations BYO – License Mobility via Software Assurance Platform – Included in the per hour rate Understand platform image configuration differences More at http: //msdn. microsoft. com/library/windowsazure/dn 133142. aspx

Security Considerations Similar practices as on-premises Regulatory Compliance - Microsoft Azure Trust Center http: //www. windowsazure. com/en-us/support/trust-center/ Remove unused public endpoints Consider a Point to Site or Site to Site VNET for administration Set ACL to limit IPs and/or subnets More at http: //msdn. microsoft. com/library/windowsazure/dn 133147. aspx

SQL Server Microsoft Azure Integration SQL Server 2012 Backup to Microsoft Azure blob storage (Power. Shell or T-SQL), On-premises and Microsoft Azure SQL Server 2014 Database Migration to Microsoft Azure SQL Server Always On Hybrid (On-Premises and Replica in Microsoft Azure) SQL Database files can be created directly in Microsoft Azure Storage SQL Server Backup to Microsoft Azure Storage URL or fully Managed with UI Integration

High Availability and Disaster Recovery Key Scenarios High Availability within Microsoft Azure Disaster Recovery between on-premises and Microsoft Azure Disaster Recovery across Microsoft Azure Data Regions More at http: //msdn. microsoft. com/en-us/library/windowsazure/jj 870962

HA - SQL Always On Availability Groups Up to 4 Replicas Replica Authentication Dependencies

HA - SQL Always On Availability Groups Hybrid Up to 4 Replicas Replica Authentication IP SEC Dependencies

HA - SQL Server Mirroring Replica Authentication Setup

DR - Spanning Cloud Azure Regions SQL Mirroring or Always On with a Regional Virtual Network or Express. Route Circuit

DR – SQL Backup/Restore Using Blob Storage Backup or Restore using Microsoft Azure Storage SQL can be on-premises or cloud based

DR: SQL Log Shipping SQL Shipping Uses File Share (SMB) IP SEC Requires Active Directory and VPN for offsite disaster recovery.

Introducing SQL Database Delivers Database-as-a-Service functionality, based on SQL Server and hosted in Microsoft Azure Focuses on predictable performance, scalability, business continuity, data protection, zero administration, and familiar tools

Service Tiers Predictable performance and business continuity

Predictable Performance Level • • • Measured in Database Throughput Units (DTUs) DTU = unit of measurement for power of combined CPU, memory, physical reads, and transaction log writes DTUs allow comparison of resources that power different performance levels Transaction Rate • Transactions per units of time (in benchmark testing) Predictability • Consistency of response time

Predictable Performance Service Tier Performance Level DTUs Maximum Sessions Transaction Rate Predictability Basic 5 100 3, 467/hour Good Standard S 1 15 200 283/minute Better S 2 50 500 1, 470/minute Better P 1 100 2, 000 98/second Best P 2 200 4, 000 192/second Best P 3 800 16, 000 730/second Best Premium

Predictable Business Continuity Service Tier Performance Level Basic Standard S 1 S 2 Premium Point in Time Restore Disaster Recovery From the past 7 days Database copy and Manual export From the past 14 days Database copy and Manual export From the past 35 days Active geo-replication P 1 P 2 P 3

SQL Server vs. Microsoft Azure SQL Database SQL Server (Iaa. S) Microsoft Azure SQL Database (Paa. S) Development Migrate Existing or Build New Apps Develop New Apps Management Full Control Managed Service Compatibility Full SQL Server Capabilities Based on SQL Server Technology Shared Technology Network transport (Tabular Data Stream) SQL dialect (Transact-SQL) Data access APIs (ADO. NET, ODBC, JDBC) Development tools (SQL Server Data Tools) Management tools (SQL Server Management Studio) More Information: http: //blogs. msdn. com/b/windowsazure/archive/2013/02/14/choosing-between-sqlserver-in-windows-azure-vm-amp-windows-azure-sql-database. aspx

DEMO SQL Database

Share. Point Server and Microsoft Azure

Share. Point Cloud Continuum Value Prop Full h/w control – size/scale Roll-your-own HA/DR/scale Share. Point (On-premises) • Share. Point 100% of API surface area Easy migration of existing apps Roll-your-own HA/DR/scale Share. Point (Iaa. S) • Hosted Share. Point CONTROL Office 365 (Saa. S) • Share. Point Service COST-EFFICIENCY Auto HA, Fault-Tolerance Friction-free scale Self-provisioning, mgmt. @ scale

Share. Point Support on Microsoft Azure Product Support Share. Point Server 2010 and 2013 supports the hosted virtualization solution of Microsoft, as well as required technologies, such as Microsoft SQL Server, when these products and technologies are deployed on the Microsoft Azure platform. FAST Support Do not support Microsoft FAST Search Server 2010 for Share. Point deployments on Microsoft Azure.

Share. Point 2013 Trial Farm install wizard not executed Not configured for single-server install (best for multiple servers – AD server and SQL Server) Can be upgraded to fully licensed version VM Gallery

Share. Point Architecture Tips IOPS Most Important Factor Optimize SQL Server Storage Only Share. Point is on the C: drive Scale Out Not Up Move content databases to separate SQL Servers Move search databases to separate SQL Servers Add more WFE for scaling Share. Point services Add dedicated Search Servers and SQL Server

Microsoft Azure and Share. Point Tips Deploy Using a Virtual Network Required for Active Directory Use Multiple Data Disks Spread the IOPs around (up to 16 1 TB Data Disks per VM with XLarge+ VMs) Group Virtual Machine tiers into Availability Sets Remember: Availability Sets give your VMs hardware level high availability Use HTTP or TCP Health Probes on Web Front Ends Have the load balancer help determine when your web front ends are available for additional HA. Focus on Agility and Automation Deploying and managing Share. Point in the cloud can be scripted. Remember a Stopped VM doesn’t charge you!

Share. Point 2013 Deployment Option 1 – Power. Shell Automation Scripts Power. Shell Scripts that use Remote Power. Shell for automated deployment of Active Directory, SQL Server and Share. Point 2013. Two Sample Configurations Available (uses Trial Image) Highly. Available and Single. VMs Download from Git. Hub https: //github. com/windowsazure/azure-sdk-tools-samples Option 2 – Share. Point Server Farm deployment in the Azure Preview Portal

Highly Available Template LB Web Tier WEB APP SQL AD/DC/DNS 2 x Large (4 Cores & 7 GB) AVSET SPWEB App Tier AVSET SPAPP AVSET SQLHA AVSET DCSET 2 x Large (4 Cores & 7 GB) 80 Data Tier 2 x A 6 (4 Cores & 28 GB) 1 x Small (Quorum) (1 Core & 1. 75 GB) Identity Tier 2 Small 20000 Admin Cloud Service (1 Core & 1. 75 GB) Virtual Network Microsoft Azure

Single Virtual Machines Template Web/App Tier WEB/APP 1 x Large (4 Cores & 7 GB) Identity Tier 1 Small (1 Core & 1. 75 GB) AD/DC/DNS LB Data Tier 1 x A 6 (4 Cores & 28 GB) SQL 80 20000 Admin AVET SPWEB AVSET SQL AVSET DCSET Cloud Service Virtual Network Microsoft Azure

DEMO Deploying Share. Point 2013

Summary SQL Server in Microsoft Azure Introducing Azure SQL Database Share. Point Server in Microsoft Azure

Coming Up Next. . . Management and Monitoring Microsoft Azure Virtual Machines

Thank You