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.

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 […]

2020-10-01

1,271 reads

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)

2020-08-25

965 reads

Blogs

Using Write-Debug

By

I wrote a post about PoSh output recently, noting that in general we ought...

T-SQL Tuesday Retrospective #002: A Puzzling Situation

By

For the second T-SQL Tuesday ever — again, hosted by Adam Machanic — we...

Daily Coping 28 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Stored Proc with OPENJSON: How to determine insert or update?

By Goalie35

This is my 1st attempt at openjson & I'm trying to setup a stored...

product version result

By mtz676

SELECT SERVERPROPERTY ('ProductVersion') Output: 13.0.4001.0 What does each of those numbers mean.I need to...

Login to SQL Server cross domain AD Group user

By Papote

Our MS SQL Server is on another trusted domain (Trusted Domain T). We created...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers