Select Page

Where Can You Run SQL Server?

Andy McDermid | | December 26, 2014

Location Options for Running SQL ServerIf you want to run SQL Server, you’re no longer limited to having it operate from a box in a closet. You have a lot of choices, some of which we cover below.

Virtual Machines

Virtual machines, which are software abstractions of a hardware server, can be used to run SQL Server. In the InformationWeek 2014 State of Database Technology survey, this was the preferred running environment.

In reviewing the survey findings, Don Boxley Jr., a co-founder of the technology start-up DH2i Company, stated:

Given the widespread adoption of VMs in the datacenter, that doesn’t seem too surprising. Plain old bare metal is still holding its own, though, with over 50% of the respondents still using it. What is surprising to me is the lack of traction of the public cloud as a deployment platform. While over 28% of those surveyed are using the cloud, the bulk of the activity is centered on private and hybrid cloud deployments. Public cloud deployments represent only 5%.

Private and Hybrid Cloud

Private and hybrid cloud computing environments allow users to manage some resources in-house and others externally. These are proving to be popular options, because they allow database administrators to control data, create an optimized deployment designed to precisely meet their needs, and scale data solutions as needed.

Public Cloud

There are two ways in which the public cloud can be used to run SQL Server.

Public Cloud Infrastructure-as-a-Service (IaaS) allows a company to outsource the equipment used to run SQL server. Hardware (and therefore storage) is off-site, and connected to through a virtual machine or cloud interface.

Public Cloud Platform-as-a-Service (PaaS) allows customers to rent virtualized servers and services for running existing applications or developing and testing new ones

Platform as a Service

Platform as a Service (PaaS) is a way to rent everything you need to run SQL server—hardware, operating systems, storage, and network capacity—over the Internet. The customer rents virtualized servers and associated services to run existing applications or develop new ones.

Microsoft advocates for Platform as a Service use because, being web-based, it is widely available and broadly deployable. Companies can access hardware, operating systems, and other applications in the cloud. It also allows users to create multi-tenant applications. It’s already popular in the public sector. Microsoft says several North American public agencies—The City of Edmonton, the U.S. Department of Defense, the U.S. Office of Naval Research—and various local government agencies in India use Platform as a Service.

Microsoft has numerous offerings for Platform as a Service, including Windows Azure, Microsoft SQL Azure Database, AppFabric, Bing Maps for Enterprise, and Microsoft .NET. This last is targeted at developers wanting to write cloud-based applications.

Database as a Service

Forbes calls Database as a Service (DBaaS) “arguably the next big thing in IT,” with annual revenues from DBaaS providers increasing from $150 million in 2012 to $1.8 billion by 2016. The article explains:

The reason is simple. DBaaS is gaining converts because it enables businesses to deploy new databases quickly, securely, and cheaply. DBaaS lets you shift your organization from administering a complex collection of silos—each requiring their own care, feeding, and patching—to a business powered by an agile and flexible database cloud.

Its other merits are support for rapid provisioning and ability to enhance security.

Rates of Adoption

According to a January 2014 Information Week survey of 965 IT professionals, in which multiple responses were permitted, SQL Server is run on:

  • Bare Metal in private data center – 51 percent.
  • Virtualized in private data center – 63 percent.
  • Private Cloud – 14 percent.
  • Hybrid Cloud – 9 percent.
  • Public Cloud Infrastructure-as-a-Service (IaaS) – 3 percent.
  • Public Cloud Platform-as-a-Service (PaaS) – 2 percent.
  • Hosted (DBaaS) – 6 percent.

And, in the future, these same respondents said they intend to run SQL Server on:

  • Bare Metal in private data center – 37 percent.
  • Virtualized in private data center – 67 percent.
  • Private Cloud – 25 percent.
  • Hybrid Cloud – 17 percent.
  • Public Cloud Infrastructure-as-a-Service (IaaS) – 5 percent.
  • Public Cloud Platform-as-a-Service (PaaS) – 3 percent.
  • Hosted (DBaaS) – 6 percent

Some companies are using SQL Server on more than one platform, which is supported by the survey results.

For a more comprehensive discussion of related SQL Server issues that can help you more fully leverage the time and resources invested in your SQL Server, please download our white paper on the Top SQL Server Issues written by Andy McDermid, Datavail’s SQL Server principal database administrator.

Contact Datavail for more information on how we might best support you and your organization with custom solutions tailored to your specific SQL Server needs.

Image: everythingpossible/123RF

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

Scripting Out the Logins, Server Role Assignments, and Server Permissions

Imagine there are over one hundred logins in the source server and you need to migrate them all over to the destination server. Wouldn’t it be awesome if we could automate the process by generating the scripts for the required tasks?

JP Chen | October 1, 2015

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS