AWS Regions and Availability Zones C:\Users\Raju>AWS ec2 describe-regions C:\Users\Raju> aws ec2 describe-availability-zones EC2 Regions and US-WEST-2 Availability Zones References: http://docs.aws.amazon.com/general/latest/gr/rande.html http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using-regions-availability-zones.html#using-regions-availability-zones-describe
SQL Server Optimizations for High Concurrency
SQL Server Optimizations for High Concurrency Our business needs very robust, low latency, highly available and durable online transactional system which supports high concurrency for about four weeks in a year. It’s almost like Thanksgiving sale where you mark down very popular item (think of iPhone ) by …
Looking Back at 2016 !!
Gratitude Reflecting on year 2016, I feel so fortunate and lucky for my experiences. In professional side, there are gazillion things where we don’t have direct or complete control but that directly impacts our company performance as well as employees individual lives in profound manner and those …
Restrict S3 bucket Access to VPC
Allow access to S3 bucket only from VPC Currently I am evaluating options to lockdown permissions to my S3 Buckets as part of Security Enhancements. These are the steps I followed to lock down S3 Bucket access only to my VPC. Create VPC End Points …
ScriptOut Change Tracking Tables
ScriptOut Change Tracking Tables SELECT sys.schemas.name AS Schema_name , sys.tables.name AS Table_name , ‘ALTER TABLE ‘ + QUOTENAME(sys.schemas.name) + ‘.’ + QUOTENAME(sys.tables.name) + ‘ ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON) ‘ + CHAR(13) AS SQLScript FROM sys.change_tracking_tables JOIN sys.tables ON sys.tables.object_id = sys.change_tracking_tables.object_id JOIN sys.schemas …
Database Development Standards
Database Development Standards The purpose of Database Design and Development Standards is to provide as much consistency to development work as possible. Create an environment where sharing team resources is easier based on code consistency. Reduce design, development, support and maintenance costs. Institutionalize best practices. …
AWS SLA Summary
AWS SLA Summary SLA Percentages Useful Links Cloud Provider Service Availability https://cloudharmony.com/status
AWS RDS First Touch Penalty
AWS RDS First Touch Penalty According to AWS Documentation The first time a DB instance is started and accesses an area of disk for the first time, the process can take longer than all subsequent accesses to the same disk area. This is known as …
Remote Host Identification SSH Error
Remote Host Identification SSH Error Rajus-MBP:.ssh Raju$ ssh -i Key.pem [email protected] @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY! Someone could be eavesdropping on you right now (man-in-the-middle attack)! It is also possible that …
AWS SQL Server RDS Native Backup Restore
Steps to Restore .bak SQL Server backup file to Amazon SQL Server RDS
Step by Step Guide to backup and restore SQL Server backups on AWS RDS through S3 Buckets.