Articles

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.

2008-04-25

3,058 reads

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.

2008-04-25

2,452 reads

Tracer Token

by Mohan Kumar

SQLServerCentral.com

Replication

Measure Latencies in Replication implemented using SQL Server 2005

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(17)

You rated this post out of 5. Change rating

2008-04-24

5,977 reads

Discuss

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.

2008-04-24

4,234 reads

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2008-04-24

40 reads

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2008-04-24

40 reads

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2008-04-24

40 reads

UPSERT Functionality in SQL Server 2008

by Additional Articles

Database Journal

SQL Server 2008

This article illustrates the functionality of UPSERT via the MERGE command in SQL Server 2008.

2008-04-24

6,046 reads

Reading the SQL Server log files using T-SQL

by Additional Articles

MSSQLTips.com

T-SQL

One of the issues I have is that the SQL Server Error Log is quite large and it is not always easy to view the contents with the Log File Viewer. In a previous tip "Simple way to find errors in SQL Server error log" you discussed a method of searching the error log using VBScript. Are there any other easy ways to search and find errors in the error log files?

2008-04-23

4,240 reads

Same Report but Different Methods in SQL Server Reporting Services

by Additional Articles

SQL Server Performance

Reporting Services (SSRS)

In Reporting Services in SQL Server 2005 there are several ways of achieving the same result. This article introduces how we can create the same report using several different methods.

2008-04-23

3,128 reads

Articles

International Features in Microsoft SQL Server 2005

TSQL Spam-killer

Tracer Token

Retrieve XML data values with XQuery in SQL Server 2005

Seeing Double

Seeing Double

Seeing Double

UPSERT Functionality in SQL Server 2008

Reading the SQL Server log files using T-SQL

Same Report but Different Methods in SQL Server Reporting Services

Blogs

PlanTrace Now Supports PostgreSQL

A New Word: the Kinder Surprise

Crash-Consistent Snapshot Cloning - Hyper-V Edition

Forums

BCA KCP Mega Kuningan Telpon/wa.0853.7373.7699

BCA KCP Kalimalang Tlpn/wa0853.7373-7551

BCA KCP Klender Tlpn/wa0853.7373-7551

Question of the Day

SSoL Support on the OS