(Uche Ogbuji) You might have run into this scenario if you work with XML files that contain sensitive data: You run into a problem, perhaps a bug, with your favorite XML processing tool. You need to send the vendor an example of a file that triggers the bug. You can’t just send random XML files beca
Author: SSWUG Research
Leverage the Spatial Extender: Creating an automatically maintained spatial table from latitude-longitude column data (DB2 Edition)
(Robert Uleman) Whether derived from address information, acquired by GPS devices, or otherwise generated, many databases contain geographic coordinates of point locations as separate numeric columns in a table. In this form, however, they are not usable for detecting spatial relationships by using
Query Parameters and Information Handling with Databases
(Jim Keogh) In the preceding example, the value of the search criterion was inserted into the WHERE clause of the query. In the real world, however, the visitor to your web site usually enters the search value into a web form. Therefore, you need to have a placeholder for the search criterion in the
MySQL 5.1 New Features: MySQL Events
(Peter Gulutzan) Andrey Hristov added “Events” for MySQL version 5.1 when he was working on his master’s thesis for the University of Applied Sciences in Stuttgart. We liked the feature a lot, and now Andrey works for MySQL. An inspiring story, eh? And now MySQL 5.1 is getting stabler, it’s “beta” i
Securing services: Locking down your SOA
(Daniel Rubio) For the many benefits an SOA brings to an organization, like having the capability to mix and match services with many different providers and suppliers or granting access to data in a platform-independent manner, there are many implementation details that are often overlooked when de
SQL Server 2005 XML Support, Exception Handling, and More
(John Papa) SQL Server 2005 includes several important improvements to the Transact-SQL (T-SQL) language. One added feature is a new kind of trigger that fires when data definition language (DDL) statements run. DDL triggers are useful when tracking or securing the creation and modification of data
Oracle/PLSQL: Foreign Keys
A foreign key means that values in one table must also appear in another table.
Using SQLite in Python
(Peyton McCullough) SQLite is a small C library that implements a self-contained SQL database engine. This article examines pysqlite, one of a number of libraries in Python, that is used as an interface with SQLite.
WebSphere Message Broker V6, Best Practices Guide: Bullet Proofing Message Flows
(Geert Van de Putte and Dean Keister) If you do not know what you are trying to accomplish, the task is even harder to do. If you do not know how to do the task, it is even more difficult. How many times have you started to develop a solution before understanding the requirements — input data format
SQL Server 2005 SP1 Due in a Couple Weeks
(Alex Woodie) Microsoft’s new database, SQL Server 2005, has been on the shelves for just a couple of months, but by the end of April, the first service pack should be available. SQL Server 2005 Service Pack 1 (SP1) will add support for mirroring, a crucial ingredient in high availability environmen