I’ve been migrating unit tests to a new Visual Studio Database Professionals project. So far there’s been no problems (other than trying to find a naming standard). This problem had me scratching my head for a few minutes today. I defined a unit test for a stored procedure as: DECLARE @ItemCode varchar(32), @PriceLevel varchar(32) SELECT […]
You are browsing archives for
Month: January 2007
Tristate What!?
It might be friday and maybe its my fault for writing a quick fix in vbscript but still … how many tristates can I choose from ?
Wait Data Professionals! Don’t Test Your Database!
Michael Hunter (a.k.a The Braidy Tester) has posted another useful article posing the question: "Do you even need to test your product?" After covering [story:vstsdbpro-five-point-testing] its interesting to see some expanded ideas on why you might choose not to test an application. Some of these things are obvious. But with an over-eager developer/tester on the […]
Simon Sabin’s SSIS Raw File Reader
Ever used a Raw File destination in SSIS ? They’re FAST! Writing rows from the pipeline to disk as quickly as possible. Raw Files are useful for increasing the throughput speed of a data flow task by using them in Extract / Transform procedures. The reason they are so efficient is they stored the data […]
Its not quite old school…
I was helping my family move last weekend and came across a lot of things from when I was a child. After having a really tough 2006 and promising myself a very happy 2007, I though this bit of arts and craft really reminded me to have fun, smile, keep things simple, and not worry […]