October 19, 2005
Today I had the great pleasure of coding against Sql Server 2005 and some nice managed stored procedures. Really interesting calling a stored procedure that has VB.Net in it, just a little strange. Need to work out how to debug those assemblies after they have been deployed to the server - had to work a couple of hours to find a bug.
One early stoppage was the use of object.Dispose within a CLR procedure. That is a no-no and SQL will not let you deploy it! Thanks Bob Beauchemin for blogging about that little jewel of knowledge!
I also have to figure out how to debug background threads more effectively - with multiple threads going, and some timing issues, putting in a breakpoint just doesn't cut the mustrad. I got to get into tracing and being able to turn it on and off a needed. Why is there always so many things to learn!