Introduction to SQL Server Management Studio

SQL Server Management Studio is used to manage, query and design SQL Server solutions. In this video you're shown the basics of how to use Management Studio.

Database Snapshots in SQL Server 2005

One of the brand new features in SQL Server 2005 is the database snapshot. New authors Arvinder Singh Khosla and S.Srivathsani Murthy bring us a look at how these static view databases can be setup and used in your environment.

Which of the following is not something the...

What does the max full-text crawl range option...

Data partitioning in SQL Server 2005 - Part III

Part III of the article series illustrates how to partition an existing table with data into four different file groups.

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.