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 …
How to become DBA favorite Developer
Application Name : When a connection is made to SQL Server there are by default no way for SQL Server to know what software is making the connection. If several apps are using a shared SQL Server and there are problems caused by a certain …
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. …
Petition to Support H.R.213
Petition to Support H.R.213 – Fairness for High-Skilled Immigrants Act of 2015 From : Raju Venkataraman 22202 Estate Hill Drive San Antonio TX- 78258 To : Congressman San Antonio, TX 78258 My Experiences as H1B Visa Worker from India I am Raju Venkataraman, 38 years old …
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 …
Useful Free Tools and Books
Useful Free Tools Download Links Wonderful Microsoft utilities PerfMon , Profiler , Dynamic Management Views and System Tables should provide lot of insights and help in diagnosing and troubleshooting issues. These free tools are nice add-ons and improves the productivity. Download SQL Server Management Studio …
AWS RDS API Reference
AWS RDS API Reference Some of the RDS API command usuage . Editable parameters list for SQL Server. AWS RDS Options Group aws rds describe-option-group-options –engine-name sqlserver-se AWS RDS SQLServer SE 12.0 Parameter Groups aws rds describe-db-parameters –db-parameter-group-name default.sqlserver-se-12.0 AWS RDS Instance Details aws rds describe-db-instances …