Did you know try/catch block in .NET 2.0 works differently than .NET 1.1 for handling non-exception throws. David Betz has written two posts on try/catch exception handling to explain this deference between both versions of framework.

In .NET 2.0, as David is explains in his post, non exception item raised are actually wrapped up with actual exception object. So that means you can easily handle those non-exception items using same try/catch blocks as they are now wrapped in RuntimeWrappedException object.

.NET 2.0 try{}catch{} and try{}catch(Exception ex){} – Part 1
try{}catch{} in .NET 2.0 – Part 2

So finally, SQL Query Analyzer has got feature which I was looking for long time. It’s SQL Prompt from Red Gate Software Ltd.

SQL Prompt provides intellisense support for Microsoft SQL Server editors. It will tell you the exact formatting you should use for your SQL commands, while you are writing them and will therefore help you write fast, perfectly formatted SQL statements. SQL Prompt improves the productivity of all SQL script creation.

You can download free version SQL Prompt from following location:
Downlod SQL Prompt

Russ Olsen has posted on five great tips of writing unit test. I am entirely agree with Russ on second tip “Silence, please”, that good unit test should respond only giving results like “will it work or not?”. Answer in straight “Yes” or “No” is more relevant to me than proving all kind of junk information from unit test. And if a unit test says “No”, I can further debug the code and find where the problem is.