always on

Technical Article

5 (6)

You rated this post out of 5. Change rating

2022-02-22 (first published: )

6,807 reads

SQLServerCentral Article

Configuring Availability Groups in Ubuntu

  • Article

In this article, we will review how to configure Always On Availability Groups in Ubuntu Server using the Pacemaker cluster. The following are the high-level steps to configure Always On Availability Groups (AOAG) with an Ubuntu server. Install SQL Server on Ubuntu 16.04 Install Pacemaker agents and configure the cluster Create Always On Availability Groups Create […]

5 (2)

You rated this post out of 5. Change rating

2020-08-25

2,855 reads

SQLServerCentral Article

Configuring SQL Server Always on Azure Servers(Iaas)

  • Article

Configuration of SQL Server Always on in Azure Virtual machines differs in multiple ways comparing with the on-premise Implementations. This article will help you to have a handy note to configure always on in Azure servers from a DBA perspective.

5 (4)

You rated this post out of 5. Change rating

2020-09-04 (first published: )

12,955 reads

Technical Article

Automatically Failover (Enable or Disable) Jobs Based on HADR Role

  • Script

If you have a SQL Server with a High Availability solution (AlwaysOn Availability Groups, Database Mirroring, etc.), and you also have a bunch of jobs which you need to be run on the Primary server only. You need to be able to "failover" the jobs in case the Primary server is no longer Primary.

5 (1)

You rated this post out of 5. Change rating

2018-11-14 (first published: )

4,256 reads

External Article

Network Configuration of SQL Server Always On Availability Groups in Azure

  • Article

Implementing SQL Server Failover Clustering in Azure virtual machines differs in several aspects from its on-premises implementations. These differences reflect some of the unique characteristics of the storage and network infrastructure services in the Microsoft cloud environment. In this article, Marcin Policht looks at the networking aspects of clustered deployments of SQL Server 2016 in Azure.

2017-10-11

2,735 reads

Blogs

Creating an Empty Repo in GitHub–#SQLNewBlogger

By

I saw someone struggling with getting started with a Visual Studio project and Azure...

Product Review: DataVeil

By

If you’re looking at data masking tools, I recently was able to review the...

The Last Price Bump for the Data Community Summit

By

This week the cost of the PASS Data Community Summit jumps up to full...

Read the latest Blogs

Forums

Partition Large Tables needed

By sqlguy80

Hello Gurus, I have  a requirement and need to implement the solution quickly. SQL...

Deleting the Standby file

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Deleting the Standby file

If You Build It, Will They Use Linux?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item If You Build It, Will...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers