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.

Cloud and public sectors


If all patients of a metropolitan region such as Barcelona or Madrid or London, or a region like Languedoc Roussillon or Andalusia, had introduced with their medical records digitalized, or even better with Relational databases with SQL for example, which supports many data with many records hosted on servers accessible remotely on "Cloud computing", it would allow health physicians to access data from any PC or "SmartPhone" with an interface SW, through the pick lists that are very intuitive and user Friendly. In addition have an internal Chatter (like salesfoce has), allowing asynchronous communication for consultation among several specialists to achieve a flexible and rapid diagnosis.

Export data from a SQL Server table


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

Differences between Oracle, SQL Server, DB2, MySQL and other ..


The operation of databases from different manufacturers is similar, but there are many differences between them, even at level of SQL syntax.

For example, if you knows Oracle, and one day you have to do a date conversion with MySQL, you will wonder the following:

- How to do a TO_DATE () / TO_CHAR () with MySQL? 

I open this blog entry to discuss different ways of doing things with each database type. 

Here I link the SQL Tips Bristle Software , which explains quite well how to do some things with MySQL, Oracle and SQL Server, and I find especially useful the chapter on differences between Oracle and SQL Server

The Oracle listener


In order to access to the same database where are you working outside the database server you must activate the service called listener, it has to be listening.

It can happens that the database is properly raised and can not connect from other servers, which are also set correctly (correct TNSNAMES, etc.).. 

In these cases could be that the listener has a problem, or simply has not been initiated.

To Check the status, start or stop it is very simple. Just open a command line session (console terminal, etc..) with the user that has installed the database, and run the lsnrctl command with the following parameters:

  • Check your state:
      > lsnrctl status

  • Stop the listener:
      > lsnrctl stop

  • Start the listener:
      > lsnrctl start

Keep in mind that when you stop the listener, the connections that are already in the database won't be closed, so a short stop is not very traumatic, only connections trying to enter while the listener is stopped are rejected, should not affect anyone who already has an opened session.

Login with SQLPlus as a DBA without entering password


If you have the system user who installed the database you can enter SQL Plus as DBA user, without entering a password as follows:

1. Enters the system with this user. 
2. From the command line, go into SQLPlus typing:

> sqlplus "/as sysdba"

If you need to enter using this way because you forgot the password of a user, you can easily change it: 

SQL> alter user user_name identified by new_password;

It can be more than one Database installed on the server, so you have to validate that the environment variables of the Oracle's user are pointing to your database.

For verifying that you has login into the correct database you can execute this statement: 

SQL> select name from v$database; 
Syndicate content