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

SQL Server 2000<BR><BR>I need to change the collation for a database from case senstitive to case insensitive. <BR><BR><pre class="ip-ubbcode-code-pre">ALTER DATABASE ...

A fundamental skill for DBAs is to have a firm understanding of the SQL Server database engine's system databases. Tim Chapman discusses these system databases. A fundamental skill for DBAs is to have ...