Welcome to MSDN Blogs Sign in | Join | Help

January 2009 - Posts

The Value of a Non-clustered Index
I went away on holiday with the servers running very well. Our average CPU was hovering about 4% and the peak was close to 10%. When I came back, the average was at about 40% and the peak was in the neighborhood of 90%. I was not out of the office that Read More...
Visual Studio: Another way to Build a DB Unit Test for Negative Conditions
Yesterday I posted a way to do negative DB unit testing . Essentially you wrapped your negative case in a TRY/CATCH block in SQL. There is another way to do this that is a little bit more work but, in my opinion, a little bit more correct. In the example Read More...
Visual Studio: Example on Building a DB Unit Test for Negative Conditions
Rescently I began using VS testing facilities to create test cases. Its pretty nice, but there is one thing that bothered me when I discovered it wasn't in the UI. Here is the case: You add a new database unit test to your project. You open the designer Read More...
Visual Studio: Duplicate Resources Error While Creating Database Unit Tests
Here is a little 'feature' I hit while building some database unit tests in Visual Studio. The symptom is you get a message that says something along the lines of: The item "obj\Debug\DbTestPrj.testName.resources" was specified more than once in the "Resources" Read More...
Page view tracker