Archive for June, 2008

SmartPart for SharePoint

Friday, June 27th, 2008

Recently, was charged with the not so awesome task ofwriting an interface for a planning group to use to relate budget performancemeasures with a separate more detailed model that breaks the measures into coreservices. Nonetheless, sounds simple andit is. The only thing that makes thisworth bringing up is ...

SQL UDF to strip all Non Alpha-numeric Characters

Wednesday, June 25th, 2008

A few days ago, I introduced a SQL user-defined function for stripping alphabetical characters from a varchar. Today I'd like to throw a little something something out there for stripping all non alpha-numeric characters from a varchar. Now, you may be wondering when you would use something like ...

Utility for Painless Month Dropdowns in .NET

Friday, June 20th, 2008

A former co-worker of mine and good friend Jeff Sargent posted a very useful article about creating a month dropdownlist in ASP.Net using C#. Rather than copy/paste, here is an excerpt from the article and a link to the full post. I’m a fan of having a utility class in ...

ScribeFire - Firefox Add-on for Blogging

Friday, June 20th, 2008

After upgrading to FireFox 3.0 I went went ahead and installed the standard add-ons for a guy in my line of work like Web Developer toolbar and FireBug. But, could I possibly be writing a blog post about such old news? Of course not. Let me introduce you ...

SQL Server 2005 Strip Alphabetical Characters from a String

Wednesday, June 18th, 2008

For anyone who has ever had to do funky things in SQL, you’ll probably appreciate this post. However, you may have already written something similar before. Oh well, I’m bored at the moment and feel like sharing this little user-defined-function (UDF) that makes use of the PATINDEX() function ...

Starting and Stopping Windows Services with C#

Monday, June 16th, 2008

The other day I found myself needing to write a quick application to start and stop services on my desktop since I didn’t need them all running all the time. Specifically, I have a copy of the SQL Server 2008 CTP that I’m fooling around with and it is ...