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,901 reads

Discuss

Blogs

Take Time to Gain Perspective

By Brian Kelley

Probably the best piece of advice I ever received is to take time to...

The Fringe Festival

I was lucky enough to take a vacation a decade ago in Edinburgh with...

Demo for Parameter Sniffing and Memory Grant Feedback

By MarlonRibunal

Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...

Read the latest Blogs

Forums

Learn From History

By Grant Fritchey

Comments posted to this topic are about the item Learn From History

The SQL Server MCP Server

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The SQL Server MCP Server

The Hidden Danger of Wildcard Operators In Join Operations

Comments posted to this topic are about the item The Hidden Danger of Wildcard...

Visit the forum

Question of the Day

The SQL Server MCP Server

How do I get an MCP server for my SQL Server 2025 database from Microsoft?

See possible answers