Year: 2016

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

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

ScriptOut Change Tracking Tables

ScriptOut Change Tracking Tables SELECT AS Schema_name , AS Table_name , ‘ALTER TABLE ‘ + QUOTENAME( + ‘.’ + QUOTENAME( + ‘ ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON) ‘ + CHAR(13) AS SQLScript FROM sys.change_tracking_tables JOIN sys.tables ON

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

Database Development Standards

Database Development StandardsThe 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

Petition to Support H.R.213

Petition to Support H.R.213 – Fairness for High-Skilled Immigrants Act of 2015From : Raju Venkataraman 22202 Estate Hill Drive San Antonio TX- 78258To : Congressman San Antonio, TX 78258My Experiences as H1B Visa Worker from IndiaI am Raju Venkataraman, 38 years

AWS SLA Summary

AWS SLA Summary SLA Percentages Useful Links Cloud Provider Service Availability  

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

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

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

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)!

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.

Dynamic SQL Search Stored Procedure

Dynamic SQL Search Stored Procedure
This also includes how to safeguard against SQL Injection by escaping single quotes through SQL function.

Caching SQL Server Tables After Restart

SQL Server Cached Pages and ways to bring data pages to memory
We noticed considerable latency in stored procedure execution after restarting SQL Server Instance which was triggered by accessing data from disks instead of memory. So we ended up writing a simple script to bring data pages to memory. This helped us to avoid first touch penalty after restart in production environment.

Dynamically Restore SQL Server Database from Backup

Dynamically Restore SQL Server Database from Backup We always get requests to restore databases from production to lab environment.This script dynamically restores the backup file and moves the data and log files to default locations. /****************************************************************************************************** ** Project: Operations **

Launching AWS SQL Server RDS

Learning from Launching AWS SQL Server RDS
We are evaluating options to migrate our read/write heavy production SQL Server database to amazon SQL Server RDS. We have pretty high throughput needs for few hours a day for few months in a year ,which is mission critical for our business success. We are evaluating pros and cons of moving to amazon RDS with provisioned IOPS. Current hosted provider doesn’t offer on-demand scaling solution .

Change SQL Server Authentication login password

We have numerous applications using SQL Login accounts . Simple powershell scripts saves time for rotating passwords for SQL Logins.

SQL Server Recursion / CTE

Simple Employee data hierarchy to illustrate recursion through traditional while loop as well as Common Table Expressions. ( CTE )

AWS RDS vs Azure vs Managed Services for SQL Server

We are evaluating pros and cons of different hosting solutions for SQL Server which best suits our business needs.
Our plan is to evaluate AWS SQL Server RDS, Azure RDS , Managed solutions from hosting provider.
Evaluate each option in these categories.
1. Performance and Reliability
2. Ability to scale up during peak loads
3. Cost ( Based on Network , Storage, Memory and CPU )
4. Operations Efficiency
5. Compliance

SQL Server – Set Max Memory

SQL Server – Set Max Memory MSDN Link on Changing Max Memory /* (4 row(s) affected) Msg 15123, Level 16, State 1, Procedure sp_configure, Line 62 [Batch Start Line 0] The configuration option ‘max server memory’ does not exist, or