Archive for the ‘Databases’ Category
Oracle OpenWorld 2011
October 2-6, Moscone Center, San Francisco. “Oracle OpenWorld is the most cost-effective and efficient way to stay ahead of the technology curve.” Why not believe it? When tens of thousands of people attend, you have thousands of sessions to choose from, you can enjoy membership in a global community of Oracle technologists, customers and partners [...]
Tags: Oracle Oracle EBS Oracle OpenWorld
Posted in: Databases, News, Oracle, Oracle E Business Suite, Software Development
| 
September 1, 2011
Daniela Bozdoc
| 
No Comments
How to create a SQL Server Agent Job (Transact-SQL) – with only needed fields
In this post you will see two major sections: I. Detailed description for every needed field in system stored procedures. II. Full working example related to above description. Here you need only to replace the names if the default configuration is suitable.
Tags: database SQL
Posted in: Databases, MSSQL
| July 27, 2011
Raul Tomita
| No Comments
Installing Oracle Business Intelligence Enterprise Edition (OBIEE) 11g prerequisites
There are a few steps to complete before you can start with OBIEE 11g installation. This demo describes the steps required on a Windows system and requires
Tags: install Oracle Business Intelligence Enterprise Edition 11g OBIEE 11g Oracle BI Publisher 11g prererequisites
Posted in: Databases, MSSQL, Oracle E Business Suite
| March 4, 2011
Daniela Bozdoc
| One Comment
The Repository Creation Utility (RCU)
RCU is used to install certain schemas in a database that are required by Fusion Middleware products like Oracle Business Intelligence. Accepted database types are Oracle Database, IBM DB2 and Microsoft SQL Server. The steps required to run RCU
Tags: OBIEE Oracle BI Publisher 11g Oracle Business Intelligence RCU Repository Creation Utility Schemas
Posted in: Databases, MSSQL
| March 4, 2011
Daniela Bozdoc
| One Comment
Porting applications from Oracle to PostgreSQL
If you are planning to migrate a database application from Oracle to PostgreSQL, this article can help you to understand and solve some of the issues occurring in such a process. PostgreSQL has recently become feature-complete in many areas and therefore porting projects from Oracle might be a feasible option in much more cases. Oracle [...]
Tags: Oracle PostgreSQL
Posted in: Oracle, PostgreeSQL
| July 30, 2010
Alexandru Gyulai
| 3 Comments
Extending PostgreSQL – A better CONCAT operator
PostgreSQL users have the option of extending the set of functions and operators available. If you have a common SQL or programmatic routine, custom functions can be an effective way to more succinctly and efficiently accomplish your tasks. Likewise, custom operators can be created to call these functions (or existing built-in functions) in order to [...]
Tags: CONCAT operator custom operators Extending PostgreSQL PostgreSQL
Posted in: PostgreeSQL
| May 4, 2010
Alexandru Gyulai
| 7 Comments
Windowing Functions in PostgreSQL 8.4
PostgreSQL recently added several great new features like Common Table Expressions (CTE), Recursive CTEs, Windowing Functions (my favorite) and Parallel restoring of dumps. The goal of this article is to provide an overview of the new PostgreSQL Windowing Functions. Previously limited to enterprise databases such as Oracle and DB2, they open up a completely new [...]
Tags: PostgreSQL SQL Windowing Functions
Posted in: PostgreeSQL
| January 11, 2010
Alexandru Gyulai
| 5 Comments
Quick note on Microsoft SQL transaction log file
Every MS SQL Server database consists of at least two physical operating system files and these files are specified when a database is created or altered. One and possibly more (secondary files) are used for the data (as well as indexes and allocation pages) and one for the transaction log.
Tags: database MSSQL recovery model restore SQL Server transaction log
Posted in: Databases, MSSQL
| December 14, 2009
Daniel Bozdoc
| No Comments
What to do when you need to import a large MSSQL database dump inside a virtual machine and you have no sufficient space?
It is a good idea to hold your database server inside a virtual machine and run it only if needed. This will save the memory space from being loaded with running services when you don’t need them. But what if you need to import a large database dump file and there is no sufficient space [...]
Tags: database disk space large database dumps MSSQL virtual machine WMware
Posted in: MSSQL
| December 4, 2009
Alina Hila
| One Comment
Database Glossary – Power Builder
Concurrency Several clients sharing a resource Contention Multiple users try to access a resource at the same time resulting in waits or event deadlocks. Deadlocks A deadlock occurs when two or more transactions are both in a wait state, with each one waiting for the other to release a lock before it proceeds.
Tags: Power Builder SQL
Posted in: Databases
| August 25, 2009
Ciprian Candea
| No Comments
