Month: January 2016

SQL Server System Info

SQL Server System Info This script provides SQL Server instance level configurations. GitHub Gist : https://gist.github.com/I90Runner/7bc31a10897a2168816073db781d5e77

Results from the Above Query

SQL Server :Transfer Logins from One Instance to Another Instance

Transfer Logins from One Instance to Another Instance

References Microsoft KB Article : Transfer Logins SQL 2012 Transfer Logins Older Versions SQL Skills Article : https://www.sqlskills.com/blogs/jonathan/synchronize-availability-group-logins-and-jobs/

SQL Server AlwaysOn Availability Groups

SQL Server Always on Availability Related Queries: How do I switch Primary / Secondary on Switch Always on Availability Groups ( Swap Primary / Secondary ): When the automatic failover is setup , the Primary / Secondary gets swapped during

AWS Solution Architect Preparation

AWS Solution Architect  Reference Materials Load Balancing : https://aws.amazon.com/documentation/elastic-load-balancing/ Elastic Load Balancing automatically distributes incoming application traffic across multiple Amazon EC2 instances. It enables you to achieve greater levels of fault tolerance in your applications, seamlessly providing the required amount of

Top