{"id":351,"date":"2015-08-31T06:04:00","date_gmt":"2015-08-31T06:04:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/azuregov\/2015\/08\/31\/what-type-of-sql-on-azure-is-right-for-me\/"},"modified":"2015-08-31T06:04:00","modified_gmt":"2015-08-31T06:04:00","slug":"what-type-of-sql-on-azure-is-right-for-me","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azuregov\/what-type-of-sql-on-azure-is-right-for-me\/","title":{"rendered":"What type of SQL on Azure is right for me?"},"content":{"rendered":"<p>***** NOTE: take a look at this video, while not Azure Gov specific, it goes into much more depth on this topic: <a href=\"https:\/\/channel9.msdn.com\/Series\/SAIIK-SQL-Server-on-Azure-IaaS-Implementation-Kit\/SAIIK-PaaS-vs-IaaS\">https:\/\/channel9.msdn.com\/Series\/SAIIK-SQL-Server-on-Azure-IaaS-Implementation-Kit\/SAIIK-PaaS-vs-IaaS<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>I get asked this question frequently by customers. Figured I would share my thoughts on the topic with you guys, and some links to some helpful resources.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/43\/2019\/03\/1234.What%20type%20of%20SQL%20on%20Azure%20is%20right.png\"><img decoding=\"async\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/43\/2019\/03\/1234.What%20type%20of%20SQL%20on%20Azure%20is%20right.png\" alt=\"\" width=\"500\" border=\"0\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>First thing you have to decide is\u00a0Platform as a Service (PasS) or Infrastructure as a Service (IaaS). There is a great article with all the information that you need to make this decision here:<a href=\"https:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/data-management-azure-sql-database-and-sql-server-iaas\">https:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/data-management-azure-sql-database-and-sql-server-iaas<\/a><\/p>\n<p>If you choose PasS congratulations you are done!<\/p>\n<p>If you choose IaaS you have to figure out your licensing model. Bring your own license (BYOL) or Pay as you go (PAYG). In general if you already have a purchased license that you can move then use BYOL, if you have to purchase a new license use PAYG. PAYG provides you much more flexibility to grow\/shirk your investment as your needs change, additionally it requires no pre commitment.\u00a0You can read more about the licensing here: <a href=\"http:\/\/azure.microsoft.com\/en-us\/pricing\/licensing-faq\">http:\/\/azure.microsoft.com\/en-us\/pricing\/licensing-faq<\/a>.<\/p>\n<p>Two tips here:<\/p>\n<p>1) You CAN mix and match BYOL and PAYG in your environment<\/p>\n<p>2) If you need to switch you will need to stand up a new VM and move your data over<\/p>\n<p>&nbsp;<\/p>\n<p>BONUS Tip:<\/p>\n<p>If you are using IaaS use this doc to guide you through the best way to set everything up:<\/p>\n<p><a href=\"https:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/virtual-machines-sql-server-performance-best-practices\/\">https:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/virtual-machines-sql-server-performance-best-practices\/<\/a><\/p>\n<p>Double BONUS Tip:<\/p>\n<p>If you are looking to migrate to SQL DB PasS check out this migration tool from George Huey: <a href=\"http:\/\/sqlazuremw.codeplex.com\/\">http:\/\/sqlazuremw.codeplex.com\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>***** NOTE: take a look at this video, while not Azure Gov specific, it goes into much more depth on this topic: https:\/\/channel9.msdn.com\/Series\/SAIIK-SQL-Server-on-Azure-IaaS-Implementation-Kit\/SAIIK-PaaS-vs-IaaS &nbsp; I get asked this question frequently by customers. Figured I would share my thoughts on the topic with you guys, and some links to some helpful resources. &nbsp; First thing you [&hellip;]<\/p>\n","protected":false},"author":5375,"featured_media":20423,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[524],"class_list":["post-351","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azuregov","tag-sql-azure"],"acf":[],"blog_post_summary":"<p>***** NOTE: take a look at this video, while not Azure Gov specific, it goes into much more depth on this topic: https:\/\/channel9.msdn.com\/Series\/SAIIK-SQL-Server-on-Azure-IaaS-Implementation-Kit\/SAIIK-PaaS-vs-IaaS &nbsp; I get asked this question frequently by customers. Figured I would share my thoughts on the topic with you guys, and some links to some helpful resources. &nbsp; First thing you [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/posts\/351","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/users\/5375"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/comments?post=351"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/posts\/351\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/media\/20423"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/media?parent=351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/categories?post=351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/tags?post=351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}