Blog

• ORIGINAL_LOGIN() – How to identify the Original Login Name

  

  2014-01-22 - General, Security

  ORIGINAL_LOGIN() is a SQL Server function that returns the original login name that was used to make the connection to the instance. Read on to get all the details.

  [more…]

• Log Reuse Waits Explained: LOG_SCAN

  

  2014-01-21 - General, Log Reuse Wait, Series, Transaction Log

  Is your database log file growing out of bound and reporting LOG_SCAN as reason? Read on to find out what that means and what you can do about it.

  [more…]

• Log Reuse Waits Explained: DATABASE_SNAPSHOT_CREATION

  

  2014-01-20 - General, Log Reuse Wait, Series, Transaction Log

  Is your database log file growing out of bound and reporting DATABASE_SNAPSHOT_CREATION as reason? Read on to find out what that means and what you can do about it.

  [more…]

• Log Reuse Waits Explained: REPLICATION

  

  2014-01-19 - General, Log Reuse Wait, Replication, Series, Transaction Log

  Is your database log file growing out of bound and reporting REPLICATION as reason? Read on to find out what that means and what you can do about it.

  [more…]

• Log Reuse Waits Explained: DATABASE_MIRRORING

  

  2014-01-18 - General, High Availability, Log Reuse Wait, Series, Transaction Log

  Is your database log file growing out of bound and reporting DATABASE_MIRRORING as reason? Read on to find out what that means and what you can do about it.

  [more…]

• Log Reuse Waits Explained: ACTIVE_TRANSACTION

  

  2014-01-17 - General, Log Reuse Wait, Series, Transaction Log

  Is your database log file growing out of bound and reporting ACTIVE_TRANSACTION as reason? Read on to find out what that means and what you can do about it.

  [more…]

• Log Reuse Waits Explained: ACTIVE_BACKUP_OR_RESTORE

  

  2014-01-16 - Backup, General, Log Reuse Wait, Series, Transaction Log

  Is your database log file growing out of bound and reporting ACTIVE_BACKUP_OR_RESTORE as reason? Read on to find out what that means and what you can do about it.

  [more…]

• Log Reuse Waits Explained: LOG_BACKUP

  

  2014-01-15 - Backup, General, Log Reuse Wait, Series, Transaction Log

  Is your database log file growing out of bound and reporting LOG_BACKUP as reason? Read on to find out what that means and what you can do about it.

  [more…]

• 5 Reasons to Automate Your Tests [T-SQL Tuesday #50 – Automation]

  

  2014-01-14 - General, T-SQL Tuesday, TDD, tSQLt

  Discover five reasons why automated testing is so much more powerful than manual testing and how it can transform your software development.

  [more…]

• Log Reuse Waits Explained: CHECKPOINT

  

  2014-01-13 - General, Log Reuse Wait, Series, SQL Server Internals, Transaction Log

  Is your SQL Server transaction log file growing with a log reuse wait of CHECKPOINT? Read on to find out what is causing this and what you can do about it.

  [more…]