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

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

Log in or register to rate

You rated this post out of 5. Change rating

2026-07-10

2,944 reads

Discuss

Blogs

When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?

Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....

Accessing the Data API Builder MCP Server from VS Code

I recently started playing with the MCP Server for SQL Server, which is a...

From DBA or Data Engineer to AI Engineer: A Realistic Path

By Eduardo Pivaral

If you spend your days tuning queries, managing pipelines, or keeping a production database...

Read the latest Blogs

Forums

BIT_COUNT() V

By Steve Jones - SSC Editor

Comments posted to this topic are about the item BIT_COUNT() V

How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager

By Pravalik Medi

Comments posted to this topic are about the item How We Reduced SQL Server...

An Eventual Consistency Scam

By Steve Jones - SSC Editor

Comments posted to this topic are about the item An Eventual Consistency Scam

Visit the forum

Question of the Day

BIT_COUNT() V

What does this return on SQL Server 2025?

select bit_count(null)

See possible answers