November 2010 (1)
August 2010 (1)
July 2010 (1)
June 2010 (3)
July 2009 (3)
June 2009 (1)
May 2009 (1)
February 2009 (1)
January 2009 (1)
November 2008 (3)
October 2008 (4)
September 2008 (9)
August 2008 (6)
July 2008 (3)
June 2008 (3)
January 2008 (1)
November 2007 (2)
October 2007 (6)
September 2007 (5)
August 2007 (22)
July 2007 (6)
June 2007 (1)
May 2007 (3)
April 2007 (27)
March 2007 (8)
February 2007 (6)
September 2006 (2)
August 2006 (4)
July 2006 (9)
June 2006 (17)
May 2006 (20)
April 2006 (12)
March 2006 (9)
February 2006 (4)
January 2006 (3)
December 2005 (2)
November 2005 (4)
October 2005 (5)
September 2005 (37)
August 2005 (83)
July 2005 (6)

Active Directory / LDAP (0)
ASP.Net (19)
Blackberry Development (4)
c# (34)
c++ (3)
Code Camp (1)
Excel (1)
Exchange (3)
Front Page 2003 (6)
FTP User Editor (4)
HTML / CSS / DHTML (8)
IIS (146)
IIS - Log Parser (7)
IIS / FTP (12)
IIS / Tools / Administration (42)
IIS / Tools / Authentication (6)
IIS / Tools / Compression (8)
IIS / Tools / Crash & Hang (12)
IIS / Tools / ISAPI Filters (17)
IIS / Tools / Log Files (17)
IIS / Tools / Scripts (28)
IIS / Tools / Security (9)
IIS / Tools / SSL (6)
IIS 7 (3)
Internet Information Server (1)
Me (Chris Crowe) (6)
MIME Types (1)
Misc (72)
Oulook Express (2)
Silverlight (1)
SQL Server (27)
SQL Server CTE (1)
Vista (15)
Vista Gadgets (8)
Visual Studio (11)
Voice over BroadBand (1)
Windows (33)
Windows Powershell (3)
Windows Sharepoint Services (0)
Windows Sharepoint Services (15)
Windows Vista (14)
Wine Cellar (1)
WMI (8)

Archive

July 2005 (6)

Asp.NET HTML Template Engine
http://joel.net/code/dotnet_templates.aspx

Quickshift for Microsoft SQL Server: Breakthrough Performance

Increase your SQL Server performance by 100% - 500% simply and easily with this product.

  • Optimizing queries.
  • Tuning performance.
  • Rewriting applications.
  • Running jobs overnight.
  • Babysitting misbehaving batch processes.

http://www.quickshift.com/index.shtml


Squishy Forums for ASP.NET written in c#
SquishyFORUMS is written in C# using Microsoft's new .NET framework. It is a completely object oriented class library (API), which can be used from ANY type of application (web application, web service, console application, or even a windows application), for any type of 3-level application you can think of. It supports Bulletin Boards, eZines, Weblogs, and any sort of application where you need a set of top-level data controlled by administrators, a middle level of data controlled by registered users (in a bulletin board or eZine, this would be by site admins only, whereas in a bulletin board it would be any registered user), and a bottom level of messages entered by registered users.

squishyFORUMS is built with an extensible architecture, meaning that every major event that happens throughout normal use of the APIs generates a number of events. This means you can attach to events and perform custom handling when these events happen. There is also a built-in VBA-like interface for you to write compiled code and have squishyFORUMS automatically execute your code when these events happen. This allows you to customize many parts of your application, so you can tailor it to your own needs, without major code changes or complex data manipulation.

squishyFORUMS contains a built-in template processing interface. Using the power of SFSLT (squishyFORUMS Stylesheet Language for Transformations), you can create static versions of your data, XML news feeds, or any other text-based view of your data. SFSLT is XSLT-like, in that you can dynamically create output nodes, variable setting and retrieving, and even use if statements, all in the template itself. Combine that with a number of contextual and looping tags specific to SFSLT, and you can publish every part of your forums! Or combine it with the built-in FTP support, and you can FTP static HTML pages from one server to another.
 

SQL Server -Error 15023 : User 'XXXX' already exists in the current database.

After doing a restore from a SQL Server backup, the users login rights are removed from the database yet the user itself still remains in the roles of the database. This means that when you try and add the user again you get the error "Error 15023: User "XXXX" already exists in current database" and the addition fails. (where XXX is the user you wish to add)

The quickest way to get this working is using query analyser and running the following command when working on the actual database.

