Blog Category

Viewing blog posts in a specific category.

Azure Resources

Posted in Azure, Microsoft Technologies on Jul 24, 2018

Azure Resources

Stored Procedure Error Logging

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

Simple Stored Procedure for Error Logging

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 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.

How to become DBA favorite Developer

Posted in Microsoft Technologies, SQL Server on Sep 20, 2016

Best Practices to follow to make DBA Operations simpler. Practices to follow to cut down troubleshooting time.