What happens when you type a domain name in your browser? We all know that computers understand only IP addresses and not domain names, so how are domain names mapped to IP addresses? Most people would know that there is a process of DNS resolution involved which converts a domain…

Have you ever encountered a situation where you want to check if someone (or maybe you) modified a stored procedure or not? Or maybe you want to see a list of all the most recently modified stored procedures. How do you do this? Well, you can have this data without…

If you actively monitor your security hub score, chances are that you know about how tricky things can get. Recently a new check for encrypting SNS topics at rest was added to security hub. As a result, I faced some strange issues. I followed these steps to resolve the broken…

In this post, I’ll be referring to MS SQL Server as SQL Server A lot of times the SQL Server uses a lot of resources causing strange CPU spikes. Though these are meant to be there so that SQL server can provide more optimized performance, they can be a bottleneck…

Many times we have a requirement where we want databases on two different servers to have same data, procs, etc. For example, we want that the data in our stage environment should be same as our dev environment so that we can work on that data without much worry for…

Anyone who has ever had to work with an antivirus will agree to the fact that they eat up a lot of resources (read that as CPU) Same is the case with ClamAV But we can however increase the size of our boxes (EC2 instances in case of AWS) to…

Almost all of us use separate environments for separate needs like dev, UAT, production, etc. And we most probably have separate regions for separate environments to isolate them completely. But many a times we need to have production data on our lower environments to test some functionality or see the…

Recently I set up a cloudwatch alarm to receive notifications via mail and on a slack channel. But even after 3 days there were no alarms triggered. This could mean one of the following things Either the application is performing exceptionally great — because the alarm was supposed to be…

Deploying on cloud is very very different as compared to traditional IT infrastructures. In cloud, your deployments no longer remain hardware devices, but rather become programmable services. This provides you with a lot of flexibility and fault tolerance. …