(Sergey Petrunia) MySQL 5.6 added support for EXPLAIN INSERT/UPDATE/DELETE. MySQL 5.7 made some improvements to EXPLAIN code. Also, 5.7 added support for EXPLAIN FOR CONNECTION, which looks very similar to MariaDB’s SHOW EXPLAIN. I was working on putting EXPLAIN INSERT/UPDATE/DELETE into MariaDB 10.
Author: SSWUG Research
Simple jQuery Color Picker
(Ming_Lu) This simple color picker solved multiple issues I had with other color pickers:
Using InfoSphere Streams with memcached and Redis
(Senthil Nathan and Bugra Gedik, Dr.) InfoSphere Streams is a powerful middleware product that provides a platform for development of streaming applications and their execution in a fast and distributed manner. In a stream processing system, there is often a need to externalize the application-relat
IBM DB2 10.5 with BLU Acceleration vs. Oracle 12c In-Memory Option
(Chris Eaton) In a previous blog we discussed the advantages of BLU Acceleration over Exadata. In this blog I’ll compare and contrast BLU Acceleration with the information currently available on Oracle’s announcement of their future 12c In-Memory Option.
Transaction Logging Details
(Ember Crooks) Transaction log files are one of the core strengths of a DBMS, if you ask me. The ‘D’ in ACID refers to ‘Durability’. What Durability means is that once a transaction is committed, it is not lost, even if the database crashes or the server it is on has to be restarted.
SharePoint 2010: SharePoint security planning
(Steve Wright and Corey Erkes) SharePoint security can become a larger issue as time goes on if you don’t develop and constantly govern an effective security process up front. A breakdown in security can cause unwarranted access to SharePoint configuration options or potential access to content that
Oracle Scheduler External Jobs and Credentials
(Marko Sutic) A few months ago I wrote a blog post – Kill stuck Oracle process from OS using DBMS_SCHEDULER? We had some problems with stuck Oracle processes and I have created external job to kill stuck processes for a quick workaround.
OraSASH visualization
(Marcin Przepiorowski) I started working on that project 2 years ago and at that stage I created a JavaScript code to display real time graphs and parse JSON code. The backend providing JSON data from Oracle Database was based on PHP and I didn’t like that solution as it required to much configurati
Reusing and Extending ADF BC Entities from Common Model
(Andrejus Baranovskis) This post is about ADF architecture and better application structuring with EO reuse from common model. I describe how to implement additional requirements to common model in extended ADF BC Entities. Great power of ADF framework – reusability.
In-app File Management Changes in Windows 8.1 and Visual Studio 2013
(Hannes Du Preez) Welcome to today’s article! Today I have an exciting task (and the pleasure) of covering the new File Management objects in Windows 8.1 and Visual Studio 2013. A lot of new funky features have finally been added and it will surely make your file management tasks much easier! Let me