Skip to content

Tomas Lind

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

Permissions

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
Changing the database owner
Posted in
  • Configuration
  • Permissions
  • System Stored Procedures

Changing the database owner

When a database is created, the logged in user is set as the database owner as … Changing the database ownerRead more

by Tomas Lind•2014/01/232014/01/23•1

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

  • How to align columns in Notepad++
  • Export data from Excel to SQL Server
  • Calculating Earned Premium in SQL Server
  • From SQL Server to MSMQ using PowerShell
  • Line numbers in t-sql error messages

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