Skip to main content

About Me

 

Assalamualaikum (peace be upon you).

I am delighted to be part of the core team to design and develop project architecture for Asa Microfinance Management System, which happens to be one of the largest microfinance companies in the world.

I am proud to design relational big data architecture for ASA's 3000+ branches' transactional system with terabytes of database size which is designed to handle at least 15 million transactions a day. Troubleshooting and performance tuning of SQL server with Availability Group for various bottlenecks is not only the part I am good at, but it also happens to be my passion.

I feel like the person responsible for making the SQL server go faster.

Feel free to contact me for your SQL Server Pain Relief, Let me help you find the root cause of your problem! 

I am available to look into your SQL Server bottlenecks. If your SQL Server issue is interesting, I am here to do it free of cost. Just hit the contact me form to get in touch with me.

Comments

Post a Comment

Most Loved Posts

SQL Data Tools - Compare Data

Compare Data between two tables SQL Server Database with the same schema architecture can differ in different environments like Dev, Staging, and Production, especially in configuration tables. Let's see how we can easily sync the data in two different tables.
1 comment
Read more

How to deal with Slow SQL Server due to Autogrowth issue

  Why you should not stick to SQL Server’s default Initial file size and autogrowth We hear a lot of these statements : My SQL Server is running slow My Production DB was fine when we started, But it is staggeringly slow now My Business end users are frustrated to wait too long Well, there are lots of reasons why your SQL Server might be slow. Setting the Autogrowth option to default is definitely one of the vital ones which we seem to ignore most of the time. Slow SQL Server and Tortoise SQL Server provides you with some default settings for autogrowth when you install it for the first time. These default cases are defined with increment by 8MB or by 10%. You need to change it to suit your own needs. For Small application, this default value might work but as soon as your system grows, you feel the impact of it more often. What Happens SQL Server Files needs more space SQL Server Requests the Server PC for more space The Server PC takes the request and asks the SQL request...
Post a Comment
Read more