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

11,373 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,095 reads

Blogs

Familiar Sights

By

Yesterday was a long day in London. I arrived late in the am, and...

Derby City Data Days

By

It was awesome to see the Kentucky data community come out for the first...

Tomorrow: Webcast on SQL Server security

By

Tomorrow, April 16, 2024, I will be giving another webcast; this one will be...

Read the latest Blogs

Forums

Difference between equal directly and use SUBSTRING

By Martass

Hello, I have a script that was running really long, and I have found...

Visualisation options as an alternative to SanKey diagram

By aaron.reese

I am building a report to show customer journeys and their arrears levels. I...

should i prefer join or left join over exists or in

By rajemessage 14195

hi, I have seen people use exists when exists is required and no cols...

Visit the forum

Question of the Day

Express In-Memory OLTP

Can I create In-Memory OLTP tables in SQL Server Express?

See possible answers