Category: Series

• DENY vs. REVOKE – Part 1 – Are they just synonyms?

  

  2014-02-08 - DENY vs. REVOKE, General, Security, Security Misconceptions, Series

  DENY and REVOKE look very similar, they might just be the same. And indeed, when looking at a single security principal and a single securable in isolation that are functionally identical. But there is more to it. Discover their similarities and differences in this five-part series.

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