Database Development Zone

n all the excitement about SQL Server 2005 (formerly codenamed Yukon), most people tend to focus on the .NET integration. But the native support for XML might turn out to

y previous 10-Minute Solution “Optimize the Massive DELETE Operation in Oracle, Part 1” described the technique for performing a high-performance massive DELETE operation as a direct-path INSERT. At the end

ne much-lauded feature of PostgreSQL is transactions. Transactions in a database help prevent accidental data loss or misrepresentation. For example, let’s say you want to delete records from a table.

ave you ever found it tedious to mix SQL and other languages, or been reluctant to write the same four lines of code again to do a simple database query?

icrosoft’s free server tool, ADS (Automated Deployment Services), provides system administrators with a consistent way to deploy the Windows OS, but what about RDBMS deployment? Does setting up SQL Server

any organizations are developing applications that provide information to users and employees when they need it?regardless of their locations. These types of applications, called notification applications, offer these organizations many

ven a casual observer of today’s IT scene has seen the buzzword storm that has developed around various forms of technology-enabled business management and monitoring: Business Performance Management (BPM), Business

lthough electronic records have been around since the first databases, regulations about how to manage them are coming onto the scene only now. Legislation such as the Sarbanes-Oxley Act and

f you need a way to search through various documents with differing formats (PDF, Word documents, PowerPoint presentations, Excel spreadsheets)?including Web content?use Oracle Text. Oracle Text has a powerful text-search