Use naming conventions for readable SQL Server tables, columns, keys and indexes, then find exceptions and plan safe renames with sp_rename.
SQL SERVER – Identifying Guest User using Policy Based Management
Can a policy catch a guest user left enabled in user databases? Here is a quick tutorial on identifying guest user access with Policy Based Management.
Policy Based Management Quiz: Which Mode Can Stop a Change?
This Policy Based Management Quiz asks which evaluation mode can stop a bad change before it is saved. The answer is On change: prevent. A tested T-SQL script blocks a badly named table and shows how few facets support that mode.
SQL SERVER – Mastering the Basics – Igniting Learning – A Unique Learning Experience
I had very clear idea what my goals were in the book. I believed in unique learning experience. Let us talk about it in today’s blog.
What a Junior DBA Should Learn First
Build junior DBA skills around restores, permissions, blocking, and safe investigation, with a practical learning order and useful SQL checks.
SSIS Project and Package Deployment Explained
Understand SSIS deployment models, catalog environments, parameter bindings, and the checks that keep package execution predictable after deployment.
Handling the Row That Arrives Late
Handle late arriving data with explicit event dates, inferred dimension members, replay windows, and a clear policy for correcting published history.