SQL Server System Info

SQL Server System Info This script provides SQL Server instance level configurations. GitHub Gist : https://gist.github.com/I90Runner/7bc31a10897a2168816073db781d5e77 /****************************************************************************************************** ** Project: Operations ** Issue: Gather SQL Server System Information ** ShortDesc: Gather SQL Server System Information. These commands usually gets executed by SQL Server during startup ** …

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 DROP PROCEDURE sp_hexadecimal GO CREATE …

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 load balancing capacity needed to …