Enforcement of the new GDPR will begin in May 2018. One of the cornerstones in GDPR … Dynamic Data Masking (DDM) – Mask query resultsRead more
Security
Map users to logins
“Why can’t I login after the database restore?” As a DBA, this is one of the … Map users to loginsRead more
Deny updates on a table but allow inserts
Sometimes it is nessesary to deny updates on a table, but allow inserts. This is the … Deny updates on a table but allow insertsRead more
List SQL server roles by users
SQL Server roles can be used to give users server wide privileges. The server roles are … List SQL server roles by usersRead more
A replacement for syslogins
The system table sys.syslogins was marked as deprecated in SQL Server 2005, and is included up … A replacement for sysloginsRead more
Copy logins between SQL Server instances
If you are using SQL Server log shipping (or mirroring), you probably want to copy the … Copy logins between SQL Server instancesRead more