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

How to encrypt an entire excel file using AES-128 encryption

What Is AES? AES stands for Advanced Encryption Standard. It is a symmetric block cipher that is used by the U.S. government to protect classified information. AES is used worldwide to protect classified data around the world. AES is essential in cybersecurity, electronic data protection, and computer security. Variations of AES AES is used in three block cipher versions namely AES 128, AES 192, AES 256. AES 128 uses 128-bit key length to encrypt and decrypt block messages. This is a symmetric secret key which means it uses same secret key for encrypting and decrypting message blocks. AES Encryption of Excel File Today we will AES 128 to encrypt an Excel File. The excel file looks like the following image. To encrypt this excel file, we will use C#. First, we need to create a console project. Let's name the project ExcelEncryption. First, we try to understand what we need to achieve. We need a KEY and Initialization Vector (IV) pair for AES 128 encryption. Let’s say, th
Post a Comment
Read more

SQL Insider 01 : An Anatomy of SELECT

Introduction When we write queries, we tend to think about the internals very little. In the new series of SQL Insider, I shall try to demonstrate what your SQL Server has to go through when you write a specific query, more specifically a specific operator. In the series, we shall try to cover all the important operators in SQL. Our today's SQL participant in SELECT. SELECT  With the SELECT query, we can select one, some, or all the columns of a SQL table. The typical syntax for SELECT is like this  SELECT * FROM Sales.SalesOrderDetail SELECT sod.OrderQty, sod.UnitPrice FROM Sales.SalesOrderDetail sod Please note that we will not be dealing with WHERE clause in today's episode.  Database We will be using AdventureWorks2019 Database for the demonstration Important Configuration We will be setting STATISTICS IO ON like this - SET STATISTICS IO ON; SET STATISTICS IO ON ; We will turn on Actual Execution Plan to examine the query SQL Insider Let's start with
Post a Comment
Read more