SQL Server Konferenz 2017

Azure SQL Database Vs.

Amazon RDS

MVP – Data Platform [+4 Years | Based in Brazil]

Luan Moreno M. MacielData/Cloud Architect and Lead Database Consultant

MCT – Microsoft Certified Trainer

Pythian – Lead Database Consultant

AWS Solutions Architect

Microsoft Azure & Amazon AWS – Cloud Architect

MCSE – Data Management and Analytics

Agenda

Microsoft Azure & Amazon AWS

DataCenter Environment Comparison

SQL Server Deployment Evolution

PaaS - Database Offerings in Microsoft Azure and Amazon AWS

Azure SQL Database Vs. Amazon RDS

Microsoft Azure & Amazon AWS

Microsoft.Azure Vs. Amazon.AWSNews & Cloud Updates

AWS dominates cloud computing infrastructure market, bigger than IBM/Google/Microsoft combined

https://techcrunch.com/2017/02/13/why-aws-has-such-a-big-lead-in-the-cloud/

http://www.zdnet.com/article/aws-dominates-cloud-computing-infrastructure-market-bigger-than-ibmgooglemicrosoft-combined/

https://techcrunch.com/2017/02/13/why-aws-has-such-a-big-lead-in-the-cloud/?ncid=rss&utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+Techcrunch+%28TechCrunch%29&utm_content=Google+UK

Azure rising: Microsoft will be largest Infrastructure as a Service vendor by 2019, says new Morgan Stanley survey

http://www.geekwire.com/2016/azure-rising-microsoft-will-largest-infrastructure-service-vendor-2019-says-new-morgan-stanley-survey/

Amazon AWS Launch Date = 2006

Microsoft Azure Launch Date = 2010

Amazon cloud has 1 million users and is near $10 billion in annual sales

https://arstechnica.com/information-technology/2016/04/amazon-cloud-has-1-million-users-and-is-near-10-billion-in-annual-sales/

Microsoft celebrates strong Azure adoption at Build 2016

• 120k new customers per month• 1.4 million SQL Databases in Azure• 2 trillion messages per week Azure IoT• 4 million developers registered with VSTS

https://techcrunch.com/2016/03/31/azure-growth/

Microsoft.Azure Vs. Amazon.AWSCloud Pillars Stack

Compute

Storage

Database

Content Delivery

Networking

Microsoft.Azure Vs. Amazon.AWSAWS and Azure Features Differentiation

DataCenter Environment Comparison

Amazon.AWSDataCenter’s Available

42 Availability Zones

16 Geographic Regions

5+ Availability Zones and +2 Regions in 2017/2018

https://aws.amazon.com/about-aws/global-infrastructure/

Microsoft.AzureDataCenter’s Available

Available in 140 Countries

17 Languages and 24 Currencies

https://www.microsoft.com/en-us/cloud-platform/global-datacenters

32 Geographic Regions

+6 Upcoming Regions in 2017/2018

SQL Server Deployment Evolution

IaaS On-Premises PaaS

PaaS - Database Offerings in

Microsoft Azure and Amazon AWS

PaaS – [DBaaS] – Database-as-a-Services

Self-Managed

Reduce Overall Costs *

Reduces Ongoing Administration

Do Not Manage any Virtual Machine

Relational Database Management System

Scalable On-Demand and On-Fly

Amazon.AWS & Microsoft.AzurePaaS - Database Offering

Azure SQL Database Vs. Amazon RDS

General

Recommendations for

Azure & Amazon AWS

Microsoft Azure & Amazon AWSGeneral Recommendations

CbM – Compress Before Migrate

Verify Available Regions

Amazon AWS - https://aws.amazon.com/about-aws/global-infrastructure/Microsoft Azure - https://azure.microsoft.com/en-us/regions/

Ping Test

Amazon AWS - http://www.cloudping.info/Microsoft Azure - http://www.azurespeed.com/

SQL Server Agent

Amazon AWS = Available with Limitationshttp://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.Agent.html

Microsoft Azure = Azure Automationhttps://blogs.technet.microsoft.com/uktechnet/2016/02/05/is-sql-server-agent-missing-from-azure-sql-database/

Azure SQL DatabaseFinding Appropriate Size

Performance Baseline

Recommended Service Tier – [DTU Calculator]http://dtucalculator.azurewebsites.net/https://docs.microsoft.com/en-us/azure/sql-database/sql-database-benchmark-overviewhttp://blog.tyang.org/2016/07/17/calculating-sql-database-dtu-for-azure-sql-db-using-powershell/

