Rotating the TDE certificate protects recovery only when the new private key is backed up and old backups still restore.
Giving Web Developers Safe Database Access
Give web developers safe database access with narrow roles and views, a reporting replica where useful, and audit that identifies real changes.
SQL SERVER – Cryptography in SQL Server 2008
A brief look at cryptography in SQL Server 2005 and 2008: why encryption belongs at the engine level, its effect on performance, and authentication basics.
Finding Unused Logins and Users Before an Audit
Review unused logins with password metadata, database mappings and activity capture, then use an owner approved disable-first plan.
SQL SERVER – FIX : ERROR : Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.
Getting Cannot open database requested by the login for NT AUTHORITY\NETWORK SERVICE? Map that login to your database under User Mapping.
SQL SERVER – Reason for SQL Server Agent Starting Before SQL Server Engine Service
Why is SQL Server Agent starting before SQL Server Engine service? A user group member asked me, and here are my quick reasons, from jobs to OS tasks.
SQL SERVER – Forgot the Password of Username SA
Forgot the password of username SA? Resetting it is easy when another sysadmin login or a Windows admin account can get in. Here are your options.