Category Archives: AlwaysOn

Synchronizing Logins, Jobs, and Dependent Objects between Replicas with PowerShell

Posted on 19. June 2018 by admin

Here’s a simple PowerShell Script that I developed to synchronize logins, credentials, proxies, operators, and jobs between AlwaysOn replicas using PowerShell, dbatools, and a little bit of T-SQL.   1 2 3 4 5 6 7 8 9 10 11 … Continue reading →

Posted in AlwaysOn, Powershell | Comments Off on Synchronizing Logins, Jobs, and Dependent Objects between Replicas with PowerShell

High Availability Lab: Adding dual Ethernet NIC yields big improvements

Posted on 8. November 2017 by admin

I have a lab that includes: Two standalone SQL Server 2014 instances One standalone SQL Server 2017 instance running on Linux Thee 2016 instances that are part of an availability group A 2016 failover cluster instance with two nodes A … Continue reading →

Posted in AlwaysOn, SQL Server | Tagged , , | Comments Off on High Availability Lab: Adding dual Ethernet NIC yields big improvements