LessThanDot Site Logo

LessThanDot

A decade of helpful technical content

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.

Browsing "testing"

SSIS Performance Testing

I had to do some performance testing for an upcoming MSSQLTips article and I thought I’d share the framework I used in a blog post. First of all we have to log start and end dates of the package to a table so we can easily calculate the duration a package took to finish. This […]

Read More...

Wrap inserts in a transaction for faster performance

Sometimes you have to insert a bunch of data and you can’t use BCP or another bulk load method. When you do single row inserts, SQL Server wraps these inserts inside an implicit transaction. Did you know that if you use an explicit transaction that the…

Read More...

SQL Advent 2012 Day 22: Testing your backup and failover strategy

This is day twenty-two of the SQL Advent 2012 series of blog posts. Today we are going to look at how to test your backup and failover strategy

Read More...

Writing Perl Tests with Test::More

Writing tests for code is just as important as writing the code itself. Time spent writing tests is less time spent tracking down and fixing bugs, making it a great investment. Despite knowing this it can sometimes be hard to force yourself to stop codi…

Read More...

Your testbed has to have the same volume of data as on production in order to simulate normal usage

Your testbed has to have the same volume of data as on production otherwise you are not really testing anything. This blogpost is kind of a rant after I noticed this post on Stackoverflow I do not believe there is a problem with the create trigger statement itself. The create trigger statement was successful and […]

Read More...

CHESS: An Automated Concurrency Testing Tool

CHESS is an automated tool from Microsoft Research for finding errors in multithreaded software by systematic exploration of thread schedules. It finds errors, such as data-races, deadlocks, hangs, and data-corruption induced access violations, that are extremely hard to find with current testing tools. Once CHESS locates an error, it provides a fully repeatable execution of […]

Read More...