(Paul Zikopoulos) In a previous set of articles, I showed you all the great integration features between the IBM DB2 Universal Database for Linux, UNIX, and Windows Version 8.x (DB2 UDB) product and Microsoft Visual Studio.NET 2003 integrated development environment (IDE).
Author: SSWUG Research
XML Compression and its Role in SOA Performance
(Srinivas Padmanabhuni and Akash Saurav Das) Looking at the uncertainty and volatility of market conditions today, enterprises are depending on new cutting-edge technology to have an edge over their fierce competitors. At the same time, they try extracting more value from their existing IT investmen
XML tip: I want my XMLTV
(Ed Tittel) I stumbled across XMLTV (aka XML TV) while researching and writing a now-nearly-finished book on the Linux based MythTV environment earlier this year. For those not already in the know, MythTV is one of a handful of alternatives to Microsoft’s Windows Media Center Edition (MCE) that runs
A DSN1COPY improvement for V8 and V7
(Willie Favero) How often are you looking for “A” and accidentally come across “B” which turns out to be more interesting than “A” was anyway? Well, that happens to me all of the time. In fact, it is one of the biggest reasons I have so much trouble finishing anything. Every time I start to research
Avoid These Common Business Rule Implementation Mistakes
(Alexander Kuznetsov) How many times have you seen this scenario: SQL Server developers understand business rules, yet when they try to use triggers and constraints to implement them the database ends up containing some invalid data—which could have dire consequences for a business? Over the years,
A primer on SQL Server database files
(Tim Chapman) A high-performance database system is the product of good database design, both physical and logical. To get the most out of your database system design, you must have a solid understanding of the files the database server uses, and the types of hardware you should deploy these files o
Oracle Tip: Use IEEE 754 FLOAT and DOUBLE datatypes in Oracle 10g
(Scott Stephens) Oracle stores numbers with the NUMBER datatype in an unusual format, with bytes in binary-coded decimal (where the byte hex value 0x99 represents 99 decimal). ANSI standard datatypes such as INTEGER, FLOAT, and DOUBLE are aliases for the NUMBER datatype, with extra restrictions: INT
Getting Hands-On Oracle 10g RAC
If you want to get your hands on Oracle 10g RAC but don’t have the necessary hardware to get started, try the low cost alternatives below. Note: each of these alternatives provides a method to learn the functionality of RAC but not the capacity, scalability or feasibility of a production grade hardw
Managing Hierarchical Data in MySQL
(Mike Hillyer) Most users at one time or another have dealt with hierarchical data in a SQL database and no doubt learned that the management of hierarchical data is not what a relational database is intended for. The tables of a relational database are not hierarchical (like XML), but are simply a
Source Server Helps You Kill Bugs Dead In Visual Studio 2005
(John Robbins) When you look at a minidump or live debugging session while trying to rout out an elusive bug, you need the right contributors to those bits. Access to the correct symbols and source code is critical, whether you’re doing Microsoft .NET or native C++ development. Without them, you’ll