How to test dynamic reports - part 2

There is more to say about testing dynamic reports. In part 1 , the focus was on describing how manual testing is done. But somet…

How to test dynamic reports

Reports testing is something that I did rarely in my career. I validated simple reports here and there but the work was always sh…

Dynamic WHERE clauses for SQL queries

Let's assume that the following example query is needed for getting the number or orders and the sum of order values from som…

Why are stored procedures sometimes so slow compared with plain SQL statements?

I have been doing lately lots of database testing by checking if data displayed in business intelligence reports is correct. The …

T- SQL checklist

I used this checklist recently as a T-SQL refresher. The last job where I actually worked with this language was a few years back…