Blogs

Interview with the authors of "Pentaho 5.0 Reporting by example"

 
 
Pentaho Reporting by ExampleMariano 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..

 

Avoiding errors concatenating fields with numerical values in SQL Server

 

concatenate stringsThe 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.

Tips for UPSERT or update using insert in SQL Server

 

Merge SQL

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.

Listagg: New Oracle 11.2 function to summarize and aggregate strings

 
 

Oracle 11g LISTAGG Function

In a LinkedIn debate about how to update from a select with summarized registers in SQL Server, Sergio Romero has shared an interesting tip about new summarize functions on Oracle 11g R2.

How to do an update from a select with summarized registers in SQLServer

 

Update from summarized registerA 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..

The Clouds Economy

 

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. 

How Business Analysis for Business Intelligence (BA4BI) Creates Strategic Value

 
This webinar clearly presents a case to consider BA4BI as a somewhat special discipline, differing from classical application development tracks. It also presents compelling arguments for analysts to go further than gathering requirements. The goal is to initiate or improve the strategic dialogue in the organization and by doing so improve the strategy process. How do you make it happen? Spend 30 minutes on line for inspiration!

SEO Services Company

 

Search engine Optimization (SEO) techniques are very important in order for your website to be seen and picked up by search engines. If you want your website to be listed in the top page of the search results then your website has to be ranked very high and there are lists of factors that generally influence the website ranking.

Web Hosting Tips That Can Work For Anyone

 

Finding a solid web hosting provider is of paramount importance for anyone with a website. Don't disappoint your visitors with the downtime that comes from having an unreliable host. These great ideas will help you sort through the wide variety of web hosts and make a decision that you will be happy with.

Do I need to visit college to learn SPSS?

 

One of the largest useful resources today, most specially for those students who take topics in statistics, is the Record Package for Social Sciences or simply SPSS. SPSS is essentially a software specifically used to handle data from any types of researches such as dissertation and dissertations. Merely so you know, data examination is equally significant as data assortment and interpretation. Meanwhile, analyzing the information can be much more critical for with only one mistake about it can totally ruin the outcome of the specific research.

Syndicate content