
Maximize the Business Impact with Quest EMPOWER
You do not want to miss out on signing up with Quest EMPOWER. I will be there […]
You do not want to miss out on signing up with Quest EMPOWER. I will be there […]
Recently during consulting engagement Comprehensive Database Performance Health Check, my client asked if I knew why they […]
Today we will see a quick video on how to swap columns in SQL Server. It is […]
I just released my 42nd course on the learning platform Pluralsight. It was fun to build this […]
For years database server’s were hosted on either on-premises or colocation data centers. It was straightforward to […]
When an application runs without any glitch in business, no one bothers. However, as soon as the […]
We have often seen that one solution often does not have multiple different scenarios in the real […]
When any business or application begins, the amount of the data is limited, and the complexity of […]
Lots of people asked me to create a video on my earlier blog post SQL SERVER – […]
What will you do if your system working perfectly fine, suddenly starts slowing down to the point […]
MySQL is one of the most popular relational database management systems (RDBMS). Applications are now becoming more […]
Today, we will see a very interesting script to list database file latency. I use this script […]
In Comprehensive Database Performance Health Check, I often discuss that indexes can reduce the performance of your […]
Recently I had the opportunity to help a client with Comprehensive Database Performance Health Check, and while […]
During Comprehensive Database Performance Health Check, I was recently asked if I have a handy script that can […]
Quest Database Training Days 2022 are Back! Join free, interactive sessions led by Brent Ozar, Pinal Dave, […]
During Comprehensive Database Performance Health Check, I was recently asked if I have a handy script that […]
This is a follow up of my earlier blog which got instant popular Split Screen for SSMS […]
I do Comprehensive Database Performance Health Check for living, I work with the SSMS most of the […]
One of my clients of Comprehensive Database Performance Health Check recently faced a very interesting situation. I […]
Question: When was Stored Procedure Last Compiled? Answer: Honestly, it is difficult to figure out when was […]
What I enjoy the most is working with different clients on Comprehensive Database Performance Health Check. Every […]
I spend my most of time in a day helping client improve their SQL Server Performance at […]
Has it ever happened to you when you are working on a large SQL Server query and […]
Activity Monitor can come handy when you are in trouble as well. In this video, we will […]
Most part of my day is spent doing Comprehensive Database Performance Health Check with different organizations. During […]
During the Comprehensive Database Performance Health Check, I often get the question about Estimated vs Actual Execution […]
Recently I got the opportunity to feature on the Podcast of amazing DeveloperWeekly by Barry Luijbregts. It […]
Who Dropped My Table? – I was recently asked this question in Comprehensive Database Performance Health Check. […]
Can a single column and single row result do an entire table scan? I recently got this […]
My primary job is that help various organizations to tune their SQL Server performance Comprehensive Database Performance […]
In this blog post, we are going to talk about how to undo human errors in SQL […]
A very interesting puzzle, where you see the data type conversion in action. I have previously blogged […]
Question: How to Insert Multiple Values into Multiple Tables in a Single Statement? Answer: One of the […]
Just another day while working with a client Comprehensive Database Performance Health Check, we figured out that […]
Query tuning and optimization is my favourite thing when I am working on a Comprehensive Database Performance […]
One of the most popular questions, I keep on receiving is that – Is it possible to […]
It is very easy to know what is the queries past and future with the help of […]
During the recent consulting engagement of Comprehensive Database Performance Health Check, I was asked by my client, […]