Viewing blog posts in a specific category.
Posted in Microsoft Technologies, SQL Server on Oct 28, 2017
Simple Stored Procedure for Error Logging
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.
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.
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.