Skip to content

Tomas Lind

  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software

Security

Posted in
  • Security

Dynamic Data Masking (DDM) – Mask query results

Enforcement of the new GDPR will begin in May 2018. One of the cornerstones in GDPR … Dynamic Data Masking (DDM) – Mask query resultsRead more

by Tomas Lind•2017/12/302025/06/12•1
Map users to logins
Posted in
  • Permissions
  • Security
  • System Stored Procedures

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

by Tomas Lind•2014/03/112014/02/27•0
Deny updates on a table but allow inserts
Posted in
  • Permissions
  • Security
  • Triggers

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

by Tomas Lind•2014/02/272015/12/07•0
List SQL server roles by users
Posted in
  • Dynamic Management Objects
  • Permissions
  • Security

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

by Tomas Lind•2014/02/202014/02/18•4
A replacement for syslogins
Posted in
  • Dynamic Management Objects
  • Permissions
  • Security

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

by Tomas Lind•2014/02/182015/10/26•0
Copy logins between SQL Server instances
Posted in
  • Log Shipping
  • Mirroring
  • Security

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

by Tomas Lind•2014/02/112014/02/10•27

confided data manager

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Top Posts & Pages

  • CDC Capture job
  • How to align columns in Notepad++

Recent Posts

  • Get element max value from folder with XML files
  • Dynamic Data Masking (DDM) – Mask query results
  • The T-SQL Merge statement
  • From SQL Server to MSMQ using PowerShell
  • Identity columns that are about to overflow

Archives

Categories

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Copyright © 2025 Tomas Lind.
Powered by WordPress and HybridMag.
  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software