Deepesh Dhake

More than 10 years of experience as Database Administrator.
Experienced in high-availability and disaster-recovery architecture for SQL Server environments.
Experienced in designing and supporting mission-critical environments, including Always On, DR strategy implementation, performance optimization, log shipping and backup and recovery planning.
Experienced in Database migration from on-premises environment to azure cloud environment.

Skills: SQL, powershell

All authors

Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers

by Deepesh Dhake

SQLServerCentral

This article looks at how the parameter sniffing performance problem can be helped in SQL Server 2025 with PSPO.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2026-09-28

2,637 reads

Discuss

Why Your SQL Permissions Disappeared

by Deepesh Dhake

SQLServerCentral

SQL Server security

When you change a schema owner in SQL Server, all object-level permissions vanish instantly. There is no warning. Here's how to prevent it and fix it when it happens.