Tuesday, March 29, 2005

HTML & CSS Validator

http://validator.w3.org/

http://jigsaw.w3.org/css-validator/

Forms Authentication with active directory

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetHT02.asp

Collation in sql server


The term, collation, refers to a set of rules that determine how
data is sorted and compared
. In Microsoft® SQL Server 2000, it
is not required to separately specify code page and sort order for
character data, and the collation used for Unicode data. Instead,
specify the collation name and sorting rules to use. Character data is
sorted using rules that define the correct character sequence, with
options for specifying case-sensitivity, accent marks, kana character
types, and character width. Microsoft SQL Server 2000 collations
include these groupings:


  • Windows collations - Windows collations define rules for storing
    character data based on the rules defined for an associated
    Windows locale. The base Windows collation rules specify which
    alphabet or language is used when dictionary sorting is applied,
    as well as the code page used to store non-Unicode character
    data. For Windows collations, the nchar, nvarchar,
    and ntext data types have the same sorting behavior as
    char, varchar, and text data types


  • SQL collations - SQL collations are provided for
    compatibility
    with sort orders in earlier versions of
    Microsoft SQL Server.


Sort Order

Binary is the fastest sorting order, and is case-sensitive. If
Binary is selected, the Case-sensitive,
Accent-sensitive, Kana-sensitive, and
Width-sensitive options are not available.



"all" width="90%" border="1">



























Sort order

Description

Binary

Sorts and compares data in Microsoft® SQL
Server™ tables based on the bit patterns defined for
each character. Binary sort order is case-sensitive, that
is lowercase precedes uppercase, and accent-sensitive.
This is the fastest sorting order.

If this option is not selected, SQL Server follows sorting
and comparison rules as defined in dictionaries for the
associated language or alphabet.

Case-sensitive

Specifies that SQL Server distinguish between uppercase
and lowercase letters.

If not selected, SQL Server considers the uppercase and
lowercase versions of letters to be equal. SQL Server does
not define whether lowercase letters sort lower or higher
in relation to uppercase letters when Case-sensitive is
not selected.

Accent-sensitive

Specifies that SQL Server distinguish between accented and
unaccented characters. For example, 'a' is not
equal to 'á'.

If not selected, SQL Server considers the accented and
unaccented versions of letters to be equal.

Kana-sensitive

Specifies that SQL Server distinguish between the two
types of Japanese kana characters: Hiragana and
Katakana.

If not selected, SQL Server considers Hiragana and
Katakana characters to be equal.

Width-sensitive

Specifies that SQL Server distinguish between a
single-byte character (half-width) and the same character
when represented as a double-byte character
(full-width).

If not selected, SQL Server considers the single-b



SQLServer DTS wizard usage

http://aspalliance.com/articleViewer.aspx?aId=644&pId=-1

Tool bar controls and magic library

Please have a look at codeproject controls.
http://www.codeproject.com/cs/menu/ToolBarDock.asp

and you can superb aesthetic controls from Crownwood software.(magic library)
http://www.dotnetmagic.com/

help collection in vs dot net ide

Creating the Help Collection
Follow the steps below to create a Help collection in Visual Studio 2003.
In Visual Studio, click the File command, point to New, and click Project to display the New Project dialog box.
In the Project Types pane, expand the Other Projects folder, and click Extensibility Projects.
In the Templates pane, click Help Integration Wizard, type TestCollection in the Name box, and click OK.
The Help Integration Wizard appears.
On the Choose Project Settings page, select Stand-alone Setup Project, select Visual Studio 2003 from the Target dropdown list, and click Next.
On the Select Collection Files page, click Add to display the Add Help Files dialog box. Browse to the \Program Files\Common Files\Microsoft Shared\Help\1033 folder, click dexplore.hxs, and click Open.
The wizard adds dexplore.hxs to the Source Files list.
Click Next to the display the Build The TOC page.
In the Plugin Style group box, select Flat.
The top-level node disappears from the Help Collection TOC tree view.
Click the Insert Node button on the toolbar.
A blue node, titled New Node, appears in the Help Collection TOC pane.
Select dexplore in the Exclude From TOC pane and click Include.
The top node of the dexplore.hxs table of contents, titled Help on Help, is added below the node titled New Node.
Select the Help on Help node and click the Move Node Right button on the toolbar.
The Help on Help node becomes a child of the New Node node.
Select the New Node node and click the Properties button on the toolbar.
The Node Properties dialog box appears.
Expand the dexplore node and select /about/about_dexplore.htm.
The HTML

CSharp date time utilities

http://www.codeproject.com/csharp/CSDateTimeLibrary.asp

web farms Avalon and indigo

Webfarms - 1
http://www.dotnetbips.com/displayarticle.aspx?id=290
Webfarms - 2
http://www.dotnetbips.com/displayarticle.aspx?id=292

The March Avalon and Indigo Community Technology Previews are available for public download. They had previously only been available to MSDN subscribers. This preview only works with the February CTP of Visual Studio 2005.

Indigo and Avalon are the codenames for two strategic developer technologies that Microsoft plans to ship in 2006 as part of the Windows "Longhorn" operating system. In addition, Microsoft is making these technologies available on Windows XP and Windows Server 2003. The Indigo and Avalon Community Technology Preview (CTP) enables developers to experiment with early builds of these technologies, get acquainted with the development experience, and provide Microsoft with feedback. This CTP release recently became available to MSDN subscribers and is now being released to the general public in response to numerous requests.

Indigo is the codename for Microsoft’s unified programming model for building connected systems. It extends the .NET Framework 2.0 with additional APIs for building secure, reliable, transacted Web services that interoperate with non-Microsoft platforms and integrate with existing investments. By combining the functionality of existing Microsoft distributed application technologies (ASMX, .NET Remoting, .NET Enterprise Services, Web Services Enhancements, and System.Messaging), Indigo delivers a single development framework that improves developer productivity and reduces organizations’ time to market.

Avalon is the code name for Microsoft's unified presentation subsystem for Windows. It consists of a display engine and a managed-code framework. Avalon unifies how Windows creates, displays, and manipulates documents, media, and user interface. This enables developers and designers to create visually-stunning, differentiated user experiences that improve customer connection. When delivered, Avalon will become Microsoft's strategic user interface (UI) technology.
http://www.microsoft.com/downloads/details.aspx?familyid=85ab132b-f1aa-4422-b053-272d79863013&displaylang=en

A whooping 443 MB file

Sending HTML emails through dot net

http://www.microsoft.com/belux/nl/msdn/community/columns/ceulemans/sendhtmlemail.mspx