Dharmendra Keshari

Dharmendra is a SQL Server/Microsoft Data Platform professional with over eight years of experience. He enjoys helping others in the SQL Server community and does this by contributing on blogs, speaking at several SQL events. His passion and focus is to explore and share more and more on SQL Server.

Blog Post

Azure Storage Account

This blog post aims to provide an overview of Azure Storage Accounts. It will explain how to create them and use them effectively. Azure Storage Account Azure Storage Account...

2023-05-19 (first published: )

453 reads

Blog Post

What Is Azure Data Factory?

What Is Azure Data Factory? Azure Data Factory (ADF) is a cloud-based PaaS data integration solution that provides a fully managed, serverless environment for ingesting, preparing, and transforming your...

2023-05-08 (first published: )

692 reads

Blog Post

Azure Resource Group

What is Azure Resource Group? Azure Resource Group is a powerful feature that enables effective organization and management of resources in the Azure cloud. A Resource Group is a...

2023-05-01

105 reads

Blogs

Time to Revive our YouTube Channel

By

It’s been forgotten about and neglected for few years but I’ve decided to dust...

Microsoft MVP 2025: Continuing the Data Platform Journey

By

I am honored to announce that I have been renewed as a Microsoft MVP...

What is KTLO? Keep The Lights On vs Project Work in Agile

By

🔍 Demystifying KTLO: A Deep Dive into Keep The Lights On Work in IT...

Read the latest Blogs

Forums

How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory

By Chandan Shukla

Comments posted to this topic are about the item How a Legacy Logic Choked...

Navigating Multi Platform Realities in My Database Life

By dbakevlar

Comments posted to this topic are about the item Navigating Multi Platform Realities in...

Import/Export SSMS Settings issue

By Brandie Tarvin

I have tried a number of times to export and then import my SSMS...

Visit the forum

Question of the Day

Query Plan Regressions --

For the Question of the day, I am going to go deep, but try to be more clear, as I feel like I didn't give enough info last time, leading folks to guess the wrong answer... :) For today's question:  You’re troubleshooting a performance issue on a critical stored procedure. You notice that a previously efficient query now performs a full table scan instead of an index seek. Upon investigating, you find that an NVARCHAR parameter is being compared to a VARCHAR column in the WHERE clause. What is the most likely cause of the query plan regression?

See possible answers