Author: Dale Created: Thursday, January 11, 2007
This blog will be used for the purpose of communicating news and discussing technical solutions that we feel might be of interest.

Interesting Components
By Dale on Monday, January 17, 2011
A few software components which are handy in the right situation. Javascript Currency Conversion. Online image manipulation.
Comments (0) More...

Online HTML Editors
By Dale on Monday, January 17, 2011
Some HTML editors for use on websites. TinyMCE, YUI Editor, FreeTextBox.
Comments (0) More...

By Dale on Monday, January 17, 2011
Various things I've run into building sites in ASP.NET. Enhanced Validation, Tableless FormView, sneaky binding to page variables, ASP.NET Caching GET/POST.
Comments (0) More...

WordPress on Windows
By Dale on Saturday, January 16, 2010
A couple of tips on installing WordPress on Windows.
Comments (0) More...

General IT Comments
By Dale on Wednesday, May 07, 2008
Extracting files from MSI package.
Comments (0) More...

MS SQL Server 2000/2005/2008/2012 Tips & Tricks
By Dale on Thursday, January 10, 2008
A place to keep bits and pieces of useful information relating to MS SQL Server including SQL Country Table Script.
Comments (0) More...

Development Resources
By Dale on Sunday, September 30, 2007
Resources that we've found useful.
Comments (0) More...

MS Reporting Services
By Dale on Wednesday, July 25, 2007

Query running slow in SSRS but fast in Query Analyser: One reason for this is the fact that SSRS will run as many queries in parallel as it can given the size of the connection pool. On the surface this may seem like a very good thing except if the queries are complex and access the same data in which case they start locking each other out and can take longer to execute than if run sequentially. To change this click the datasource properties beside a dataset, then click "..." next to datasource then tick 'use single transaction'. Slightly odd place for it, especially since it actually applies to all datasets in the report.

Divide by zero: I had an odd experience today when I tried to prevent a divide by zero by using the IIF statement e.g. =IIf(Term2 <> 0, Term1/Term2, 0) however it appears to try and evaluate 'Term1/Term2' even if it 'Term2 = 0' very strange - so I had to use another IIf st ...

Comments (0) More...

.NET Notes
By Dale on Wednesday, April 04, 2007
A post to keep track of interesting bits of information regarding .NET development. Latest notes on backing up SQL Server 2005 databases from .NET code and creating / managing compressed filed from .NET code.
Comments (0) More...

IIS Tips & Tricks
By Dale on Sunday, April 01, 2007
In this post I'll mention any clever things I've come across with regard to IIS.
Comments (0) More...

DotNetNuke (DNN) Tips, Tricks and Advice
By Dale on Tuesday, March 20, 2007
Over the time I've used DNN I've found out a few things the hard way and made a point to keep a note of them for future reference. Here they are...
Comments (0) More...