Skip to content

Tomas Lind

  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software
Logging changes to sys.configurations
Posted in
  • Configuration
  • Dynamic Management Objects
  • System Stored Procedures

Logging changes to sys.configurations

Some server wide settings can have major negative impact if they are changed in your SQL … Logging changes to sys.configurationsRead more

by Tomas Lind•2014/03/042014/03/04•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
Adding a Workflow step in Automate BPA Server
Posted in
  • Automate Workflows

Adding a Workflow step in Automate BPA Server

When designing workflows in Automate BPA Server, I like to “draw the big picture” first. That … Adding a Workflow step in Automate BPA ServerRead more

by Tomas Lind•2014/02/252014/02/19•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
Tables larger than tempdb
Posted in
  • Tempdb

Tables larger than tempdb

If your database contains very large tables, querying or managing those tables may fill tempdb. When … Tables larger than tempdbRead more

by Tomas Lind•2014/02/062015/12/07•0
Tempdb max size
Posted in
  • Tempdb

Tempdb max size

There is always a limit on how large tempdb can get. Even if there are no … Tempdb max sizeRead more

by Tomas Lind•2014/02/042015/09/21•1
sp_MSforeachdb
Posted in
  • System Stored Procedures

sp_MSforeachdb

sp_MSforeachdb is an undocumented system stored procedure that lets you iterate through all databases on an … sp_MSforeachdbRead more

by Tomas Lind•2014/01/302014/01/21•1
An alternative to xp_fixeddrives
Posted in
  • Dynamic Management Objects
  • System Stored Procedures

An alternative to xp_fixeddrives

Want to know the disk space available on your database server from T-SQL? This can be … An alternative to xp_fixeddrivesRead more

by Tomas Lind•2014/01/282014/11/21•15

Posts pagination

Previous 1 … 6 7 8 … 10 Next

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

  • SQL Agent job logging with tokens
  • Export data from Excel to SQL Server
  • List SQL server roles by users
  • Manual failover in a SQL Server cluster
  • 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