(Leo Hsu and Regina Obe) This is about improvements to GIST indexes that I hope to see in PostgreSQL 9.2. One is a patch for possible inclusion in PostgreSQL 9.2 called SP-GiST, Space-Partitioned GiST created by Teodor Sigaev and Oleg Bartunov whose basic technique is described in SP-GiST: An Extens
Other News
Visual Studio Find & Replace for XSLT using RegEx
(Sathish.Krishnan) Recently for one of our BizTalk migration engagement, we had to deal with BizTalk transformation using custom XSLT. In this case the business (transformation) logic remained the same, but the destination schema was modified to have ‘xml-elements’ instead of ‘xml-attributes’.
Writing xSV (eg csv) files from within the Oracle database using Java
(Simon Greener) My EXPORTER package + Java code has a function called WriteDelimitedTextfile that can be used to export any SQL SELECT statement to disk using Oracle database’s DBMS_JOB or DBMS_SCHEDULER.
Visual Studio IDE Navigator
Some software developers like to have many code windows and tool windows open at the same time, whilst others prefer to minimise the number, as it can be difficult to find a desired window. The Visual Studio IDE Navigator attempts to simplify navigation.
APAR Friday: UNION/UNOIN ALL, DB2 9 & DB2 10, and a HIPER
(Willie Favero) The subject line says it all; well, almost all…
SQL SERVER – SQL Backup and FTP – A Quick and Handy Tool
(Pinal Dave) I have used this tool extensively since 2009 at numerous occasion and found it to be very impressive. What separates it from the crowd the most – it is it’s apparent simplicity and speed. When I install SQLBackupAndFTP and configure backups – all in 1 or 2 minutes, my clients are always
XML Versus JSON
(michaelippersiel) When XML was unveiled in the selection globe, it turned out deemed brilliant in it’s straightforwardness. A word based mostly standard protocol that will do-it-yourself-illustrate your data that it contained, and an chance to hold ordered data. Speedily followed by software engine
Understanding Wait Event Time Patterns
(Craig Shallahamer) If the average db file sequential read is 20ms, it is likely the typical value is something more like 5ms. If you look at your system’s wait event time distributions, you will see (details below) that an average Oracle wait event time is not likely to be the typical wait time and
More ‘cool’ data migration strategies!
(Jeyabarathi(JB) Chakrapani) .In my previous article, I talked about how to use the DB2 HADR feature as a tool to migrate data. Here is another cool method I discovered (entirely by accident) during one of my hair tearing migration sessions with the application team. I must say in all fairness the a
Uh, uh… extending mysqlnd: monitoring and statement redirection
(Ulf Wendel) Uh, uh… about a year ago Mayflower OpenSource Labs released the mysqlnd user handler plugin (PECL/mysqlnd_uh). The extension lets you extend and replace mysqlnd internal function calls with PHP.