With each new release, SQL Server gets easier to manage. That doesn’t mean the product is growing simpler, however. To make upgrading a compelling prospect, Microsoft naturally introduces new features ...

I haven't been much of a technical guy for a while but I'm installing Microsoft Team Foundation Server 2005 on Windows Server 2003 R2.<BR><BR>This machine already has a SQL Server 2005 installation, ...

Collation describes the code page, case sensitivity, accent sensitivity, and language or alphabet in use. This SQL Server tip illustrates how you can force the use of any specific collation. Collation ...

I started getting these weird messages from MySQL there's a collation conflict in one of my prcedures. I did some experiments, and found that while every column in every table in the DB, as well as ...