Notes

An easy way to work around regex greedyness

Let's say you want to chop down a well delimited list of parameter with a regex. Common task, let's look into it:parameter string:string ParamString = "section=13;cache=1000;template=2289353486;records=10;"Beginner common approach (or at least could have been mine): Regex ParamValueChopper = new Regex("(.*);"); foreach (Match m in ParamValueChopper.Matches(Para...

Installation of Orangium for developpers on Windows 7

Here's the basic steps to install Orangium on a fresh Windows 7 / IIS7 Install SQL Server 2008 (mixed mode) Copy Orangium files on the drive Edit webCommon.config file to set MachineName\InstanceName in the sql ConnectionString Install URL Rewrite Module for IIS7 (v 2.0) Run Aspnet_regiis.exe -i from the command prompt  

How to copy source code as colored html code, from Visual Studio 2010 to an Html editor

As the team grows, and we need to share a lot of code for different languages, we've been looking for a simple way to copy our source code straight from Visual Studio 2010 to the Html editor in Orangium. We found this plugin for Visual Studio 2008 by colincatjtleigh. To make it work with Visual Studio 2010, we simply need to edit the CopySourceAsHtml.AddIn file, and change version...

Upgrading from Helicon ISAPI Rewrite to Microsoft URL Rewrite Module for IIS7

Helicon ISAPI Rewrite has been used for years in Orangium to rewrite urls, and remove ASPX extensions. To this day, it is still the best way of rewriting urls in IIS6. It is also working fine for IIS7 / IIS7.5.  However, after getting some problems on Windows 7 SP1, we had to make the obvious move to start using the native Microsoft URL Rewrite Module for IIS7. We now support both modules....

Using a less precise date/time value accross a page load, to improve MS-SQL query performance

On a regular page load, without considering any cache system, we always have many SQL queries that implies some filtering with date-time range value : List of available pages for a specific period of time List of pages considering activation date and expiration date Banners to be displayed Date based theme (when the whole web site theme has to change on a specific date-ti...

Escaping brackets on sql queries (for tags)

The bracket character ". The solution is to add a slash escape : select * from Content where ContentHtml_tl2 like '%\[\[%' ESCAPE '\'  

Helicon ISAPI Rewrite configuration for IIS6, for urls without ASPX extension

  This is the script to set in IIS for a Orangium website configuration in IIS6, under the Helicon ISAPI Rewrite tab:   RewriteEngine on # If the requested URI does not contain a period in the final path-part RewriteCond %{REQUEST_URI} !(\.+)$ # and if it does not exist as a directory RewriteCond %{REQUEST_FILENAME} !-d # and if it does not exist as a file...

Memory usage shown in Task Manager for SQL Server 2008 is wrong.

After having spent too many hours struggling with high cpu usage for Sql Server 2008, I found out that the related memory usage is wrong. The proper way to know how much memory SQL is using, we simply have to run this query : SELECT * FROM sys.dm_os_sys_memory DOSM via stackoverflow / WilliamD