Blog Category
Viewing blog posts in a specific category.
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.