-
Recent Posts
Personal Links
SQL Server Links
Windows OS
Meta
Category Archives: AlwaysOn
Synchronizing Logins, Jobs, and Dependent Objects between Replicas with PowerShell
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
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 AlwaysOn, lab, testing
Comments Off on High Availability Lab: Adding dual Ethernet NIC yields big improvements