SQL Server

How to manually add a database (SQL 2005/2008)

This article will explain how to manually create a database and user for SQL server 2005/2008.

Full-Text Search in SQL Server 2005 Express Edition

This article explains how to perform Full Text searches using SQL Server 2005 Express Edition with Advanced Services.

How to manually attach databases in Management Studio

This article details the process for manually attaching databases files in SQL Server Management Studio.

How do I schedule Automatic Database Backups?

This article will walk you through how to schedule your SQL server to automatically generate backup copies of your databases on a nightly basis.

Where can I find more information on SQL Server 2008?

This article will point you in the right direction for learning more about SQL Server 2008.

Connect to SQL Server 2005 using Managment Studio 2008

This article shows how to get around the security error you receive initially upon connecting to a SQL Server 2005 using Management Studio 2008.

How to run an SQL query

How to run an SQL query using SQL Server Management Studio

SQL Authentication Types

This article covers the differences between SQL Server Authentication and Windows Authentication when connecting to a database through SQL Management Studio.

SQL Server 2005 Enterprise Edition System Requirements

The following article details the system requirements, both hardware and software, for SQL Server Enterprise Edition.

SQL Server 2005 Standard Edition System Requirements

The following article details the system requirements, both hardware and software, for SQL Server Standard Edition.

SQL Server 2005 Workgroup Edition System Requirements

The following article details the system requirements, both hardware and software, for SQL Server Workgroup Edition.

SQL Server 2005 Express Edition System Requirements

The following article details the system requirements, both hardware and software, for SQL Server Express Edition.

How to Backup a database using Management Studio

This article will walk you through How to Create a Backup file (.bak) of your Database, through SQL Server Management Studio Express.

Resetting the SA password for SQL Server

How to reset the password for the System Administrator, or 'sa' user account, within SQL Server Management Studio

Creating an SQL Server Database in Helm 4

How to create an SQL Server 2005 database and user in version 4 of the Helm Control Panel

Using Integrated SQL Server Security in your web site

This article describes how to use integrated SQL server authentication in your connection string. This does not apply to databases hosted on the shared database servers.