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
Learn how to get Windows Authentication working on an Ubuntu SQL Server on Linux instance.
2020-09-08
2,129 reads
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 […]
2020-08-25
965 reads
By Steve Jones
I wrote a post about PoSh output recently, noting that in general we ought...
For the second T-SQL Tuesday ever — again, hosted by Adam Machanic — we...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
This is my 1st attempt at openjson & I'm trying to setup a stored...
SELECT SERVERPROPERTY ('ProductVersion') Output: 13.0.4001.0 What does each of those numbers mean.I need to...
Our MS SQL Server is on another trusted domain (Trusted Domain T). We created...
Ask SSC