Skip to content

Tomas Lind

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

Configuration

SQL Server Default Trace
Posted in
  • Configuration
  • Monitoring
  • SQL Profiler

SQL Server Default Trace

The default setting in SQL Server 2005 and later is to keep a trace running all … SQL Server Default TraceRead more

by Tomas Lind•2014/11/122015/10/16•0
Send database mail from SQL Server with Gmail
Posted in
  • Configuration
  • Database Mail

Send database mail from SQL Server with Gmail

Did you know you can use Gmail to send emails from SQL Server?

by Tomas Lind•2014/10/022014/10/02•10
Default collation different from instance default
Posted in
  • Collation
  • Configuration

Default collation different from instance default

If you have databases with another default collation than the instance default, you may get something … Default collation different from instance defaultRead more

by Tomas Lind•2014/06/122015/12/07•0
T-SQL function SERVERPROPERTY
Posted in
  • Configuration
  • System Stored Procedures

T-SQL function SERVERPROPERTY

The T-SQL function SERVERPROPERTY returns a lot of properties about the current SQL Server instance. The … T-SQL function SERVERPROPERTYRead more

by Tomas Lind•2014/05/062015/12/07•0
SQL Server error log location
Posted in
  • Configuration
  • Error log

SQL Server error log location

The SQL Server service keeps its own error logs outside of SQL Server in a number … SQL Server error log locationRead more

by Tomas Lind•2014/04/172014/04/17•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
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

  • CDC Capture job
  • How to align columns in Notepad++
  • Export data from Excel to SQL Server
  • Manual failover in a SQL Server cluster

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