Blog

Videos Watched

Posted in Miscellaneous on Oct 23, 2018

Videos Watched

Azure SQL Migration

Posted in Azure, SQL Server on Sep 12, 2018

Learnings from Azure Migration

Azure Resources

Posted in Azure, Microsoft Technologies on Jul 24, 2018

Azure Resources

Verify Connection to MySQL is Encrypted

Posted in AWS, Cloud Computing, MySQL on Jul 15, 2018

How to Verify MySQL Connections are Secure?. These steps can be followed to verify client connections to MySQL Server are using SSL and verify all the data over the wire is encrypted.

Hosting Website from Home

Posted in AWS, Cloud Computing on Apr 15, 2018

I was hosting http://h1bsalary.online site from AWS on m3.xlarge Instance. Even though its reserved instance , the cost of hosting has crossed the threshold limit of hobby project. So I have decided to host the site from Home . In this blog post, I am sharing my experiences with hosting the website from Home instead of public cloud provider.

Stored Procedure Error Logging

Posted in Microsoft Technologies, SQL Server on Oct 28, 2017

Simple Stored Procedure for Error Logging

Bulk Load Data Files in S3 Bucket into Aurora RDS

Posted in AWS, Cloud Computing on Jul 15, 2017

We typically get data feeds from our clients ( usually about ~ 5 - 20 GB) worth of data. We download these data files to our lab environment and use shell scripts to load the data into AURORA RDS . We wanted to avoid unnecessary data transfers and decided to setup data pipe line to automate the process and use S3 Buckets for file uploads from the clients.

Brute force attack on SQL Server

Posted in Microsoft Technologies, SQL Server on Jun 22, 2017

If your business needs the SQL Server to be accessible on public network, you may be very vulnerable for brute force attacks. You need to take safe-guards to protect your valuable assets which is Data.

SQL Server Trial Edition Expiration

Posted in SQL Server on Jun 11, 2017

SQL Server Trial Edition Expiration I installed SQL Server Docker Container on Linux Machine running on EC2. I took the AMI Image and launched the existing container and wanted to know when will the SQL Server license expires on Docker container. It expires after 6 Months from initial container launch date.

SQL Server Optimizations for High Concurrency

Posted in Microsoft Technologies, SQL Server on Apr 09, 2017

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 100 % . We operate on state level ( K-12 ) online assessment market where entire state takes test in spring for few weeks. To operate in this market , you need to have a robust system which can absorb such a sudden spike in transaction volumes.