Month: January 2016

SQL Server System Info

SQL Server System Info This script provides SQL Server instance level configurations. GitHub Gist : /****************************************************************************************************** ** Project: Operations ** Issue: Gather SQL Server System Information ** ShortDesc: Gather SQL Server System Information. These commands usually gets executed by

SQL Server :Transfer Logins from One Instance to Another Instance

Transfer Logins from One Instance to Another Instance — Login: sampleuser CREATE LOGIN [sampleuser] WITH PASSWORD = 0x02000F2A96350B8D3 HASHED, SID = 0xB30C7C1721D970A4WE34343A434A433A43AW43A453Q49A276CE0E, DEFAULT_DATABASE = [master], CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF USE master GO IF OBJECT_ID (‘sp_hexadecimal’) IS NOT NULL

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 : 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