Blog

• Recovery Point Objective & Recovery Time Objective Demystified

  

  2014-12-23 - Backup, Disaster Recovery, General, High Availability

  Does you Disaster Recovery Strategy meet your business needs? Learn how to set your Recovery Point Objective and Recovery Time Objective!

  [more…]

• Five Steps to create an Effective Business Continuity Plan

  

  2014-12-11 - Backup, Disaster Recovery, General, High Availability

  Disaster can strike at any time. Are you ready? Can your business survive the impact of a disaster? Discover the simple five steps to get a Business Continuity Plan for your business in place today.

  [more…]

• Fragile Tests – A Ticking Time Bomb

  

  2014-11-26 - Fragile Tests, General, Series, TDD

  Fragile tests can rob you of the benefits of unit testing by undermining the developer’s trust in the tests. Read on and discover what makes fragile tests so destructive.

  [more…]

• How to Script Database Permissions

  

  2014-10-07 - DMVs & CVs, General, Security, Security

  Scripting all permissions in a SQL Server database is not trivial. Discover how to generate the necessary statements yourself with this simple query. (Well, copy & paste of the query is simple…)

  [more…]

• Common Database Vulnerabilities: Defects

  

  2014-10-02 - Common Database Vulnerabilities, General, Security, Series, TDD, tSQLt

  Defects are a nuisance. However, they often lead to bigger problems. You might find your code corruption data by updating the wrong records or opening up gaping security holes allowing users to see other users’ data. Find out how to protect yourself from this danger.

  [more…]

• Common Database Vulnerabilities: Data Inference

  

  2014-09-30 - Common Database Vulnerabilities, General, Security, Series

  Data inference allows attackers to infer protected information from legitimately accessible data. Read on to find out what data inference entails and how you can protect your data.

  [more…]

• Common Database Vulnerabilities: Weak Audit Trail

  

  2014-09-25 - Audit, Common Database Vulnerabilities, General, Security, Series

  A weak audit trail makes a post-breach-investigation hard. Discover how an effective strategy can act as a deterrent and might be a regulatory requirement.

  [more…]

• Common Database Vulnerabilities: Flawed Key Management

  

  2014-09-23 - Common Database Vulnerabilities, Cryptography, General, HIPAA, PCI DSS, Security, Series

  Encrypting important data is not enough. You also need to handle the encryption keys correctly. Read on to see what flawed key management can result in.

  [more…]

• T-SQL Tuesday #58 – Round-Up

  

  2014-09-16 - General, Passwords, Security, T-SQL Tuesday

  Last week was the 58th #tsql2sday party and 11 people showed up. There were exciting discussions about password strength, password management, hashing and more. Read on to see what everyone contributed.

  [more…]

• Five Ways to Manage your SQL Server Passwords [T-SQL Tuesday #58 – Passwords]

  

  2014-09-09 - General, Passwords, Security, T-SQL Tuesday

  Do you have a large number of SQL Server to manage? Read on to discover five ways to manage all your SA passwords and their unique advantages and disadvantages.

  [more…]