Archive › General @en

APEX 5: Showing custom success message from Dynamic Action (DA) on Universal Theme

I needed to show a success message after ending a Dynamic Action and I wanted this message to be with the same format as success messages from page processes. Since this is not a standard feature of Oracle APEX, you can do the following trick if you’re using Universal Theme: Create a JavaScript function which […]

Comments ( 0 )

MicroStrategy 10 Hacks: How to fire selector change via Button for any presentation mode

In order to provide usability to your Dashboards, you can let users the possibility to click somewhere and apply certain filter. For instance, you may want to filter a region by clicking a Button instead of scrolling inside a select list for some particular values: 1) MicroStrategy: Create a “Select List” Selector 2) MicroStrategy: Select any panel or […]

Comments ( 0 )

MicroStrategy 10 hacks: Loading jQuery under new Presentation Mode

First of all I’d like to thank Bryan Brandow because this post is inspired on his various posts about this subject: Since MicroStrategy 10 was out last year 2015, I’ve been trying to achieve some jQuery hacks in order to provide more usability to our dashboards. The first problem I faced when migrating to MicroStrategy […]

Comments ( 1 )

Answering freelance fears from experience

I usually write technical notes on my blog but, in this case, I want to write some literature about my experience of being freelance, focusing on my initial fears and how they got defeated. I’ve been working in a freelance basis since 2009, when I created “Relational” which is my freelance firm. At the beginning […]

Comments ( 0 )

Deleting unused indexes – SQL Server

It’s a good practice to periodically check usage of indexes in case they are not really used by users. We must be aware some indexes cost to maintain and affects our database performance when inserting data. The following query allows you to identify those indexes which are not used (no user seeks, scans nor lookups) […]

Comments ( 0 )

APEX 5.0: Change export calendar links position

After trying new amazing APEX 5.0 Calendar, even though I’ve found it great, I really think further work is needed in order to provide more options for developers. We’re unable to change inner HTML code because we’re don’t have Templates associated to this new component, and we’re even unable to define different position for its […]

Comments ( 3 )

Automate Talend backup export scripts with SVN and Commandline

It’s useful to periodically export a backup copy of your Talend item scripts when you’re using SVN, so here you have an script to export all Project items: Note: This script only works for Talend Integration Suite 5+ and Unix environments. Note2: Requires Commandline installation


Comments ( 0 )

Enable VNC connection for each O.S. user at boot – Ubuntu

Many times you need to enable VNC connections in your unix server by default at boot time. In RHEL it’s quite easy but in Ubuntu it’s quite tricky, that’s why I’m pulishing this entry. First of all, we install vncserver:

and let’s edit ~/.vnc/xstartup for each of our O.S. users with the following script: […]

Comments ( 0 )

Move SQL Server 2008 datafile to another location

In order to reallocate datafiles to other locations, for instance in case you need to move mdf’s to a faster HDD, you must take following steps: 1) Take affeccted DB offline :

2) Physically move ldf or mdf files to new location 3) Execute, for each datafile:

4) Bring database online

At anytime, […]

Comments ( 0 )