Getting a “pure” date in MS SQL (without the time)

You probably know the situation: You want to get all records grouped by day, but you stored their creation date using getdate(), so now they all contain time as well as the date.

The solution until MS SQL 2008 was not pretty, however with MS SQL 2008 we finally have a “pure” date datatype.

Read More »

Serverside paging with Ms SQL 2005 / 2008

If you’ve done any amount of website development, you know the issues with paging your data.

With MS SQL 2005 and newer there’s an easy way to do it in your SQL queries. And it even performs better to boot!

Here I’ll sum up how to write proper paging queries with superb performance.

Read More »

Accessing session in HttpHandlers

In ASP.Net HttpHandlers cannot access the session state by default, in order to enable them to do so, you need to implement an interface.

However this is rather simple, since the interface is just a “marker interface” as MSDN calls it. Here’s how to do it.

Read More »

Tuning IIS 7 for static content

Having an IIS serve static content is an excellent idea, however out-of-the-box it performs horribly for the job.
Read here how to archive a factor 20 improvement of the performance, by doing nothing but configuration.

Read More »