It’s become clear that the cloud has become an increasingly important option for IT organizations everywhere. While most businesses are continuing to run SQL Server as part of their on-premise infrastructure, Microsoft has added several hybrid cloud options to SQL Server 2014 that can be of real value to SQL Server customers – even those who continue to run on-premise. These hybrid cloud options don’t require you to move your SQL Server databases to the cloud. Instead, they allow you to extend to on-premise SQL Server instances to the cloud where it makes sense. A hybrid cloud enables an enterprise to have traditional on-premises compute resources, compute resources in a private cloud, and compute resources in the public cloud, simultaneously.
Microsoft SQL Server 2014 delivers significant enhancements to well-known critical capabilities such as high availability and disaster recovery and provides an integrated hybrid-cloud platform. These enhancements promise to assist the organizations in achieving their highest level of confidence to date in their data platform environments and offer new innovative solutions and business models via the cloud.
The upcoming tutorial on this topic aims to bring readers up to date on the high-availability, hybrid-cloud, and backup capabilities that are fully integrated into SQL Server 2014 and Windows Azure. In addition, this field also showcases how the cloud is rapidly changing the world of information technology and the way organizations innovate and do business, which may one day render many of the traditional approaches and methodologies used today obsolete.
Related Page: MongoDB Vs MySQL - Which Is A Better Database?
Figure 3.1 illustrates the Microsoft Cloud OS vision, which allows organizations to achieve the benefits of scale, speed, and agility while protecting existing investments. This means that organizations can rapidly build and deploy database applications and support real-time analytics across all forms of data with a consistent experience, whether on-premises, off-premises, or through hybrid-cloud solutions.
Figure 3.1: The elements of the Microsoft Cloud OS vision as they relate to the Microsoft data platform to achieve a consistent experience in on-premises, off-premises, or on hybrid-cloud solutions.
We’ll focus first on the high-availability and disaster-recovery enhancements, specifically AlwaysOn Availability Groups and AlwaysOn Failover Cluster Instances in the forthcoming sections.
The chapter then showcases hybrid-cloud solutions with Windows Azure and backup enhancements.
|SSAS||SQL Server DBA|
|Team Foundation Server||BizTalk Server Administrator|