Category Archives: Oracle

SQL Server: ranking your data

Posted on June 7, 2016 by mauriciorpp

This is the kind of query that kills some servers – ranking. It’s a bit hard to make programmers understand how important the performance of their code can have a big impact on server speed – they all seems to … Continue reading →

Posted in BI, MongoDB, MySQL, Oracle, SQLServer | Tagged , , , , , | Leave a comment

Talk about MS-SQL, Oracle, NoSQL and Babylonian accounting tablets

Posted on October 5, 2014 by mauriciorpp

Looking at the past can teach us a lot of things. This is a great way to know more about the things you like. And this is a great article about some fundamental characteristics of the major database systems today. … Continue reading →

Posted in MongoDB, MySQL, Oracle, SQLServer | Tagged , , | Leave a comment

Oracle: Error ORA-00955 name is already used by an existing object

Posted on September 15, 2014 by mauriciorpp

Sometimes things just won’t work as expected. You know, programming has its quirks and the like. Normally this error alone would mean you are creating some object with a name that is already in use. But what if you just … Continue reading →

Posted in Oracle | Tagged , , , , , | Leave a comment

Virtualizing your databases guide

Posted on August 6, 2014 by mauriciorpp

Recently the guys at SQLServerCentral published a great article about SQL Server virtualization. But it is usefull for SQL Server, Oracle or any other DB technology that must run “on the cloud”. So here is the link to it: http://www.sqlservercentral.com/articles/Stairway+Series/112555/ … Continue reading →

Posted in Cloud, MongoDB, MySQL, Oracle, SQLServer, VMware | Tagged , , | Leave a comment

Oracle: view Error Log and connection issues.

Posted on May 5, 2014 by mauriciorpp

Usually I try not to mess with Oracle, and in return it tries not to mess with me. Relationships are difficult when both parties have pretty strong characters. But today Oracle was angry at me, and I needed to do … Continue reading →

Posted in Linux, Oracle | Tagged , , , , | Leave a comment

Oracle: save output to file

Posted on January 31, 2013 by mauriciorpp

Ok, so I’ve been on a streak to NOT talk about Oracle for a little while now. Actually I tried to avoid it, but as this software is more.. hmm… complex than MS-SQL we must talk about it a lot … Continue reading →

Posted in Linux, Oracle | Tagged , , | Leave a comment

Disaster Recovery: Unteachable Techniques

Posted on December 13, 2012 by mauriciorpp

Today I’ll link a great article about Disaster Recovery: http://www.simple-talk.com/sysadmin/general/unteachable-disaster-recovery-techniques/ And that’s it. It is too big to quote here, but it is too good to miss the oportunity of sharing with you. And because this subject is related to ALL … Continue reading →

Posted in Linux, MongoDB, Oracle, SQLServer, VMware, Windows | Tagged , | Leave a comment

Oracle world: Installing the client on Windows 7 – part 1

Posted on August 22, 2012 by mauriciorpp

Well, this blog is not only about MS SQL Server, but about Oracle and MongoDB too. As I need to set-up a new environment to manage a small number of Oracle databases, I decided to post the steps involved in … Continue reading →

Posted in Oracle | Tagged , , | Leave a comment