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

It seems we can’t find what you’re looking for. Perhaps searching can help.

Blogs

KDA: Echoes of Deception - Case 6

By

A cryptic message, a book cipher hidden in art provenance records, and a trail...

Capturing My Own Metrics: #SQLNewBlogger

By

A customer was trying to compare two tables and capture a state as a...

Red Flags in Your Query (T-SQL Tuesday #200)

By

When I'm looking at a query, I bet it's bad if I see... a...

Read the latest Blogs

Forums

Why Your SQL Permissions Disappeared

By deepeshdhake

Comments posted to this topic are about the item Why Your SQL Permissions Disappeared

Alamat Kantor BCA KCU DAAN MOGOT Telp:08218154398

By Layanan Bank BCA

Tlp/Wa_Cs:0821-8154-398 Jl. Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat,...

A Quick Second Opinion

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Quick Second Opinion

Visit the forum

Question of the Day

BIT_COUNT II

In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data: 

UserID  UserPermissions
15
23
37
4       NULL
What is returned when I run this code: 
select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 4;

See possible answers