Moving Your Database to a New Server

As DBAs we try our best to appropriately size a SQL Servers to match the anticipated load. But things change over time and we may find that some databases are overloading the server. When it's time to move your database to a new home on another server, Paul Mu brings us a technique for doing so.

You are loading 100 rows of data into...

E-Mail Functionality in SQL Server 2005

Sending an e-mail has become very important in any system for purposes such as sending notifications. SQL Server database has an integrated mailing system. With the arrival of SQL Server 2005, users now have the new functionality of Database Mail, which is different from SQL Server 2000 SQL Mail. The purpose of this article is to introduce Database Mail and highlight the advantages of using it over legacy SQL Mail.

How can SQL Server Agent Mail send messages...

Service Pack 2 CTP

Service Pack 2 for SQL Server 2005 has been released as a CTP. Steve Jones installed it and has a few thoughts on this pre-release product.

Step-by-Step Guide: Installing SQL Server 2005 Reporting Services

Working with a new piece of technology can be intimidating. Not having the technology installed correctly can only lead to more difficultly. This guide outlines steps to properly install SQL Server 2005 Reporting Services and the current service pack to get you going in the right direction.

Toying with template parameters in SQL Server 2005

If you create functions or stored procedures from SQL Server 2005 Management Studio, you will notice that the new window is filled with a template. In general, you get a skeleton interspersed with markers. This article discusses how you can use templates.

Using Report Builder, which of the following statements...

If you absolutely need a report to look...

After you've completed a backup for your Sales...