(Marcin Przepiorowski) I just noticed last week that there is a new patch for Enterprise Manager and it is enabling AWR Warehouse feature. There is a note ID 1901202.1 which describe bundle patch for OEM 12c release 4.
Other News
Backbone.js at a Glance
(Gil Fink) Backbone.js is a popular JavaScript framework used in Single Page Applications. In this article we will take a look at Backbone.js and how you can use some of its features.
Accessing OLE and COM Objects from SQL Server using OLE Automation Stored Procedures
(Derek Colley) You wish to access OLE or COM objects, such as file system objects (files, folders) and their properties directly from SQL Server. This might be, for example, to load data automatically from a raw data source; to check for the existence of a directory before exporting data; or to chec
MySQL upgrade best practices
(Muhammad Irfan) MySQL upgrades are necessary tasks and we field a variety of questions here at Percona Support regarding MySQL upgrade best practices. This post highlights recommended ways to upgrade MySQL in different scenarios.
Undo Algorithm for Java Swing
(Edison Heng) I am going to show how to perform undo algorithm on your Java Swing application.
SOA Suite 12c: Invoke Enterprise Scheduler Service from a BPEL process to submit a job request
(Lucas Jellema) The Fusion Middleware 12.1.3 platform contains the ESS or Enterprise Scheduler Service. This service can be used as an asynchronous, schedule based job orchestrator. It can execute jobs that are Operating System jobs, Java calls (local Java or EJB), PL/SQL calls, and Web Service call
Managing Application Performance… from a database perspective.
(Craig S. Mullins) Applications that access databases are only as good as the performance they achieve. And every user wants their software to run as fast as possible. As such, performance tuning and management is one of the biggest demands on the DBA’s time. When asked what is the single most impor
What to do before leaving and after returning from vacation
Hello, this is Laura Lee Rose. I am a speaker and author. I am an expert in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they don’t have time to learn new technology or train their...
Compressing Open Row Groups
(Richard_RP) If you’re using, or at least read up on Clustered Columnstore Indexes then you’ll know that the data is stored in segments. You’ll also know that there are 4 states the segments can be in at any one time:
SYS.DM_EXEC_REQUESTS Changes Between Versions Of SQL Server
(Shaun J Stuart) I was recently doing some work with a backup verification routine that is meant to run on various versions of SQL Server and came across some variations in the way the RESTORE VERIFYONLY command is reported by sys.dm_exec_requests between SQL Server 2005, 2008 R2, and 2012. I haven’
