SQL Server in the Public Cloud: SQL Database vs. SQL Server on Azure VMs
When it comes to hosting SQL Server in the public cloud, there are two major options.
- SQL Database
- SQL Server on Azure Virtual Machines (VMs)
Customers can choose just one or both, as each is designed for different SQL workloads and fit into Microsoft’s platform a different way.
In order to choose the right route for your application workload, you’ll want to match your business requirements with the benefits and capabilities of these two options. But first, know that if you choose a cloud path, you don’t have to be all in the cloud. Same goes for an on-premises direction. A hybrid cloud option, which means having part of your data centers in the cloud while keeping a select workloads on-premises, is what most businesses choose and what Microsoft’s cloud platform is built for.
The diagram below, courtesy of Microsoft Azure, shows the relation of cloud options to the level of administration you have over the infrastructure and the degree of cost efficiency:
The public cloud options (represented in blue) are outlined below, starting with…
Microsoft Azure SQL Database
SQL Database is hosted, and maintained by Microsoft. This Azure cloud platform is categorized as Software-as-a-Service (SaaS) or Platform as a Service (PaaS) and offers a few desirable features to help companies scale efficiently. First of which is cost flexibility. Users pay as they go, scaling up or down for more power and little interruption. You can also develop directly on the service using Azure's built-in features and functionality.
#1 Benefit: Lowered Overall Cost and Administration
In addition to lowering the overall cost of running multiple databases, SQL Database reduces ongoing administration costs because you don’t need a full IT team to manage any virtual machines, operating systems, or database software.
How to Purchase
SQL Database is sold as a service, not with a license. In order to limit your cost exposure, clients will need to manage and monitor what is in use along with what can be scaled back to reduce subscription fees.
With SQL Database, you can continue to administer your database, but Microsoft takes care of the underlying hardware, can replicate data to provide high availability, configures and upgrades the database software, manages load balancing, and does transparent failover if there is a server failure. Ultimately, taking away the time-consuming administration duties.
SQL Server on Azure VMs
SQL Server on Azure VMs allows you to run SQL Server inside a virtual machine in the cloud. This falls under the Infrastructure as a Service (IaaS) category and is meant to extend on premise SQL Server applications to the cloud.
#1 Benefit: Customizability
If you already have a full-time IT staff and need administrative rights, yet desire a fully customizable setup, SQL Server on Azure VMs is optimized exactly for your scenario.
How to Purchase
Traditional SQL Server licensing is available for SQL Server on Azure VMs. Customers with current software assurance have the ability to run use that license to cover their instances of SQL within Azure. If there is a workload running full time, it is typically less expensive to purchase the SQL than to subscribe to it in scenario 1.
SQL Server on Azure VMs makes it possible to keep control over database location down to the location of the disk. You can upgrade on your own schedule.
When deciding what public cloud option is right for you, assess your situation first and determine which workloads fit which cloud scenarios best. Keep in mind that you may want to reuse licensing that may already be used to run the same workload on premises.
Whatever your situation, Interlink can help you determine the best fit and then take the right next steps from there. Contact Interlink.
About the author
Matt Scherocman brings more than 15 years of experience in the information technology industry to Interlink. His experience includes both the system integrator and manufacturer sides of the business. During his time at the Microsoft Corporation he was responsible for all the Large Account Reseller (LAR) relationships in the four-state Heartland Area of Michigan, Ohio, Kentucky, and Tennessee. Prior to Microsoft, Scherocman led a Cincinnati -based IT consulting company to grow 5000% and become a Microsoft Worldwide Partner of the Year. He is actively involved in the strategic vision and operation decisions of the company including finance, selling strategy and marketing. Matt holds a Bachelor of Science in Business degree from Miami University and is a Certified Expert in Microsoft licensing including speaking engagements at both Microsoft's Worldwide Partner Conference and Channel Partner Summit. He is a frequent contributor to leading industry publications.
Don’t Be Left Unprepared for Microsoft Windows Server & SQL Server End of Life Deadlines
Welcome to the Interlink Cloud Blog
By subscribing to the blog, you will be notified whenever a new blog post is created on the site.
All content provided on this blog is for informational purposes only. The owner of this blog makes no representations or warranties regarding the information from our partners or other external sources.
- April 2023 (2)
- March 2023 (7)
- February 2023 (2)
- January 2023 (4)
- December 2022 (2)
- November 2022 (3)
- October 2022 (1)
- September 2022 (3)
- August 2022 (5)
- July 2022 (2)
- June 2022 (8)
- May 2022 (2)
- April 2022 (2)
- January 2022 (4)
- November 2021 (2)
- October 2021 (5)
- September 2021 (1)
- August 2021 (4)
- July 2021 (5)
- June 2021 (2)