(Hannes DuPreez) For those few of you who frequently read my articles, first of all, thanks, and second of all, you may find it weird that I write yet another article about databases in Windows 8.1; but, as you will see, this technique works entirely differently than in the previous articles.
Other News
DBI pureFeat V6.1 for IBM DB2 LUW Improves Visibility into Database Performance Issues
DBI Software has introduced pureFeat V6.1 Performance Management Suite for IBM DB2 LUW which adds two key new capabilities for Stored Procedure Visibility and insight into Current Activity Functions.
ARCAD Software Takes On Database Modernization
(Dan Burger) If you’ve seen IBM’s Redbook on modernization for i-centric customers, it’s clear the direction Big Blue recommends includes the DB2 for i database as an integral part of the modernization process. In application-first environments, which dominate in IBM i shops, database modernization
HTML5: Use of MathML – A Better Way to Present Mathematical Notation
(Prava-MFS) The word MathML represents Mathematical Markup Language, which means a language which is designed to present and capture mathematics for Web.
Creating an agent-based backup system for IBM PureApplication System
(Katherine J. Lamendola and Jeffrey T. Klier) This article shows you how to use IBM Endpoint Manager to deploy and configure IBM Tivoli Storage Manager backup agents on virtual machines that are running in an IBM PureApplication System cloud. Distributing backup agents to virtual machines is essenti
Best method for Critical Section management in C++
(Asim Goheer) When it comes down to using critical sections in your C++ code you have pretty much standard options. Simply call “EnterCriticalSection” at the start of your function and call “LeaveCriticalSection” at the end of your function.
MySQL Group Replication – Transaction life cycle explained
(Nuno Carvalho) The multi master plugin for MySQL is here. MySQL Group Replication provides virtually synchronous updates on any node in a group of MySQL servers, with conflict handling and automatic group membership management and failure detection.
Structured XML output from Oracle SQL query
(Ilmar Kerm) Got an interesting question today: There are tables TABLE1, TABLE2 and a junction table that joins them called JUNCTABLE. Need the following output as XML
Check Constraints
(Michael McLaughlin) Oracle Database 12c introduces a SEARCH_CONDITION_VC column to the CDB_, DBA_, ALL_, and USER_CONSTRAINTS views. The SEARCH_CONDITION_VC column is a VARCHAR2 data type equivalent to the search condition in the LONG data type SEARCH_CONDITION column.
ORA-20104: create_collection_from_query ParseErr:ORA-00918: column ambiguously defined
(Flavio Casetta) If you are wondering why you are getting this error message after following the example in the documentation describing procedure CREATE_COLLECTION_FROM_QUERYB2 in the APEX_COLLECTION API, the quick answer is that the sample code is flawed.