This time we interviewed Matt Mayevsky to explain to us in their own words what their Cloud Economics, objectives and motivations, the difficulties found along the way, and where it is headed 'The Clouds Economy' project ..

Business Intelligence gets more traction by the day: with offerings on the Cloud and mobile devices getting wider acceptance from the market.

MicroStrategy Reporting Suite is a complete BI platform that covers all data analysis needs that a company or public entity may have. Dashboards, Scorecards, KPIs, and all kinds of reports can be explored and manipulated in the desktop application, web interface, mobile devices or cloud..

Mariano Garcia and Dario Bernabeu recently announced on his blog of Dataprix the publication of his new book 'Pentaho Reporting 5.0 by Example: Beginner's Guide'.

Knowing both authors and their previous work, we are confident on the utility of that book for anyone who wants to work with Pentaho Report Designer, but we'd rather interview them to explain it themselves..

The operator to concatenate in SQL Server is '+', but this operator is also used to add values.

Being the same operator for both, the query analyzer makes a concatenation or a sum based on the type of data fields being treated. If the fields are of 'string' type, the operator concatenate, and if it has numeric fields, two integers, for example, it add the two values.

A very powerful way to do a table's update in a SQL Server database is to link it with another table with a join, and updating the fields of everyone of its registers using the field's values of the registers linked with the another one. This technique had been discussed in the forum post Update with join or update from select in SQL Server..

In many cases, especially in ETL processes or data loading to a data warehouse, for example, we would rather use a single sentence or the checking of the existence of a register and its updating. If register doesn't exist we would want to insert it. This combination has been nicknamed UPSERT, although in SQL there is a specific statement to make it, which is MERGE.

The Clouds Economy is a book presenting the multi-dimensional perspective of Cloud Computing (CC): economic, technological and sociological. The publication explains what and for whom CC is, how and why one should take advantage of Cloud solutions. In addition, the book contains the description of the CC evolution from distant yesterday, through deep today, to distant tomorrow. 

To import and export data from SQL Server,  Microsoft provides the tool bpc, which operates by command line. Although it would be appreciated if SQL Server Management Studio would provide some