Geeks With Blogs
Denis Pitcher Denis Pitcher's Tech Blog January 2007 Entries
SQL Server Wish List
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 ......

Posted On Wednesday, January 24, 2007 2:59 PM

UDF support in Excel 2003 with VSTO .net
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: ......

Posted On Wednesday, January 3, 2007 1:28 PM

Copyright © Denis Pitcher | Powered by: