Jignesh Raiyani

Having good experience in Database Solutions and Architecture. Working with multiple customers on Database Design & Architecture, SQL Development, Administration, Query Optimization, Performance Tuning, HA, and Disaster Recovery.

SQLServerCentral Article

Configure Replication Between an On-premises SQL Server and AWS RDS

In this article, we will review how to migrate the data from on-premises SQL Server to AWS RDS for SQL Server using transactional replication. There are several ways to migrate data from on-premises SQL Server to AWS RDS for SQL Server and transactional replication is one among them. Configuring transactional replication between the on-premises SQL Server […]

You rated this post out of 5. Change rating

2020-10-01

12,175 reads

SQLServerCentral Article

Configuring Availability Groups in Ubuntu

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,440 reads

Blogs

Migrating from Azure PG Single Server to Flex with Azure VM and pg_dump/restore

By

This is more complicated than using the Azure Migration method, but because it’s maxed...

PowerShell (and T-SQL) and Elastic Jobs

By

I’ve covered how to create Elastic Jobs in the portal (this one is important...

A New Word: Redesis

By

redesis – n. a feeling of queasiness while offering someone advice, knowing they might...

Read the latest Blogs

Forums

Extended Event Comfort

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Extended Event Comfort

SQL Database Project in Azure Data Studio

By Daniel Calbimonte

Comments posted to this topic are about the item SQL Database Project in Azure...

AG Rules for Databases

By Steve Jones - SSC Editor

Comments posted to this topic are about the item AG Rules for Databases

Visit the forum

Question of the Day

AG Rules for Databases

Which of these is not a requirement for a database to be added to an Availability Group (AG)?

See possible answers