The Blas from Pas

Using rsync to backup a directory onto a USB with files which have changed and or been removed. Note for myself: rsync -avrzeh --progres...

In this previous post I showed how to use procedure parameters with DYNAMIC RESULT SETS. http://theblasfrompas.blogspot.com.au/2012/09/sql...

In this example below we use DYNAMIC RESULT SETS with stored procedures. When you configure a procedure using the CREATE PROCEDURE stateme...

Recently published this SQLFire load speed scenario on the VMware vFabric blog http://blogs.vmware.com/vfabric/2012/09/load-8-million-rows...

We just released the vFabirc Data Director 2.0 product with support for Oracle. In fact this supports Oracle 10g as well 11g and will even s...

The example below shows how you can view table / index memory footprint within your SQLFire distrubuted system. 1. Start the servers ensur...

Often I get asked how does a client accessing data in a GemFire region differ to that of a SQLFire table. Both elastic data fabric caches BU...

Note for myself: build.xml extract which ensures we only query data from a specific schema in this case HR schema. DDLUtils has issues wi...

A common scenario or question I get is how do I load data into SQLFire from an existing RDBMS. If you have a simple schema and you wish to l...

I recently setup a SQLFire distributed system by modelling a blueprint from vFabric Application Director. In this simple setup I created a s...

In then latest SQLFire 102 release we have introduced muti-site WAN deployments. The example below shows how quickly we can get this setup w...

The example below shows how we can capure the query plan for SQL running in SQLFire. Although any user can run an explain plan you must conn...

Here are the steps used to create a 3 tier application using Spring travel with a MYSQL database. This is based on the screen shots from the...

VMware vFabric Application Director is a cloud-enabled application provisioning solution that simplifies how to create and standardize app...

VMware vFabric Application Performance Manager sets a new standard for how businesses will manage applications in the cloud. With a focus o...