Transferring a SQL Server Diagram

So you've created a diagram that you now need to transfer to a different server or database. This article will show give you a step-by-step guide on how to do this.

You wish to configure SQL Mail to use...

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.