Understand contained users in SQL Server databases, how they travel with a database, and the security trade-offs of partial containment.
SQL SERVER – Shrinking NDF and MDF Files – A Safe Operation
Is shrinking NDF and MDF files safe? A reader asked if it causes data loss. It does not, but I explain why shrinking them is often not a good idea.
Connecting Excel to SQL Server Safely
Connecting Excel to SQL Server safely means a narrow read-only view, a scoped login, controlled refresh load, and no saved password in the workbook.
Securing Linked Servers
Securing linked servers requires explicit login mappings, limited RPC settings, remote privilege checks, and dependency ownership.
Always Encrypted in Plain Words
Explain Always Encrypted in plain words, including client-held keys, deterministic and randomized encryption, query limits, and operations.
SQL SERVER – sqlcmd – Using a Dedicated Administrator Connection to Kill Currently Running Query
When a long running query makes SQL Server stop responding, sqlcmd with a Dedicated Administrator Connection lets you connect from another computer and kill it.
Granting VIEW SERVER STATE Without Handing Out sysadmin
Grant VIEW SERVER STATE or SQL Server 2022 performance permissions to a monitoring login, add job history access, and test its limits.