(Roger Schrag) Prior to Oracle 10g, one of the only supported ways to move an Oracle database across platforms was to export the data from the existing database and import it into a new database on the new server. This works pretty well if your database is small, but can require an unreasonable amou
Other News
Overloading Procedures in PL/SQL
(Lewis Cunningham) A FAQ that I get, well, frequently, is about overloading procedures. I think most people get how to overload but not when or why. Today I am going to explain a classic example of where overloading makes your life easier. More importantly, it makes the life of the code maintainer b
Getting Started with AJAX 1.0
(Mahesh Chand) Recently, Microsoft released the commercial version of AJAX 1.0 as an extension of ASP.NET 2.0. That means you can develop AJAX enabled Web applications using ASP.NET 2.0.
Design Patterns for ASP.NET Developers, Part 1: Basic Patterns
(Alex Homer) For the past year or so, I’ve been involved in documenting frameworks that help developers write better code, and create applications that are more efficient and easier to test, debug, maintain, and extend. During that time, it has been interesting to see the continuing development of b
Learning .NET: Getting started with Visual Studio Team System development
(Brian Eastwood) One of the biggest additions to Visual Studio 2005 was the introduction of Visual Studio 2005 Team System, or VSTS. This product — now available in editions for developers, architects, software testers and database programmers — emphasizes collaboration throughout the software dev
Writing a pure SQL based String Tokenizer
(Lucas Jellema) A quite common concept in many programming langiages, though perhaps strongest in Java, is the String Tokenizer. This is a utility class or function that takes a String as input, and optionally one or more delimiters, and breaks up the string in individual elements, returning those a
ADO.NET 2.0 The Series – Part One
(Mike McIntyre) This is part one of a multi-part article about ADO.NET 2.0. Part one introduces the ADO.NET 2.0 Object Model and provides source code which implements the ADO.NET Connection, Command, and Reader objects using the System.Data.SqlClient data provider.
XML for Perl developers, Part 2: Advanced XML parsing techniques using Perl
(Jim Dixon) For a surprisingly broad range of Perl applications, the XML tool of choice is XML::Simple, which was the subject of Part 1 of this series (see Resources). XML::Simple converts XML input files into an easily manipulated Perl data structure, and writes such data structures back out as XML
Is RAID 5 Really That Bad?
(Linchi Shea) RAID 5 is a dirty word in the DBA community and beyond. There are websites devoted to trash RAID 5. I’ve seen DBAs declaring performance root cause found the very moment they found out that some database files were placed on RAID 5 volumes. You’d be ridiculed and run out of town if you
Limit postbacks with ASP.NET 2.0 client callbacks
(Tony Patton) Developers have been grappling with the stateless nature of the Web since its inception. That is, once a page has been requested and loaded, the connection to the server is gone. The AJAX movement has put the spotlight on the XMLHTTP object, which enables server communication in the ba