I was looking at tools to convert C# to VB.Net (and vice versa) when I ran into an open-source development environment for .Net called #Develop (SharpDevelop). From what I've seen so far is that it works fine with all sorts of C# projects. It doesn't support all features from Visual Studio yet. For example, it cannot handle ETP (Enterprise) projects yet. And this is something I like to use to keep large solutions tidy.
But it has a better syntax highlighting, searching your code is easier, and for all VB.Net lovers out there, you finally have XML documentation capabalities. Best of all, it can convert from VB.Net to C# and vice versa directly. Just open the code you want to convert and click. Brilliant:
“
If you're interested you can download the application (or the source code!) here.
Normally I leave blogging about SQL-Server to the real SQL_Server experts. But I had to this time. I read an article on unit testing TSQL functions and stored procedures on MSDN. The article mentions a framework which helps you perform this task.
In the light of running automated tests on C# and/or VB code using NUnit, this seems like a welcome addition to me. So all you SQL-Server guru's might want to take a look. Maybe you've already used it, maybe you have a better solution. But automatically running tests on your stored procedures and functions seems like a good idea to me :-)