(Hitesh Seth) Microsoft developers working with Visual Studio and COM/OLE technologies have always enjoyed the benefits of a choice of programming languages for development of applications and components. Well, sort of. (For instance, components developed in one programming language couldn’t be “inh
Other News
DB2 Universal Database Version 8.2 and the Rational Extreme Development Environment
(Paul Zikopoulos) DB2 Universal Database (DB2 UDB) Version 8.2 became generally available in September 2004. This release includes lots of enhancements for developers: a Java 2 Platform, Enterprise Edition (J2EE) certified and redistributable JDBC Type 4 driver, support for CLR-based stored procedur
Oracle Migration Workbench – Part 1
(Steve Callan) Let me start with a bad news/good news situation. The bad news: as far as job searches are concerned, it is becoming readily apparent that knowing only Oracle is not good enough anymore. Personally, I have taken major hits for not knowing SQL Server and have heard some static about DB
The Power of SQL CASE Statements
(Scott Mitchell) As developers creating data-driven Web applications, we’ve all written more than our fair share of SQL statements. If I had a nickel for every SELECT statement or UPDATE statement I’ve written in my six years as a Web developer, I’d be a rich man. Despite the familiarity with SQL th
How to control DDL commands in your database
(Cassio Ferrari) For many years, we had problems in our production databases: tables would be dropped or truncated accidentally, or someone would create undesired objects. Also, we sometimes needed to do maintenance and we don’t want unauthorized users to change something in the database. To fix
Overview of Enhancing Database Performance and I/O Techniques
(Craig Borysowich) In addition to the disk subsystem there are various components affecting the performance of any database application. In most cases, a good part of the performance improvement can be achieved from database design, physical layout of tables and indexes, appropriate indexes and
Reading a Trace File using C# in SQL Server 2005
(graz) SQL Server 2005 includes Server Managed Objects (SMO) which is a managed API to SQL Server. These are primarily used to administrative tasks and replaces DMO. One of the features of this is the ability to programmatically read trace files. This article walks through the code needed to read a
XML Strengths & Weakness’ with DOM, ASP & XSL – Introduction
(Nakul Goyal) This article explains in a very simple manner how you can use XML in ASP and VB. Since the inception of XML people many developers have wondered why we need XML… How is it better than HTML? For starters, XML is far more powerful than HTML, and that power resides in the “X” in XML (wh
DB2 Integrated Cluster Environment Deployment Guide
(Whei-Jen Chen) The IBM DB2 Integrated Cluster Environment for Linux is a completely integrated, high-performance, and pre-tested solution that incorporates best-of-breed software, hardware, and services. This IBM Redbook provides you with the technical details of the DB2 Integrated Cluster Environm
Integration Imperative
(Rich Schwerin) Few, if any, of today’s business applications work in isolation. From the moment a sales rep engages a customer to the moment the account is paid and the order fulfilled, numerous heterogeneous applications and services combine behind the scenes to create business processes. Integrat