This white paper introduces Microsoft SQL Server developers to the international features of Microsoft SQL Server 2005. Topics covered include an explanation of Unicode, added support for supplementary characters in SQL Server 2005, the changes in collation in different versions of SQL Server, changes in data types, performance, updates on data providers, and new international support features in SQL Server 2005 Analysis Services and Integration Services.

TSQL Spam-killer

by Additional Articles

SimpleTalk

T-SQL

In which Phil takes a break from a tedious bit of routine coding to build a Spam Filter in SQL.

The Tax Warehouse

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones looks at how SQL Server is in use at the Internal Revenue Service.

Tracer Token

by Mohan Kumar

SQLServerCentral.com

Replication

Measure Latencies in Replication implemented using SQL Server 2005

Retrieve XML data values with XQuery in SQL Server 2005

by Additional Articles

SearchSQLServer

Use XQuery scripting language to retrieve specific XML data type values in SQL Server. Learn to script and use Value() and Query() to retrieve single and multiple XML values.

Seeing Double

by Steve Jones

SQLServerCentral.com

Editorial - MP3

SQL Server allows some interesting index behavior and there's been some debate over whether it makes sense or not. This Friday Steve Jones asks if you have a reason for this.

Seeing Double

by Steve Jones

SQLServerCentral.com

Editorial - iPod

SQL Server allows some interesting index behavior and there's been some debate over whether it makes sense or not. This Friday Steve Jones asks if you have a reason for this.

Seeing Double

by Steve Jones

SQLServerCentral.com

Editorial - WMV

SQL Server allows some interesting index behavior and there's been some debate over whether it makes sense or not. This Friday Steve Jones asks if you have a reason for this.