String extensions – Case-insensitive Replace and Contains

The C# string library is pretty comprehensive, but there are a few methods that were left out. Luckily, in C# 3.0 extensions were introduced, which allows developers to seemingly add methods to existing classes. Remember that extensions only work inside the same namespace, so you’ll have to rename...

Non-queried multi-value parameters in SQL Server Reporting Services

As a follow-up to my previous post on Easy multi-value parameters in SQL Server Reporting Services, I wanted to point out some information on non-queried, or static multi-value parameters. For my example, I’m using a parameter named “Time” with choices “Morning”,...

More on SharePoint “User not found” error with Reporting Services

Following up my initial post on the SharePoint “User not found error with Reporting Services in integrated mode, I wanted to post another reason for the “User not found” error. If, somewhere in the site author tree, you have user accounts that no longer exist, you will encounter the...

6 little things I don’t like about Windows Server 2008 / Vista

I’ve been using Windows Server 2008 since it was released in February.  In general, Server 2008 is a huge improvement over 2003, however, there are a number of little things that annoy me, all of which are also found in Vista.  I plan to talk later about my favorite features in Server 2008, but...

T-SQL missing comma in SELECT does not generate parsing error

I ran in to this “gotcha” the other day while writing a number of views. I omitted a comma on my SELECT statement, and the parser did not return an error, but rather just results that I did not expect. The problem is that SQL Server interprets the missing comma as an implied column name. It is as...