Clustering Windows 2003 R2

In this presentation, you'll learn step-by-step how to cluster Windows 2003 R2. Brian shows you how to configure and cluster a two node cluster, preparing it for any future services like SQL Server or Exchange.

Windows and SQL Server 2005 Clustering Architecture

Before you start learning how to cluster, this video will show you the basics on how clustering in Windows 2003 and SQL Server 2005 works. Brian shows the basic architecture on clustering as well as the checklist that you would want to follow before starting to cluster.

Maintaining SQL Server 2005 Databases - Backups

In this presentation for SQL Server newbies, you'll learn how to maintain your SQL Server databases by backing them up regularly and reindexing them. This topic assumes you know nothing about SQL Server and also covers some of the decisions you'll have to make when you decide you want to backup your database through maintenance plans.

SQL Server 2005 – Unattended installation – Part V

In this section of this series, I am going to demonstrate how to install SQL server 2005 service pack 1, to update the server components using command line options.

Automating SQL Express Backups

SQL Express has no mechanism to schedule backups and maintenance of your instance. In this video, Brian shows you how to automate and schedule backups of SQL Express with a simple scripted solution.

SQL Server 2005 Installation Adventures

In bringing the SQLServerCentral.com training center online, one of the challenges Andy Warren faced was developing an automated way to install software. Here we see some of the gotchas and difficulties that you might encounter as well with unattended installations of SQL Server.

What does the CEILING() function do?

What is row versioning in SQL Server 2005?

When starting SQL Server 2005 from the command...

Using the SQL Server Surface Area Configuration

So, you’ve just installed SQL Server 2005 but don’t know how to configure it. This video will instruct you how to use the SQL Server 2005 Surface Area Configuration tool to turn on SQL Server features like CLR integration and how to enable ports. Free registration required.