Mehedi's Earth

In first part of this series, we learnt briefly about First Responder Kit, its installation process and all of its stored procedures. In this part we will explore the stored procedures of First Responder Kit, sp_Blitz. [More]

Monitoring SQL Server is a critical aspect of database management, ensuring high performance, security, and availability. Though SQL Server has some built-in tools and commands, but you will not get any consolidate view or resolution from them. This article series explores a tool that can help you to monitor the performance and gain actionable insights of your SQL Server environment without putting extra load on your bank account. [More]

Join my Free Database Session arranged by Megaminds Learning.

  [More]

Are you juggling with large dataset and query performance management? Partitioning technique can unlock a new dimension for you. Let's explore the concepts deeply. [More]

In a casual conversation with team, one of my junior team members asked, "If I execute the same query changing the parameter, will the execution plan change?" I thought for some moments and explained him. [More]

tempdb is the unsung hero of SQL Server, silently powering temporary tables, internal operations, and session-specific tasks. Understanding how it works and how to optimize it is crucial for maintaining performance and avoiding bottlenecks in your SQL Server environment. [More]

Today, I am going to share how can you boost your database performance to new heights with SQL Server memory-optimized tables! Designed for speed and efficiency, these tables redefine data processing by keeping critical data in memory for blazing-fast results. [More]

Hi everyone, I will share a recent experience. How my team resolved sudden CPU spike! [More]

Do you know SQL Server keeps an inventory of your SQL queries, where you could track performance, pinpoint bottlenecks, and instantly access the history of every executed query. Even you could force a regressed query to use its previous plan! That is the power of SQL Query Store. The built-in performance tuning tool that provides deep insights into query performance over time. In this article, you will see how Query Store can be used to troubleshoot and optimize your query performance. [More]

Recently, some indexes of my production server were fragmented frequently. In this article, I am going to tell you how did I sort out the issue. [More]