Skip to content

Tomas Lind

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

SQL Server

Posted in
  • T-SQL

NULL and aggregates

An aggregate in SQL Server will ignore NULL values. Check out this simple demonstration to learn … NULL and aggregatesRead more

by Tomas Lind•2014/03/182014/03/14•2
Introduction to Automate BPA Server
Posted in
  • Architecture
  • Automate BPA Server
  • SQL Agent

Introduction to Automate BPA Server

If you are using SQL Agent together with SSIS and if you have a batch job … Introduction to Automate BPA ServerRead more

by Tomas Lind•2014/03/132014/03/16•0
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
sp_cycle_errorlog
Posted in
  • Configuration
  • System Stored Procedures

sp_cycle_errorlog

Sometimes the error log files in SQL Server get too large to view and manage in … sp_cycle_errorlogRead more

by Tomas Lind•2014/03/062014/02/25•3
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
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

Posts pagination

Previous 1 … 5 6 7 … 9 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

  • Default collation different from instance default
  • CDC Cleanup job
  • Temporal Tables Introduction
  • Export data from Excel to SQL Server
  • Index selectivity

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