Tag: permissions

SQL Server insights from 25+ years in the field

Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.

15 May 2018 · 6 min read

How to Grant Read-Only Access to Activity Monitors

Learn how to grant read-only Activity Monitor access in SQL Server using VIEW SERVER STATE, without handing over sysadmin rights.

Read article →
15 May 2018 · 6 min read

How to update all objects in a table to DBO

Fix broken SQL Server permission chains by transferring all object ownership to DBO. Covers sp_changeobjectowner, ALTER AUTHORIZATION and production gotchas.

Read article →

SQL Server insights, monthly.

Performance tips, security advisories, and industry analysis. No fluff, no spam.