Troubleshooting a Manually built Availability Group on AWS

I recently had a customer who had built a 2-node Availability Group & FSW in AWS. The customer chose to manually build the AG, vs. using the pre-configured AWS quickstart template. The build went as expected, however the customer could not successfully reach the listener, nor fail-over properly. I have used the quickstart template every … Continue reading Troubleshooting a Manually built Availability Group on AWS

Setting up Windows Authentication on SQL Server 2017 Linux

In this post, we're going to cover adding a standalone instance of SQL Server 2017 on Linux to an Active Directory Domain, so that we can use Windows authentication. We'll mostly be following documentation provided by Microsoft, with just a few deviations. I see this as being one of the more common use-cases for customers … Continue reading Setting up Windows Authentication on SQL Server 2017 Linux