{"id":6011,"date":"2012-07-11T09:38:31","date_gmt":"2012-07-11T08:38:31","guid":{"rendered":"http:\/\/www.itwriting.com\/blog\/?p=6011"},"modified":"2012-07-11T09:38:31","modified_gmt":"2012-07-11T08:38:31","slug":"microsoft-sql-azure-versus-sql-server-on-amazon-aws","status":"publish","type":"post","link":"https:\/\/www.itwriting.com\/blog\/6011-microsoft-sql-azure-versus-sql-server-on-amazon-aws.html","title":{"rendered":"Microsoft SQL Azure versus SQL Server on Amazon AWS"},"content":{"rendered":"<p>Amazon <a href=\"http:\/\/aws.amazon.com\/rds\/sqlserver\/\" target=\"_blank\">RDS for Microsoft SQL Server<\/a> offers cloud instances of SQL Server. Amazon\u2019s offering even supports \u201cLicense Mobility\u201d, Microsoft jargon that lets volume licensing customers use an existing SQL Server license for an Amazon\u2019s instance. But how does Amazon\u2019s cloud SQL Server compare with Microsoft\u2019s own offering, <a href=\"http:\/\/www.windowsazure.com\/en-us\/home\/features\/data-management\/\" target=\"_blank\">SQL Database<\/a> running on Azure?<\/p>\n<p>Peter Marriott has posted on the subject <a href=\"http:\/\/www.sqlservercentral.com\/articles\/Azure\/90731\/\" target=\"_blank\">here<\/a> (registration required). The key point: despite the obvious similarity (both are SQL Server), these two offerings are radically different. Amazon\u2019s RDS SQL is more IaaS (infrastructure as a service) than PaaS (platform as a service). You choose an edition of SQL Server and rent one or more instances. The advantage is that you get full SQL Server, just like the on-premise editions but hosted by Amazon.<\/p>\n<p>Microsoft\u2019s Azure-hosted SQL on the other hand is more abstracted. You do not rent a SQL Server instance; you rent a database. Under the covers Microsoft provides multiple redundant copies of the data, and if traffic increases, it should scale automatically, though the database size is limited to 150GB. The downside is that not all features of SQL Server are available, as I <a href=\"http:\/\/www.itwriting.com\/blog\/5993-moving-a-database-from-on-premise-to-sql-azure-some-hassle.html\" target=\"_blank\">discovered<\/a> when migrating data.<\/p>\n<p>Marriott adds that SQL Azure supports encrypted connections and has a more usable administration interface.<\/p>\n<p>A further twist: you can also install SQL Server on an Azure <a href=\"http:\/\/www.windowsazure.com\/en-us\/home\/features\/virtual-machines\/\" target=\"_blank\">Virtual Machine<\/a>, which would get you something more like the Amazon approach though I suspect the cost will work out higher.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Amazon RDS for Microsoft SQL Server offers cloud instances of SQL Server. Amazon\u2019s offering even supports \u201cLicense Mobility\u201d, Microsoft jargon that lets volume licensing customers use an existing SQL Server license for an Amazon\u2019s instance. But how does Amazon\u2019s cloud SQL Server compare with Microsoft\u2019s own offering, SQL Database running on Azure? Peter Marriott has &hellip; <a href=\"https:\/\/www.itwriting.com\/blog\/6011-microsoft-sql-azure-versus-sql-server-on-amazon-aws.html\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Microsoft SQL Azure versus SQL Server on Amazon AWS<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,19,26,80,83],"tags":[137,185,310,586,858],"class_list":["post-6011","post","type-post","status-publish","format-standard","hentry","category-amazon","category-cloud-computing","category-development","category-software-development","category-sql","tag-amazon","tag-azure","tag-database","tag-microsoft","tag-sql-server"],"_links":{"self":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/6011","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/comments?post=6011"}],"version-history":[{"count":0,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/6011\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/media?parent=6011"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/categories?post=6011"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/tags?post=6011"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}