Tag: SQL Server

• 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…]

• Eight Reasons why your Transaction Log Files keep growing

  

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

  SQL Server organizes the transaction log as reusable virtual log files. However, there are eight reasons that can prevent their reuse causing the log file to grow. Find out what those reasons are and what to do about it.

  [more…]

• The Mystery of the SUSER_NAME() and SUSER_SNAME() functions

  

  2014-01-11 - Fundamentals, General, Security

  The SQL Server functions SUSER_NAME() and SUSER_SNAME() both return the current login name. So why are there two? Read on to find out what the difference is.

  [more…]