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

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.

Alternative to the Microsoft MMC Console

Are you frustrated by the limitations of the MMC console when managing dozens or hundreds or servers? The way Enterprise Manager is fitted into the framework can be a problem for DBAs with lots of servers. Jereme Guenther brings us a technique for his own console that solves some of the limitations of MMC.

BlackBelt Administration: Linked Reports in SQL Server Management Stud

Create Linked Reports from within SQL Server Management Studio. BI Architect Bill Pearson examines another approach for using Linked Reports to provide multiple "versions" of a single-source report.

Which of the following is an invalid file...