(Neha Tomar) Big SQL, a SQL interface introduced in InfoSphere BigInsights, offers many useful extended data types. In general, a data type defines the set of properties for values being represented, and these properties dictate how the values are treated.
Author: SSWUG Research
Why is the ibdata1 file continuously growing in MySQL?
(Miguel Angel Nieto) We receive this question about the ibdata1 file in MySQL very often in Percona Support.
The User Experience (UX) Of User Interface (UI) Transitions
(Ben Nadel) There’s no doubt that transitions and animations are a powerful part of the User Experience (UX) designer’s toolset. The right transition, at the right speed, can create a natural, organic interaction that leaves the user feeling very comfortable with your application’s interface.
Using the DISPLAY Command, Part 3
(Craig S. Mullins) In this third entry of our series on the DISPLAY command, we take a look at using the DISPLAY command to monitor DB2 utility execution and log information. Part 1 of this series focused on using DISPLAY to monitor details about you database objects; Part 2 focused on using DISPLA
A Smarter Optimizer in DB2 11
(Troy Coleman) One of the challenges of using ERP applications such as Oracle or SAP is that the SQL can’t be rewritten to improve the performance. However, with the optimizer enhancements in DB2 11, predicates can be automatically rewritten as stage 2, making them indexable.
Serialization with Windows 8 Store Apps and VB
(Hannes Du Preez) Any programmer will tell you that serialization is quite tricky in any circumstances. Add to the trickiness of serialization the fact that you have to serialize a Windows Store app, then you have double the trickiness! Today I will show you how to properly serialize Windows Store a
Using Custom Data Attributes To Store JSON Data In ASP.NET MVC
(Bipin Joshi) HTML5 custom data attributes (data-*) are used to store arbitrary pieces of metadata about an element. One way to store such metadata in data-* attributes is to create a separate data-* attribute for each piece of information you wish to store.
Scraping HTML DOM elements using HtmlAgilityPack (HAP) in ASP.NET
(.codeSpy) To parse HTML from a website is otherwise called Screen Scraping. It’s a process to access external website information (the information must be public – public data) and processing it as required. For instance, if we want to get the average ratings of Nokia Lumia 1020 from different webs
SPOOL…APPEND
(Andrew Reid) According to the book I found this in, it was new in Oracle 10 but I tested it on Oracle 11.2.0.2.7. You can SPOOL output to a file like this…
Semantic Technology Drives Agile Business (White Paper)
(Eric Franzon) We are pleased to publish a new white paper for free download, “How Semantic Technology Drives Agile Business,” from Thomas Kelly, a Director in Cognizant’s Enterprise Information Management practice.