Another Method of Testing for Updated Columns in a Trigger

This article by Andy Warren discusses how to use if update() in your update triggers to simplify your code. They are easy to use and quite effective!

You sign in to the SQL Server, create...

You are in charge of benchmarking an application...

What does the SQLDiag support utility not produce...

myLittleAdmin v2.5 available

myLittleTools.net is pleased to announce the release of its web-based MS SQL and MSDE database administration tool. Several tools have been added, including "BackUp and Restore database" tools, "CSV Import" tool, "Generate INSERT scripts" tool, "Detach/attach database" tool. Several toys have also been added, including the possibility to display database space used with SVG graph, or a new skin.

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