always on

Technical Article

5 (6)

You rated this post out of 5. Change rating

2022-02-22 (first published: )

7,267 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

3,175 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: )

13,635 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,986 reads

Blogs

What to Know about Power BI Theme Colors

By

Power BI reports have a theme that specifies the default colors, fonts, and visual...

A Global Team Meeting

By

The last few years at Redgate we’ve had the entire (or most) of the...

A New Word: sayfish

By

sayfish – n. a sincere emotion that seems to wither into mush as soon...

Read the latest Blogs

Forums

should i make as many datafiles for temdb as many cpus i have

By rajemessage 14195

hi, q1 As people said if u ghave GAM conention then u can go...

Script

By ramana3327

We have about 30 databases in server A.  All of them need to migrate...

Add alarms to database when a query, stored procedure, SSIS package hangs

By Lord Slaagh

Hello SSC, I am a SQL Server developer that has some DBA skills. I...

Visit the forum

Question of the Day

The Secondary Database Name in an AG

I am setting up a SQL Server 2022 Availability Group and I am ready to restore the database on the secondary. The primary database is named Finance. However, we also use this instance for QA and already have a database named Finance. How do I configure the AG to use a different database as the secondary?

See possible answers