SQL Server Full Text Search: Language Features

SQL Full-text Search (SQL FTS) is an optional component of SQL Server 7 and later, which allows fast and efficient querying when you have large amounts of unstructured data. This is the first of a two-part article that explores the full-text language features that ship with SQL Server versions 7, 2000, and 2005, with particular focus on the new language...

Read More

Installing large numbers of files with WIX

Many posts (e.g.: http://blog.deploymentengineering.com/2007/06/dealing-with-very-large-number-of-files.html, http://www.wintellect.com/cs/blogs/jrobbins/archive/2007/10/19/wix-the-pain-of-wix-part-2-of-3.aspx, http://blog.deploymentengineering.com/2007/06/burning-in-hell-with-heat.html) have been written about the problem of adding large number...

Read More

From IIS6 maxRequestLength to IIS7 maxAllowedContentLengthFile - specifying maximum file upload size

IIS6 uses the maxRequestLength config setting under the system.web section to specify maximum file upload size with a default of 4 MB.  IIS7 uses the maxAllowedContentLength config setting under the system.webServer section to specify maximum file upload size with a default of 28.6 MB.  This is something to watch out for when migrating your web application from IIS6 to IIS7.  Read on for more information how I found out about this...

Read More

Generating a random strong password

The ASP.NET Membership system has a static method built-in for this.  You can use the GeneratePassword static method from the Membership class to create a new password: String strongPassword = System.Web.Security.Membership.GeneratePassword(8, 1); From the MSDN documentation, the two parameters are: length – Int32 The number of characters in the generated password. The length must be between 1 and 128 characters. numberOfNonAlphanumericCharacters...

Read More

Five common mistakes in the web.config file

5 of the most common mistakes developers make when they manipulate the web.config file. 1. Custom Errors Disabled When you disable custom errors as shown below, ASP.NET provides a detailed error message to clients by default. Vulnerable configuration: <configuration> <system.web> <customErrors mode="Off"> Secure configuration: <configuration> <system.web> <customErrors mode="RemoteOnly"> ...

Read More