Welcome!

@DXWorldExpo Authors: Elizabeth White, Pat Romanski, Yeshim Deniz, Zakia Bouachraoui, Carmen Gonzalez

Blog Feed Post

20 Key Scenarios with Windows Azure Infrastructure Services (IaaS): SQL Server 2012 AlwaysOn in the Cloud

Highly Available Clouds of Rainbow Colored SQL Data!“Hey Kevin.. How do I get high availability out of my SQL Server?”

Cluster.  Shared Storage.  Windows Failover Clustering supports that.

“But… I want my SQL Servers running in Windows Azure.  And I don’t have shared storage in “the cloud”.  But I still need the benefits of clustered high availability.”

Wow.. you sure want a lot.  Thankfully, I have a great solution.  SQL Server 2012 has a new high availability feature called SQL Server 2012 AlwaysOn.  With AlwaysOn configured, you can have two or more (up to 5) complete copies of a database that are maintained by each of the participating SQL Servers.  Each SQL Server could be hosting the database on it’s local storage, or at some other location (SMB 3.0 file share?  You bet!), but from the perspective of SQL Server 2012 AlwaysOn, it’s a copy of the database served up by each of the SQL Servers.  The SQL Servers in turn are nodes in a Windows Server Failover Clustering cluster.

“And, because it’s not a cluster using shared storage, I can run these SQL Servers up in Windows Azure Infrastructure Services as Virtual Machines?”

Yes!  Windows Azure is a great place to run these!  As long as you have an Active Directory domain controller available, your servers can be cluster nodes in a Windows Failover Cluster, and SQL Server 2012 AlwaysOn can be configured.

“Sounds terrific, Kevin!  How do I get started?”

You’re in luck!  There’s are two very detailed step-by-step walkthroughs on how to build an example up in Windows Azure.  One describes how to build the machines manually, and the other actually uses PowerShell and other command line scripting to configure everything.  In the end you have 4 servers:

  1. ContosoDC (Domain Controller)
  2. ContosoQuorum (Cluster Quorum Server)
  3. ContosoSQL1 (SQL Server), and
  4. ContosoSQL2 (SQL Server)

The examples also walk you through how to create the required Azure networks, the Availability Group for your machines, the configuration of the cluster, and the creating and configuration of a database that is highly available.

Here are the links:

For my own learning, I used the scripted option.  Unfortunately, some of the commands listed needed to be tweaked a little bit to work with the most recent version of the Windows Azure Powershell module, and there were several typos in the text.  But once I worked out the kinks, I was able to consistently create the machines and configure the cluster and the SQL Servers.

“Prove it!”

Okay…

Here are my servers in Windows Azure…

image

And here’s looking at my Availability Group “AG1” on one of the SQL Servers…

image

And looking in the Failover Cluster Manager I can see the clustered “AG1” service, currently being served by “CONTOSOSQL1”.

image

And I can manually move that clustered service…

image

…so that it’s failed-over and now being served by “contososql2”.

image

 

TRY IT: I’ve created and uploaded a .txt file containing my modified snippets of PowerShell used to configure my Windows Azure subscription and to create the storage, the networking and the four Virtual Machines. 
YOU CAN FIND IT HERE.
I strongly suggest that you change the file extension to .PS1, and open it with the PowerShell Integrated Scripting Environment.  Read the notes at the top, and only run the specific segments at the time they’re asked for in the tutorial.

---

For the official details about AlwaysOn Availability Groups in SQL Server, check out the main documentation page on TechNet.

John Joyner did a very good write-up on SQL Server 2012 AlwaysOn for TechRepublic.  Read his article: SQL Server 2012 AlwaysOn: High Availability database for cloud data centers

Don't forget to sign up for your free 90-day trial of Windows Azure, to start working with SQL Server 2012 AlwaysOn!

And you can find all of the articles in the complete "20 Key Scenarios with Windows Azure Infrastructure Services" series HERE.

Read the original blog entry...

