Restore a DTS package from a DTS Store

• by Bruce Szabo

• SQLServerCentral.com

• DTS

Probably not a task you'll have to do very often, all the better that someone has laid out how to do it in good detail!

Review of Guru's Guide to SQL Server Architecture and Internals

• by James Travis

• SQLServerCentral.com

• Miscellaneous

If you are (or want to be) a power user, this book should be on your shelf. How many books have you read that have you using a debugger to step into the sql server process? James gives it a thumbs up!

Tame Those Strings - Using SUBSTRING

• by Steve Jones

• SQLServerCentral.com

• Advanced Querying

In this article by Steve Jones, he shows you how to manipulate strings.

Beginning ADO.NET

• by Additional Articles

• Other

One of the strengths of Visual Studio .NET is its features for rapid application development, or prototyping. If, for example, you want to develop a Windows form that lets you maintain the data in one table of a database, you can usually do that in 20 minutes or less. This article will show you how.

The Need For Speed - Upgrading Your Servers

• by Steve Jones

• SQLServerCentral.com

• Administration

Do you have the need for more speed on your servers? How do you go about squeezing more speed out of the database when faced with an upgrade? Steve Jones walks through some of his thought process when looking at ugprade for one of his servers.

SQL Server Auditing and Notification

• by Jeffrey Yao

• SQLServerCentral.com

• Administration

As Jeff says, "There are lots of articles about how to do auditing, but there are few discussions about how to use the auditing results in a real time environment". Well, now we have one that shows you how to do it!

Review of Review of SQL Server 2000 Administrators' Companion

• by Frank Kalis

• SQLServerCentral.com

• Administration

Nice write up on the Admin Companion. Should you add it to your bookshelf? Frank offers his frank opinion.

Tame Those Strings - Part 8

• by Steve Jones

• SQLServerCentral.com

• T-SQL

Continuing Steve Jones' series on string manipulation in T-SQL, this article examines how quotations are handled in T-SQL.

Working with the Registry

• by Dinesh Asanka

• SQLServerCentral.com

• Miscellaneous

It's not often you'll need to access the registry from SQL, but when you do - these functions make it happen!

SQL Server 2005 Feature Survey Results

• by Brian Knight

• SQLServerCentral.com

• News
• Uncategorized

A week ago, we solicited readers to let Microsoft know which of the SQL Server 2005 announced features mattered most to them. We had a great response, with 890 of you answering the survey in three days. The answers were pretty interesting. The full results can be seen at the bottom of this article.