always on

Technical Article

5 (6)

You rated this post out of 5. Change rating

2022-02-22 (first published: )

7,719 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,530 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: )

14,352 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: )

5,749 reads

Blogs

Azure Networking: Designing for Change

By

Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...

Using Customer Docker Compose File Names

By

As I use containers more and more to run various things, I decided I...

SQL Server Failover Cluster Instances

By

Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve...

Read the latest Blogs

Forums

SQL Server authentication vs. Trusted connection

By Rod at work

I maintain an application written years ago, where the database is on a Windows...

Handling Engagement Rings & Wedding Band

By iBling Jewels

I’m working on a jewelry e-commerce project and need advice on designing an efficient...

The Duplicate Cursor

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Duplicate Cursor

Visit the forum

Question of the Day

The Duplicate Cursor

Can I run this code:

DECLARE ANewTable CURSOR FOR 
SELECT * FROM ANewTable

See possible answers