DTU – Database Throughput Unithttps://channel9.msdn.com/Series/Windows-Azure-Storage-SQL-Database-Tutorials/Scott-Klein-Video-02https://docs.microsoft.com/en-us/azure/sql-database/sql-database-what-is-a-dtu

Amazon RDSFinding Appropriate Size

Performance Baseline

SQL Server SE or EE - [DB Instance Class]• SE [Standard] - db.m4.4xlarge – 16 vCPU | 64 GiB RAM• EE [Enterprise] - db.m4.10xlarge – 40 vCPU | 160 GiB RAM

License Model• For SE = License Included & BYOL• For EE = Only BYOL• https://aws.amazon.com/windows/resources/licensing/• http://www.pcworld.com/article/3142340/database/every-version-of-sql-server-2016-now-gets-its-full-feature-set.html

DB Engine Version• SQL Server 2008 R2 | SQL Server 2012 | SQL Server 2014 | SQL Server 2016 • http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html

Time Zone

Storage Type• Magnetic• General Purpose (SSD)• Provisioned IOPS

Demo

Microsoft.Azure Vs. Amazon.AWSPortal Walkthrough and DBaaS Checklist [DTU Calculator]

Performing a Seamless

Migration

Azure SQL DatabaseMigration Methods

Transactional Replication

SSMS – Management Studio

BacPac + Azure Portal/PowerShell/SSMS

SSDT + BCP/SSIS

Azure Data Factory

http://www.nikoport.com/2016/09/18/migrating-to-azure-sqldatabase/

Amazon RDSMigration Methods

Amazon RDS Migration Tool [Decommissioned April/2016]https://aws.amazon.com/blogs/apn/introducing-the-amazon-rds-migration-tool/

SQL Azure Migration Wizard - [SQLAzureMW Tool]http://cloudacademy.com/blog/how-to-migrate-sql-server-database-to-amazon-rds/https://sqlazuremw.codeplex.com/ - Last Version Update – June/2015

Support for Native Backup/Restore Amazon S3 – July/2016https://aws.amazon.com/blogs/aws/amazon-rds-for-sql-server-support-for-native-backuprestore-to-amazon-s3/http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html

AWS Database Migration Service [DMS] – March/2016https://aws.amazon.com/dms/http://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.htmlhttps://aws.amazon.com/blogs/aws/aws-database-migration-service/

Implementing

Business Continuity

Plan

Azure SQL DatabaseBusiness Continuity

Active Geo-Replicationhttps://docs.microsoft.com/en-us/azure/sql-database/sql-database-geo-replication-overviewhttps://docs.microsoft.com/en-us/azure/sql-database/sql-database-business-continuity

Long-Term Backup Retention [Up To 10 Years]https://docs.microsoft.com/en-us/azure/sql-database/sql-database-long-term-retentionhttps://azure.microsoft.com/en-us/blog/azure-sql-database-now-supporting-up-to-10-years-of-backup-retention-public-preview/

Amazon RDSBusiness Continuity

Multi-AZ Deploymenthttps://aws.amazon.com/rds/details/multi-az/http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.htmlhttp://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerMultiAZ.html

Automated Backupshttp://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.htmlhttp://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.BackingUpAndRestoringAmazonRDSInstances.html

Database Snapshotshttp://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateSnapshot.html

Demo

Microsoft.Azure Vs. Amazon.AWSImplementing Business Continuity in Microsoft Azure and Amazon AWS

Azure SQL DatabaseTuning, Monitoring and Optimizing

Watchdog with Alert Rules

Performance• Overview• Recommendation• Query Performance Insight• Automatic Tuning

Dynamically Scale-Up & Down using Azure Automation

Index Maintenance Operation using Azure Automation

Amazon RDSTuning, Monitoring and Optimizing

Watchdog with CloudWatch• https://aws.amazon.com/cloudwatch/• http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Monitoring.html#USER_Monitoring• Fee Tier = 5 Minutes• Detailed = 60 Seconds

Dynamically Scale-Up & Down Based on Workload https://aws.amazon.com/blogs/database/scaling-your-amazon-rds-instance-vertically-and-horizontally/

Use SNS [Simple Notification Service] for Event Notification• http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.html

Demo

Microsoft.Azure Vs. Amazon.AWSShowing Features in Azure and AWS Portal

Thank You!Danke!

@luansql