(Rohit Kalhans) MySQL replication slave features a powerful capability of ignoring conflicts like duplicate key error, key not found errors etc. while applying row events. This is exceptionally useful while doing row based replication(RBR) from the master when the slave already contains some data
Author: SSWUG Research
Partition Info in V$SESSION_LONGOPS
(Matthias Rogel) Oracle’s advanced partitioning has some deficiencies. For example, partition info is missing in V$SESSION_LONGOPS for scan-operations ( full table scans, full index scans ).
Performance Tuning for XML-based OLTP Systems (Temenos T24)
(Henrik Loeser) From time to time my colleagues and I get contacted on how to set up and tune DB2 for use with Temenos T24. The latter is a core banking system and in use worldwide. And it uses XML as internal data storage format which makes it an ideal fit for DB2 pureXML (both on z/OS and on Linux
::xml madness
(Joel Jacobson) Nobody likes XML, except masochists and Microsoft consultants who charge by the hour.
Array Intersect Assoc and Array Intersect Uassoc Function in PHP
(Vinod Kumar) In this article I will explain the two important functions of array, Array_intersect_assoc() and Array_intersect_uassoc() in PHP.
Utilities for building JSON
(Andrew Dunstan) As we get more experience in using JSON in Postgres we get a better idea of what we need to make its use simple and effective. This work is the result of some such experience.
SQL SERVER – Adding Column Defaulting to Current Datetime in Table
(Pinal Dave) Presenting a technical session is a greatest experience one can have and I enjoy doing the same. While I write this blog post, I am presenting at Great Indian Developer Summit in India. The event is a grand success and I am having a great time at this event.
Sharing Data Between VO Instances in ADF BC
(Andrejus Baranovskis) Probably you already noticed that by default data is shared between VO instances (or even separate VO’s) based on the same EO. Newly inserted row into one instance becomes instantly visible from another VO instance.
How to Create a Web Service Using Java, Eclipse, and Tomcat
(Mitch Pronschinske) This tutorial runs through a method for building a Java web service in Eclipse using Apache Tomcat and Apache Axis.
Are DBAs Still Needed?
(Troy Coleman) Since IBM unveiled its big data strategy, there’s been an interesting response. Some have focused on the role of the DBA, wondering if advancements like IBM Data Analytics Accelerator for z/OS (IDAA) and Netezza, which are designed to eliminate concerns over index design when storing