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, ...

I am trying to write a select statement that joins two tables from different databases on my SQL server. The issue is that the two databases are different collation types. <BR><BR>DataBaseA is ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...