Tests Are Hard

Cody Konior explains how testing is harder than it seems in the demos:

We should have 4 backup jobs

Definitely 4, not 3, and 5 is right out.

Unless of course someone builds a 500GB database with SQL CLR UDTs which slow down DBCC to a crawl, so you move the backups and maintenance for that database into their own jobs or steps with different flags, and possibly start staggering some stuff so it finishes on the weekend without dripping into Monday.

Then you’ve got more. But just kind of sweep them under the carpet. We have file system backup checks so that covers most of it…

These are just administrative test examples; when you have to start testing queries and procedures, it’s a whole new level of fun, as it feels like you’re building a castle on sand.

Related Posts

An Overview of Regression Testing

Ust Oldfield gives us a primer on regression testing: There are a variety of methods and techniques that can be used in the design and execution of regression tests. These are:– Retest All– Test Selection– Test Case Prioritisation Regression testing is really nice to have in place because it keeps you from looking like a […]

Read More

Generating Fake Data

Rich Benner shows us how to use the Faker library in Python to generate test data: There are far more options when using Faker. Looking at the official documentation you’ll see the list of different data types you can generate as well as options such as region specific data. Go have fun trying this, it’s a small […]

Read More

Categories

October 2016
MTWTFSS
« Sep Nov »
 12
3456789
10111213141516
17181920212223
24252627282930
31