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

Discuss

Blogs

Methodology for dealing with bad data in production

By Brian Kelley

Pinal Dave wrote up his methodology for what to do when you discover bad...

How to Provision an Azure SQL Database

By MarlonRibunal

Aside from spinning up a SQL Server instance container, the free Azure SQL Database...

Claude finds two cryptographic weaknesses (but the sky isn’t falling)

By Brian Kelley

If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...

Read the latest Blogs

Forums

Kontak BCA KCP Semanggi Telp:08218154392

By Layanan_BCA_24jam

WA CS (08218154392) Wisma GKBI, Jl. Jenderal Sudirman No.28 Suite G 01, RT.14/RW.1, Bend....

Why SQL Server Database Attach fails and how to repair it

By Nisarg Upadhyay

Comments posted to this topic are about the item Why SQL Server Database Attach...

Fixing P1 Queries

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Fixing P1 Queries

Visit the forum

Question of the Day

BIT_COUNT() IV

In SQL Server 2025, I run this code:

select bit_count('A')

What is returned?

See possible answers