Consider the following scenario. On a computer that has Microsoft SQL Server 2000 Data Transformation Services (DTS) installed, you install Microsoft SQL Server 2005 Integration Services. Then, you use the dtsrun command prompt utility (Dtsrun.exe) to run a DTS package that contains the ActiveX Scri
Other News
Performance enhancements in IBM WebSphere Federation Server V9.1, Part 2: Performance characteristics of new functionality in WebSphere Federation Server
(Susanne Englert, Simon Harris and Holger Kache) Part 1 of this series covered new features in IBM WebSphere Federation Server that are specifically designed to enhance performance. Now in Part 2, learn about performance characteristics and configuration (where applicable) of significant new functio
GridView-DetailsView (Master/Detail) Control
(Chris Hambleton) The GridViewDetailsView control is an ASP.NET user control that displays a fully-featured GridView-DetailsView (Master/Detail) Control with the capability to edit existing records, insert new records, and delete records, along with sorting, filtering, and paging. The control can be
CreateXMLDB – Create an XML Database and Associated C# Class to Access it
(Jeff Gaines) I have been planning to convert my MS Access files to XML for some time, but had put it off because it is a tedious task.
Medians, ROW_NUMBERs, and performance
(Adam Machanic) A couple of days ago, Aaron Bertrand posted about a method for calculating medians in SQL Server 2005 using the ROW_NUMBER function in conjunction with the COUNT aggregate. This method (credited to Itzik Ben-Gan) is interesting, but I discovered an even better way to attack the probl
Additional Methods for Using SQLite with PHP 5
(Alejandro Gervasio) Welcome to the concluding part of the series “Using SQLite with PHP 5.” As you’ll possibly know, PHP 5 comes equipped with a fully-featured RDBMS called SQLite that definitely can make your life as a PHP developer much easier. It’s particularly helpful if you want to get rid of
Memory Structures of ORACLE
(Chetan) Oracle has two types of Memory Structures: System and Program.
And even more about DB2’s storage usage below the bar
(Willie Favero) So, we just talked about thread storage yesterday in my post “Did someone tell you that 64 bit would solve all of your DB2 storage issues?”. I have also had a post about the local statement cache being below the bar a few weeks ago: “The next episode in our KEEPDYNAMIC dialogue co
Decoding Microsoft’s New Document Formats
(Jeff Cogswell) For many years, Microsoft Office products have made use of a type of file called structured storage. This file type, which will soon be moved to the wayside, is a proprietary format that has its roots in the precursor to today’s ActiveX technology (called OLE, or Object Linking and E
Using SQL Developer to Learn Oracle
(Steve Callan) GUI interfaces into Oracle are becoming more and more common, and aside from the heavyweight TOAD, other products include SQL Developer, SQL Manager 2007 and SQL Edge. Inside of Oracle’s (free) SQL Developer 1.1 product is a tutorial, which includes a little bit about a lot of things