More Stories By Kevin Remde

Kevin is an engaging and highly sought-after speaker and webcaster who has landed several times on Microsoft's top 10 webcast list, and has delivered many top-scoring TechNet events and webcasts. In his past outside of Microsoft, Kevin has held positions such as software engineer, information systems professional, and information systems manager. He loves sharing helpful new solutions and technologies with his IT professional peers.

A prolific blogger, Kevin shares his thoughts, ideas and tips on his “Full of I.T.” blog (http://aka.ms/FullOfIT). He also contributes to and moderates the TechNet Forum IT Manager discussion (http://aka.ms/ITManager), and presents live TechNet Events throughout the central U.S. (http://www.technetevents.com). When he's not busy learning or blogging about new technologies, Kevin enjoys digital photography and videography, and sings in a band. (Q: Midlife crisis? A: More cowbell!) He continues to challenge his TechNet Event audiences to sing Karaoke with him.

DXWorldEXPO Digital Transformation Stories
Today's workforce is trading their cubicles and corporate desktops in favor of an any-location, any-device work style. And as digital natives make up more and more of the modern workforce, the appetite for user-friendly, cloud-based services grows. The center of work is shifting to the user and to the cloud. But managing a proliferation of SaaS, web, and mobile apps running on any number of clouds and devices is unwieldy and increases security risks. PJ Hough, Citrix Executive Vice President and...
Cloud-Native thinking and Serverless Computing are now the norm in financial services, manufacturing, telco, healthcare, transportation, energy, media, entertainment, retail and other consumer industries, as well as the public sector. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is no time to wait for long development cycles that pro...
Atmosera delivers modern cloud services that maximize the advantages of cloud-based infrastructures. Offering private, hybrid, and public cloud solutions, Atmosera works closely with customers to engineer, deploy, and operate cloud architectures with advanced services that deliver strategic business outcomes. Atmosera's expertise simplifies the process of cloud transformation and our 20+ years of experience managing complex IT environments provides our customers with the confidence and trust tha...
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
Never mind that we might not know what the future holds for cryptocurrencies and how much values will fluctuate or even how the process of mining a coin could cost as much as the value of the coin itself - cryptocurrency mining is a hot industry and shows no signs of slowing down. However, energy consumption to mine cryptocurrency is one of the biggest issues facing this industry. Burning huge amounts of electricity isn't incidental to cryptocurrency, it's basically embedded in the core of "mini...
The term "digital transformation" (DX) is being used by everyone for just about any company initiative that involves technology, the web, ecommerce, software, or even customer experience. While the term has certainly turned into a buzzword with a lot of hype, the transition to a more connected, digital world is real and comes with real challenges. In his opening keynote, Four Essentials To Become DX Hero Status Now, Jonathan Hoppe, Co-Founder and CTO of Total Uptime Technologies, shared that ...
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
Every organization is facing their own Digital Transformation as they attempt to stay ahead of the competition, or worse, just keep up. Each new opportunity, whether embracing machine learning, IoT, or a cloud migration, seems to bring new development, deployment, and management models. The results are more diverse and federated computing models than any time in our history.
Data center, on-premise, public-cloud, private-cloud, multi-cloud, hybrid-cloud, IoT, AI, edge, SaaS, PaaS... it's an availability, security, performance and integration nightmare even for the best of the best IT experts. Organizations realize the tremendous benefits of everything the digital transformation has to offer. Cloud adoption rates are increasing significantly, and IT budgets are morphing to follow suit. But distributing applications and infrastructure around increases risk, introdu...
Atmosera delivers modern cloud services that maximize the advantages of cloud-based infrastructures. Offering private, hybrid, and public cloud solutions, Atmosera works closely with customers to engineer, deploy, and operate cloud architectures with advanced services that deliver strategic business outcomes. Atmosera's expertise simplifies the process of cloud transformation and our 20+ years of experience managing complex IT environments provides our customers with the confidence and trust tha...