As I jump back into some SQL Server development, I've come across a couple things that I wish were features in SQL Server. One is that when developing many stored procedures or functions, it has always been a pet peeve of mine that SQL Server basically lists every one together. This is a bit cumbersome as if you are developing functions for a specific purpose, you are unable to group them together (except by schema, which is not what I'm looking for) so that it is easier to find them later. A simple...
I'm in the process of figuring out how to migrate an old VBA based Excel Add-in to VSTO .net Quite unfortunately, UDF function support in Excel is critical for the add-in I'm updating and yet it is not supported in the present version of VSTO nor will it ever be with Excel 2003. Thus, I'm stuck figuring out a means around the issue. After a great deal of digging, I found a means to create VBA code from within .net and add it when the runtime loads. A great summary of how to do this is available here:...