Recover Those Packages!

• by Steve Jones

• SQLServerCentral.com

• DTS

Ever need to recover a single package? Don't have local backups? Read this!!!

An interview with Robin Dewson

• by Jon Winer

• SQLServerCentral.com

• Miscellaneous

Want to learn more about some of your favorite authors. Check out this interview with Robin Dewson.

Review: Loading Sample Data with DataTect 1.6

• by Brian Knight

• SQLServerCentral.com

• Product and Book Reviews

So, you've created a database and application and want to see how it operates with a substantial load of data In this product review of Datatect 1.6, you can learn how this third-party product could help you benchmark you database with a lot of sample data.

Pseudo web service using xmlHTTP

• by Leon Platt

• SQLServerCentral.com

This article delves into the mysterious xmlHTTP object and the supporting ASP code. I've got to tell you that I really love using this object. Basically what I like about it is that through xmlHTTP you can expose some or all methods of any ActiveX class to the client-side user. What this means is you are giving the user the capability of calling your back-end Active X controls. And the best part of it all is that the entire communication process takes place behind the scenes!

Signs Your Co-Worker is a Computer Hacker

• by Steve Jones

• SQLServerCentral.com

• The Lighter Side

Watch out for these guys

ASP and ADO Gotcha - Duplicate Field Names in a Query

• by Leon Platt

• SQLServerCentral.com

• ASP

Recently while working on the SQLServerCentral.com site, Leon Platt ran into an interesting ADO gotcha that he demonstrates in this quick tip.

The Ultimate SQL Server

• by Additional Articles

• Other

• Performance Tuning

From a DBA's point-of-view, the bigger the SQL Server box, the better. What would you consider to be the ultimate SQL Server box?

Save Your Packages Locally

• by Steve Jones

• SQLServerCentral.com

• DTS

DBAs often ask how to transfer DTS packages and move them between servers. They also want a version control system that is more robust than that provided in msdb. Steve Jones looks at one of the features of the DTS designer that solves both of these problems.

Upsize Your Database: Convert Your Microsoft Acces

• by Additional Articles

• Microsoft MSDN

• Basics

What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0.

Book Review:Admin 911: SQL Server 2000

• by Steve Jones

• SQLServerCentral.com

• Book Reviews

This is a great administrative reference for anyone using SQL Server 2000.