Steve Callan

Oracle Data Guard is a very useful tool to help maintain high availability and to protect your data. It is not uncommon to see “must have experience with RAC and Data Guard” in job postings on Monster and Dice. If you are not using Data Guard at work or do not work in an environment […]

If you have seen advertising literature from major database system vendors, invariably you have seen statements about how that database performed against other systems (benchmark results). All of the major vendors support and participate in benchmarking tests because, to some degree, they have to. The mindset must be along the lines of “Everyone else is […]

What do FORTRAN and Oracle have in common? The answer to this question is at the end of the article, so before we get there, allow me to use the study of mathematics as a model. For math majors at many colleges and universities, a required course or elective covers the subject of math history. […]

At the end of Part Four, we were ready to create the Oracle model of the Northwind database "imported" from a SQL Server 2000 instance. In this part of the series, we will continue the SQL Server migration and look at some issues related to the SQL Server to Oracle migration process. Migrating a SQL […]

At the end of Part Three, we finished installing SQL Server and created a user account that has access to the Northwind database. In Part Four, we will go into more detail about SQL Server and how it compares to Oracle. This part of the series also covers the setup and preparation to use Oracle […]

When it comes to IT training, how do you want to spend your hard-earned dollars? There are plenty of options, approaches, and vendors to choose from, so it helps if you have a specific or somewhat focused goal in mind before spending your money. Let’s look at some of the choices as they relate to […]

At the end of Part Two, we finished loading data from the MySQL database into the Oracle database/repository. The owner of the imported data was root, the privileged owner in the MySQL database “omwb.” In Part Three, we will go into more detail about the Migration Workbench console and learn how to configure some options. […]

At the end of Part One, we were at the point where MySQL was ready to be installed. In part two of this series, we will go through some quick setup steps, create a user with some privileges, and load data – using several methods – into a MySQL database. Once the setup of the […]

Let me start with a bad news/good news situation. The bad news: as far as job searches are concerned, it is becoming readily apparent that knowing only Oracle is not good enough anymore. Personally, I have taken major hits for not knowing SQL Server and have heard some static about DB2. The good news: ignorance […]

Part One of Oracle Response Files covered the basics of using a response file and provided an example of how to install Developer Suite on a Windows PC. In Part Two, we will go into more detail about the components of response files. This part will also discuss some related topics as they pertain to […]

In a previous article, I discussed a deployment framework for getting Forms on the Web. This article discusses the steps to get your Reports on the Web. I’ll cover the steps to use Reports-related built-in’s in your forms, how to "tell" your forms the name of your report server, how to toss in some JavaScript […]

More and more, companies are making the move from the client-server model of Forms to the 9i/10g Application Server Web-based architecture. Previous articles in the Installation Cookbook series discussed how to install Developer Suite and Application Server. This article lays out a deployment framework to address the "now that I have these things installed, what […]