What does the HOST_NAME() function do?

Using VBScript to Automate Tasks

This article discusses why VBScript should be one of the tools you use to manage your server. Sample scripts show how to remove files over x days old and how to FTP files.

Review of AdeptSQL

Another product review! Chris put AdeptSQL (a schema comparison and sync product) to work and wrote up the results. This article also includes some feedback from the vendor that is worth reading.

Email and Yukon - What Changes Would You Like?

Microsoft is soliciting input on email functionality in Yukon. Follow the link to complete the survey. You can also discuss it here on the site:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=17739&FORUM_ID=9&CAT_ID=1&Topic_Title=SQL+Mail+and+Yukon%2C+what+do+you+want+to+see%2E%2E%2E&Forum_Title=General

You are a database administrator with sysadmin permissions...

SQL Server Security: Server Roles

As yo probably know, Brian covers security topics for us and does a great job. This week he looks at the fixed roles and points out a few things you may not have thought about.

You've purchased some new disk drives and installed...

You want to create a database backup on...

What database option could have the most substantial...

You'd like to load lots of historical data...