(Frits Hoogland) Last week I’ve gotten a question on how storage indexes (SI) behave when the table for which the SI is holding data is changed. Based on logical reasoning, it can be two things: the SI is invalidated because the data it’s holding is changed, or the SI is updated to reflect the chang
Other News
ADF 12c (12.1.3) Line Chart Overview Feature
(Andrejus Baranovskis) ADF 12c (12.1.3) is shipped with completely rewritten DVT components, there are no graphs anymore – they are called charts now. But there are much more, besides only a name change. Previous DVT components are still running fine, but JDeveloper wizards are not supporting them a
Integrate data with SoftLayer Object Storage by using IBM InfoSphere DataStage
(Jeff J. Li and Suraj R Patel) In this article, learn how the Hierarchical Data stage in IBM InfoSphere DataStage interacts with SoftLayer Object Storage by using the Representational State Transfer (REST) API. The REST step in the Hierarchical Data stage invokes REST web services with support for v
IE XML5633 Error when using jQuery.parseXML()
(Zachary Gardner) I saw something very interesting today while debugging an issue that a QA reported. They learn as part of their training to always keep Dev Tool open, and create a bug when a console error comes up. The bug I was looking at was created when a QA saw the following:
Understanding Hugepages in Oracle Database
(David Fitzjarrell) Recently I’ve noticed the occasional thread in Oracle newsgroups and lists asking about hugepages support in Linux, including ‘best practices’ for hugepages configuration. This information is out on the ‘world-wide web’ in various places; I’d rather put a lot of that information
Fixing Broken SSRS Subscriptions
(Shaun J Stuart) SQL Server Reporting Services provides functionality to automatically generate a report on a recurring basis. These reports can then be emailed or written to a file. The method for doing this is called a subscription. It’s common for a developer to create a report and then create a
The SQL of Membership: Equivalence Classes & Cliques
(Joe Celko) It is awkward to do ‘Graph databases’ in SQL to explore the sort of relationships and memberships in social networks because equivalence relations are classes (a set of sets) rather than sets. However one can explore graphs in SQL if the relationship has all three of the mathematical pr
SQL SERVER – How to Format and Refactor Your SQL Code Directly in SSMS and Visual Studio
(Pinal Dave) This article shows how to use ApexSQL Refactor,a free SQL code formatting and refactoring tool. You can download ApexSQL Refactor, and explore it through the article.
Cool SQL Server Management Studio editing trick
(Steve Endow) I’ve been using SQL Server Management studio since long before it was called Management Studio, but I regularly stumble across some new feature or shortcut that I never knew existed.
How to terminate a DB2 backup
(Jack Vamvas) Question: How can I terminate a DB2 backup ? Using db2 list utilities I can see a BACKUP in progress , but how can I terminate the BACKUP from within DB2?