Tag: SQL Server

• Test Data – Why Sharing is Not Always Caring

  

  2015-01-15 - Fragile Tests, General, Series, TDD, tSQLt

  Shared test data can lead to a particularly nasty form of fragile test. Discover why shared test data is bad and how to avoid using it in your unit tests.

  [more…]

• Testing Time – Three Ways to Avoid Fragile Tests

  

  2015-01-07 - Fragile Tests, General, Series, TDD, tSQLt

  Testing functionality dependent on the current time or date commonly leads to fragile tests. Discover three proven test patterns to avoid that trap.

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

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