I came across a post a few weeks ago which was attempting to explain how todo a case insensitive query on data. Of course the solution works, well kind of it also fails really badly if you attempt to scale the size of the data.

The problem being is that when you change the collation on the data type sql server can no longer perform an index seek instead an index scan would be performed. This happens because the data stored in the index is case sensitive and a case insensitive operation is being attempted.

More...

Here is a quick set of functions that will allow you to reboot / shutdown / logoff windows from c#

I was flicking though some things on another asp.net / c# and stumbled across the following post. It is aimed at providing a solution in VB.NET to reboot a computer. However I think its a pretty poor attempt at solving the problem so I have been digging though my code base and found the following solution.

More...