by MAK [Muthusamy Anantha Kumar] – DBAs are always running out of hard disk space when handling large databases such as data-warehouse databases and other VLDB. Backing up such databases to disk occupies more disk space, since Microsoft SQL Server does not have compression built into the backup proc
Other News
ADO Connection Strings
By Michael Otey – These connection-string examples illustrate the seven most common connection scenarios. (R, $)
Replicating SQL Server 2000 across Heterogeneous Databases
From SQLTeam.com – This article was submitted by Sujoy Paul. He writes “The plethora of mission critical databases in most companies has made it imperative to harness the valuable data by integrating across various database vendors and on different platforms. The seamless integration of the complexi
DB2 Basics: Creating your first trigger in DB2 Universal Database
Creating DB2 triggers doesn’t have to be complicated. Join author Kulvir Singh Bhogal as he walks you through the process of creating a trigger used in a mock banking scenario.
Database Server Clash Revisited
By Timothy Dyck – eWEEK and sister publication PC Magazine early last year published results of a comparative performance test of database servers. It had been almost a decade since either publication had performed a similar test, so we expected significant interest in the story.The actual r
DB2 Developer’s Guide
Book by Craig S. Mullins – DB2 performance techniques for applications programs! This book explains the development environments of DB2. “Includes many tips and experience-based techniques. Discusses encoding efficient SQL, monitoring, and tuning DB2 performance”. Covers Version 2.3.
Oracle Optimizer: Moving to and working with CBO – Part 2
By Amar Kumar Padhi – Part 2 of this series covers the Initialization parameters and Hidden or Internal Oracle parameters that influence the Optimizer in choosing execution plans. It is very important to setup these parameters properly.
Oracle e-Mails Raise Questions About Motive
By Renee Boucher Ferguson – The release of uncensored court documents around Oracle Corp.’s hostile bid for PeopleSoft Inc. has raised the mudslinging between the two companies to a near fever pitch.
Java & XML, 2nd Edition – Solutions to Real-World Problems
By Brett McLaughlin – Chapter 12: SOAP – In this chapter, I explain what SOAP is, and why it is such an important part of where the web development paradigm is moving. That will help you get the fundamentals down, and prepare you for actually working with a SOAP toolkit. From there, I briefly run ov
.NET Web Services Security
by Juval Löwy – .NET has a lot to offer when it comes to both developing and consuming secure Web services. .NET allows developers to either rely on Windows-based authentication or develop custom authentication mechanisms. Each option has its own tradeoffs and implications on the programming models.