Recently I raised a question to the head of an IT organisation whether he has plans to reduce the number of applications, which his IT department is managing and the answer was “No”. I was surprised, even shocked having in mind the considerable application number and the big issues that IT team is facing in the data integration area.
As a matter of fact most of the IT managers rate data integration issues as the most critical to their enterprises. Since a typical IT organization usually has a collection of isolated, incompatible, disconnected applications and databases and to make things worse that number is constantly increasing, I believe this criticality will only increase in the future.
The question arises why the data integration issue is so important to the companies? Read more »
I often hear from customers: Oracle database server is so expensive. Well, I often answer: That depends! In fact, the Oracle database license costs are similar to software from Oracle’s competitors. Microsoft SQL Server has a different license model though. Oracle has a lot of advantages in its flexible license model as well as number of Open Source initiatives. Together, these options allow an enterprise to get cost savings on their IT investments. Read more »
I remember testing the Project Raptor software about 5 years ago, Oracle’s new graphical tool for creating and browsing database objects. With a few clicks you could easily create and debug stored procedures, test SQL statements and view optimizer plans. Raptor was small, fast, and fun, and perhaps best of all, it was FREE! Later, the SQL Developer production version 1.0 was released in 2006.
Right from the beginning the tool was supported by Oracle Support for any customer with a current Oracle Database support contract. I admit I did not use SQL Developer right from the beginning. With more features coming into the new releases I started slowly accommodating them in my DBA toolset. So what’s now? Is it still small, fast and fun? Read below my short software review of the current SQL Developer version 18.104.22.168. Read more »
Oracle recommends that, where possible, you build applications in which application users are database users. In this way, you can leverage the security mechanisms of the database.
Unfortunately from my experience for a lot of commercial packaged software, application users are not database users. For these applications, multiple users authenticate themselves to the application, and the application then connects to the database as a single, highly-privileged schema user containing all the database objects. This is known as so-called One Big Application User model. Why, in spite of Oracle recommendation, the software vendors use in development that database authentication model? Read more »
Database performance tuning can be complicated even for a DBA. In many cases a database just seems like as a big black box. Recently I’ve had a chance to review database software called Embarcadero DB Optimizer XE that tries to open that black box for database developers and a DBA. Read more »