EXEC sp_dropuser 'XXXX'

This will drop the user from the database and you can then re-add the user through the GUI or through a SQL query!


I received an email “11 May 2006” saying that I stole this post from http://www.irishdev.com/blogs/hughmcgauran/default.aspx  which it looks like I did. I do apologise for this as I normally give credit where it is due.

I probably wanted it for my own use and sometimes I post to this blog so I know where to return to, and since it was so so small I probably did not refer any one reading it to Hugh's blog since it was the full article.

So I apologise to Hugh Mc Gauran!


New Project - Free Online Wine Cellar

I have decided to create a new project for myself.

This project will be a free online wine cellar with forums and info on wineries, wines, and of course the ability to store your wine lists online.

The web application will be a c# web application that is to be custom written in asp.net using the .Net Framework V2.0

There may be a seperate windows application (if I get time) so that you can maintain your Wine Cellar off line and then syncromize with the online version.

Some features that the online cellar should support.

  • Intelligent addition of new records.
  • Charts and graphs of your wine, aging potential, and when to drink.
  • Custom rooms or bins or layouts
  • Forums
  • Rating of wineries
  • Simple Interface
  • Google Ads to help fund the project.

Who is Chris Crowe

Hi,

Welcome to my Blog. I use to own a web site called www.iisfaq.com which was a great resource for Internet Information Server or IIS for short.  I wrote a lot of articles and tips and tricks relating to IIS and products that were available for IIS. When I sold the web site I stopped helping people which was good for a while since it gave me time to think about myself instead of others.

I have now decided to get back into helping the community - can't think about my self all of the time!

I am an IIS MVP - what is an IIS MVP? A Internet Information Server - Most Valuable Professional as Microsoft puts it. Basically this means Microsoft has noticed that I like to help people and as such they rewarded me with the MVP title a number of times. 

For more details on the Microsoft MVP program see - http://mvp.support.microsoft.com

I hope to write about things that will be usefull to everyone who deals with IIS and WSS (Windows Sharepoint Services) and Front Page and anything else that takes my fancy.

I have attained the following Microsoft Certifications over the years:

  • Microsoft Certified Professional
  • Microsoft Certified Professional + Internet
  • Microsoft Certified System Engineer
  • Microsoft Certified System Administrator
  • Microosft Certified Database Administrator

I have passed the following Microsoft MCP exams: 

70-059   Internetworking with Microsoft® TCP/IP on Microsoft® Windows NT 4.0   Dec 15, 1998
70-087   Implementing and Supporting Microsoft® Internet Information Server 4.0   Oct 27, 1999
70-088   Implementing and Supporting Microsoft® Proxy Server 2.0   Jan 31, 2000
70-058   Networking Essentials   Dec 06, 2000
70-067   Implementing and Supporting NT Server 4.0   Dec 20, 2000
70-073   Implementing and Supporting NT 4.0 Workstation   Jan 10, 2001
70-068   Implementing and Supporting NT Server 4.0 in the Enterprise   Jan 31, 2001
70-028   Administering Microsoft® SQL Server 7.0   Jul 09, 2001
70-210   Installing, Configuring, and Administering Microsoft® Windows® 2000 Professional   Nov 19, 2001
70-215   Installing, Configuring, and Administering Microsoft® Windows® 2000 Server   Dec 17, 2001
70-217   Implementing and Administering a Microsoft® Windows® 2000 Directory Services Infrastructure   Jan 28, 2002
70-218   Managing a Microsoft Windows 2000 Network Environment   Jul 22, 2002
70-229   Designing and Implementing Databases with Microsoft® SQL Server™ 2000 Enterprise Edition   Nov 01, 2002
         
I work for Trimble Navigation in Christchurch, New Zealand as a Database Administrator. The company is considered one of the larger employers of application programmers in the region.

We currently have around 190 employees with most being developers, testers, and general technical people.

I work with the following products in my day to day work:

  • HTML, VB, VBScript, ASP, .NET Framework using c# for ASP.NET, XML and PHP
  • Microsoft Windows Sharepoint Services
  • Microsoft SQL Server 2000
  • Microsoft Office - All Versions
  • Windows 95, 98, ME, NT4, 2000 and XP, 2003
  • Remedy CRM
  • Xerox Docushare

As part of my role I also work on our internal help desk two half days per week; this spreads the load and everyone in the IS department does this.

I find that this allows me to keep up to date on current trends and of course in the problems that users are having.

Chris