(Matthias Farwick and Michael Hafner) Five years after the introduction of SOAP 1.0, XML parsing is still the main bottleneck in web service performance. In search of components for a high performance web service security solution, we have executed benchmarks for various XML parsers in Java and C. T
Author: SSWUG Research
IBM System Storage N series Best Practice Guidelines for Oracle
(Alex Osuna, Eva Ho, Eric Barrett, Bikash R. Choudhury, Bruce Clarke, Ed Hsu, Blaine McFadden and Tushar Patel) This IBM Redbooks publication describes best practice guidelines for running Oracle databases on IBM System Storage N series products with system platforms such as Solaris, HP/UX, AIX, L
MySQL Table Checksum 1.1.0 released
(Xaprb) MySQL Table Checksum 1.1.0 adds many improvements, but the most important is a new way to ensure slaves have the same data as their master. Instead of checksumming the slave and the master, it can now insert the checksum results directly on the master via an INSERT.. SELECT statement. This s
Defining SQL Server constraints with TSQL
(Tim Chapman) All competent DBAs and developers should possess the ability to logically define constraints in the database, as well as define those constraints via TSQL code. This article explains how to define constraints with TSQL and explores different ways to define these constraints via TSQL.
ASP.Net : AutoList
(Sanjay Kumar) This small web application has following features: –Auto suggest list box [AutoList.js] –Auto select text. –Scrolling list item either one by one or on the basis of defined page size. –Multicolor list item. –Getting result in the xml form directly from SQL Server using
Migrating data from CICS to XML is a major SOA challenge
(Ed Tittel) When it comes to a legacy application with a real legacy to protect—namely, billions of records’ worth of important information of all kinds—IBM’s Customer Information Control System, better known as CICS (usually pronounced “kicks” for those not already in the know) is something of a no
IDUG recap – Day 4, Wednesday, May 9, 2007
(Willie Favero) Let’s get the important stuff out of the way immediately; session attendance. Of all the sessions held on Tuesday, the most popular based on the number of individuals that attended each session were: • F6 – Put a Smile on Your DBA’s Face – Performance for the Developer (and You Know
Oracle Extended RAC: Stretching your RAC to the limit
(Tarry Singh) Network cards are getting faster, internet connections are increasingly becoming faster. There are even talks of 1Gbps internet and faster coming available. Oracle RAC can benefit from such developments, but did you know that you could stretch your RAC geographically (well almost) if y
The issue with FillSchema
(Reggie Burnett) Connector/Net’s MySqlDataAdapter class has a method named FillSchema. This method is intended to populate the metadata for a given query without actually returning any of the data from the query. The only syntax that MySQL has to help with this is SQL_SELECT_LIMIT which limits the
Testing for DW/BI – Current State and a Peep into the Future
(Arun Sundararaman) Just as with any other software application involving different technologies (such as the mainframe, Java or Microsoft), testing is a very crucial phase in the software development lifecycle for data warehouse/ business intelligence (DW/BI) projects. Testing for DW/BI carries uni