All articles

SQL Server, Integration Services and Package Versions

A lot of people ask me about the different versions of SQL Server Integration Services and packages. I create rapidly this little table to summarize it: With SQL Server 2008 and 2008 R2, the SSIS version(…)

Oracle CDC for Datawarehouse, Dbvisit replicate as an alternative

By Franck Pachot . You don't want to reload the datawarehouse database every night. And you may want to have it refreshed more often, in real-time during the day. There is another reason to capture all changes from the(…)

“FRA full” alerts flood the Alert Log

We discovered a strange behavior in the Alert Log when the Fast Recovery Area (FRA) is full and the database wants to write something inside it (for example an archivelog). This case concern Oracle 11.2.0.3 databases and higher. Here is a(…)

Representing ranges with one data type?

How many applications do you know that need to define a validity of a row? And how many of these do that by adding two columns: valid_from and valid_to or similar column names? Well, in PostgreSQL (you already suspect it(…)

SQL Server Tips: Logical names don’t match with physical files names

During a copy of a database from an environment to another (from Production to pre-production for instance), people usually don’t changed the logical name of the data or log files when they rename the database and the physical file names.

Oracle Database Cloud Service – DBaaS

By Franck Pachot . My first trial was not very good because I had access to Schema as a Service only. Which is not new. But Oracle Cloud Services is becoming(…)

Configure the Resource Manager with SQL Developer

By Franck Pachot . Yes, the topics for the OCM 12c upgrade are online and I'm already looking at the topics. I'm talking about the 'Configure the Resource Manager' one here. Configuring Resource Manager in commandline(…)

DataGuard broker properties – Part II: log shipping parameters

By Franck Pachot . In the part I we have seen the properties that are imported when you add a database to the configuration, and which are then managed by the(…)

OCM 12c preparation: Materialized View explain_rewrite

By Franck Pachot . When I passed the OCM 11g exam, I had to prepare the 'Manage Materialized Views to improve rewrite' topic. Now that I'm preparing the 12c upgrade I checked quickly what I've(…)

DataGuard broker properties – Part I: imported parameters

By Franck Pachot . When you are using the DataGuard Broker, you should always use the broker (with DGMGRL or OEM) to change the parameters that are managed, rather than changing them with ALTER SYSTEM. But do you know which(…)