Category Archives: Testing

Sorting behavior

One of the best parts of my job is explaining database concepts to non-database folks: developers, managers, CEOs, my wife, etc. One lesson I’ve had to explain numerous times is that SQL Server doesn’t guarantee that data will come back … Continue reading

Posted in Business, DBA, Frustrating errors, SQL, SQL Server Internals, Testing | Tagged , , , | Leave a comment

Generating Random Data for Testing

Recently I was faced with the need to generate lots of data for a presentation. There is a temptation in situations like this to grab some data from a production system and obfuscate it somehow. My advice to you is … Continue reading

Posted in Testing | Tagged , , , , , , , | 6 Comments