SQL08: Create a conditioned table using the data dictionary of SQL Server

Sometimes we need to check the existence of a table in a script or scheduled task to record error logs, first executions etc ... 

Let us take an example, a package of integration services that normally distribute or run there where we go and that leaves traces in a custom table that is not the default for loading logs. We could always include a performance task or sql script, run right or wrong, as the first to run on the package and then continue. Being purists this just is not quite careful

Oracle RAC One Node

In Oracle 11g release 2, Oracle introduced a new product Oracle Real Application Clusters One Node (Oracle RAC One Node)

This product is an Oracle RAC' s instance but executed in one single node. May be run on different physical servers, not only one (this is common) but a database instance is running only on the same node  simultaneously  (* but we'll see later that this is not completely true).

 

RHIPE: Using Hadoop to analyze very large data with R

Hadoop is an Apache project that provides an environment that supports the management of large amounts of data. Such systems are typically used to support the large amount of information generated by great social networks, especially when relational databases are beginning to have problems of scalability, or the cost of growth is too high.

Open Data at Barcelona Web Congress

At the Web Congress in Barcelona, ​​I attended a workshop on Open Data in wich Martín Alvarez Espinar, W3C Spanish Office's head, and Jordi Graells i Costa, coordinator of content and innovation of the Generalitat de Catalunya, explained what is the international initiative Open Data, and how it is developed in concrete projects in some communities of Spain, as Asturias and Catalonia.

Results of the last Forrester Wave about Enterprise Business Intelligence Platforms

In his blog Boris Evelson explains the more relevant results of the las Forrester Wave about Enterprise Business Intelligence Platforms.

These are the last movements, extracted from it:

  1. IBM Cognos, SAP BusinessObjects, Oracle, and SAS continue to lead the pack.
  2. Information Builders, Microsoft, and MicroStrategy move into the Leaders category.
  3. TIBCO Spotfire and Actuate maintain their Strong Performer status.
  4. QlikTech and Panorama Software move into the Strong Performer category.