Author: SSWUG Research

Community

DTS Basics

Many organizations need to centralize data to improve corporate decision-making. However, their data may be stored in a variety of formats and in different locations. Data Transformation Services (DTS) addresses this vital business need by providing a set of tools that lets you extract, transform, a

Community

Best Practices in Data Archiving

(Drew Robb) Databases usually have two things in common. They have grown far larger than envisioned by their creators and they are filled with unneeded data. Many companies, therefore, are seeking to pare them down to the essentials and archive little used content. But what should you archive, how s

Community

Getting PDC Content

(Brian Moran) If you didn’t make it to the Microsoft Professional Developers Conference (PDC) this year, then you missed a tremendous amount of information about upcoming Microsoft technologies, including SQL Server’s next release, code-named Yukon. Fortunately, you don’t have to miss all the techni

Community

Linux Databases: DB2 vs. Oracle

(Branham Group) This is a report prepared by Branham Group Inc. that compares the two leading commercial database software packages for Linux: Oracle 9i version 9.2 Enterprise and IBM DB2 version 8.1.2 ESE. Comparison is based on cost of ownership, ease-of-use, reliability, and scalability. The resu