[quote]What's the cost of downtime to your business? $100,000 per hour, $1,000,000 or more? The recent volcanic ash that has grounded European flights is estimated to be costing the airlines $200M a day. In the IT world, High Availability (HA) architectures allow for disaster recovery as well as uninterrupted business continuity during system failure...[/quote]

https://bigdatamatters.com/bigdatamatters/2010/04/high-availability-wit…

For those database administrators who have to deal with such a Dynamics Ax 2009 and his henchmen (developers, consultants, etc. )  I leave here a couple of things you should know (or I should say) when we join ax2009 and sql server 2008. Sometimes you can point to the database as a source of the problem but not always. Some requirements to consider for installing Ax2009 are that the user you want access to the system should be user and DOMAIN in sql server role must be a member of securityadmin dbcreator and to create the new database from Ax installer. Once installed (or during the installation process) the problem with the database that we can find include: 

In a previous blog entry ( OpenSource Databases. Why did we choose for our project Mysql?), talked about the Open Source databases such as interesting and reliable option for the development of business intelligence projects. We saw some different products and compare between them.

But there are other alternatives (with limitations in most cases) that allow us to start working with "big" of a free. Express versions are called. Versions are designed for small systems, for development work or training, for prototyping or evaluation, that allow us to "initiation" with the great managers of relational databases. In most cases, the product is offered fully functional, but with limitations (the maximum size of the database, use Ram memory or processors of the machine, etc). There may also be features that are not active in these versions (such as partitioning version  of Oracle Express).  I leave the link to the manufacturers' web sites where you can download these versions:

Following a series of needs I have decided to develop for the group eglu and, of course, to all of you, a plugin that allows you to use jQuery FlexiGrid since Pentaho-CDF.
Not if you permit to happen, my especially if they need a list with a number of features such as filtering, sorting, paging, sorting, selection of visible columns, resize, etc.. Without doubt, this is what jQuery provides FlexiGrid 2.0. The theme is to make it work in Pentaho is somewhat cumbersome, this was my trigger. Without further ado I attached a video showing the functionality of the plugin. In a few days annexed to the plugin, source, demos and documentation so they can try and give me feedback. 

Today we have consulted our position in the Alexia ranking,  and we have been pleasantly surprised to find that this March we are located at or even above doorways as TDWI o BeyeNETWORK  are undisputed global benchmark .

As expected, the first BI tools adapted to the new iPad of Apple are appearing. Nothing like a dashboard application to exploit the Multitouch screen possibilities of this device.

Prelytis is the company that has developed Prelytis LiveDashBoard, the first Business Intelligence software compatible with the new Apple Tablet. This is a dashboarding tool, and 2.0 oriented, with collaborative features, and remarkable for their efforts in terms of adaptation to mobile devices.

SAP TechED presented in Vienna on Gravity product prototype, a BPM solution that works on the collaborative environment provided by Google Wave.

This product allows Business Process desing collaboratively, building communication facilities provided by the environment Google Wave. Obviously it works for web, and can also be used from mobile devices like an iPhone.

This video shows how to simulate a situation of merger of two companies in which they must redefine many business processess the highest level.

As many have noticed, we changed Dataprix logo.

Although the symbol of the head with the database during the previous logo reflected fairly well the spirit of Dataprix, and the relationship between data and knowledge, we believe it necessary to create a logo more 'professional', which will be the basis corporate image Dataprix.

Our primary corporate color is still blue, so the change on the web has not noticed too. We have changed the symbol for a 3D database, and D-shaped, to keep referring to the data, and lose the reference to knowledge that gave us the figure of a blue head, but you can not have everything in life ;).

In addition, we've heard from somewhere that may be better to simplify the meaning of the symbol to convey a clearer picture. For people not as technological areas, which need not recognize the symbol of a database could also be difficult to identify. On occasion I have come to discuss that on seeing the logo Dataprix seemed he might have something to do with a headache, or Bayer aspirin ..

A simple way to export data from a query, table, etc.. of an oracle database to a flat file is to use the SPOOL command in SQLPlus. This would not need to rely on visual aids, which are not always available or do not always work as we want. Also you can use the Oracle format functions in the same SELECT statement that generated the data already in the format we need.

If, for example, we want to retrieve some data from all records in a table of customers sorted by date of discharge, simply open a SQLPlus session and run this series of commands: 

SQL> SET HEADING OFF
SQL> SET FEEDBACK OFF
SQL> SPOOL C:\datos_de_clientes.txt
SQL> SELECT 'Cliente ' || CLI_NOMBRE || ', ' || CLI_NIF || '. Fecha alta: ' || TO_CHAR(CLI_FECHAALTA,'YYYY-MM-DD')
FROM TABLA_CLIENTES
ORDER BY CLI_FECHAALTA DESC;
SQL> SPOOL OFF;
SQL> SET FEEDBACK ON
SQL> SET HEADING ON

The first lines hide the headers that contain the field name, and do not concern us because we only want the data. Spool directs the output of data to the file 'datos_de_clientes.txt' on the C drive on the local machine.