Infrastructure at your Service

All posts by Hervé Schweitzer

Hervé Schweitzer
Chief Technology Officer (CTO) and Principal Consultant

Hervé Schweitzer has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies such as standardisation, Backup and Recovery, Tuning, and in High Availability solutions such as Oracle Data Guard, Oracle Grid Infrastructure, Oracle Real Application Clusters (RAC), Oracle GoldenGate, and Oracle Failsafe. Hervé Schweitzer is "Oracle Certified Master 11g (OCM 11g)". Prior to joining dbi services, Hervé Schweitzer was Senior Consultant at Trivadis in Basel. He also worked as an IT Administrator and Oracle DBA at Crossair in Basel. Hervé Schweitzer holds a BTS degree in Information Systems from France. His branch-related experience covers Pharma, Transport and Logistics, Banking, Energy, Automotive etc.
Hervé Schweitzer

Funny session Oracle vs PostgreSQL battle at the #DOAG2018

By | Database Administration & Monitoring | No Comments

As each year dbi services is present at the DOAG with a nice booth and with many presentations. Today my colleague Daniel Westermann had a very funny session with Jan Karremans “Oracle vs PostgreSQL” battle. The rule of who will defend which technology was not defined before and without surprise Daniel won the Oracle Technology. But Daniel since the last year is convinced from the PostgreSQL technology. Daniel started the Battle with aggressive question to…

Read More
Hervé Schweitzer

Short summary of my PGCONF.EU 2018 conference

By | Database Administration & Monitoring | No Comments

So it’s nearly the end of the conference, where I met lot’s of people from the Postgres community, customers, EDB partner and also contributor/developer of Postgres. During the 3 days I had also the chance to follow many technical sessions and I will give you a short feedback of my preferred sessions. If you want to have the details of the sessions go the conference website https://www.postgresql.eu/events/pgconfeu2018/schedule Tour de Data Types: VARCHAR2 or CHAR(255)? Very…

Read More
Hervé Schweitzer

Deep dive Postgres at the #pgconfeu conference

By | Database Administration & Monitoring | 3 Comments

Today I followed many good technical sessions at the European Postgres conference. The Postgres conferences are really technical oriented, you will find no marketing sessions there and you learn a lot of things. As promised yesterday, I wrote today my first blog about the new Postgres storage engine ZHEAP/UNDO, which is a very interesting feature, with very interesting results.

Read More
Hervé Schweitzer

My first day at the #pgconfeu 2018 in Lisbon

By | Database Administration & Monitoring | No Comments

After the first Swiss PostgreSQL community dinner yesterday evening, the conference started this morning. dbi services as Gold partner of the 10th European conference in Lisbon, get the opportunity to have a booth to present all our Open Infrastructures Services. For the occasion we decided to announce this morning our brand new video of our OpenDB Appliance, which is a real success, because we have more than one hundred views and many attended of the…

Read More

#SwissPGDay is a place where you can meet developers of the PostgreSQL community

By | Database Administration & Monitoring | No Comments

As the #SwissPGDay is located one hour south of  Zurich we traveled yesterday evening to Rapperswil, where is a nice little Swiss city. For the People coming one day before, Stephan Wagner organized a nice dinner in an excellent restaurant, before I forget the Red-wine was also excellent ! The #SwissPGday is located in Rapperswil at the HSR(Hochschule für Technik) near the Zürisee, it’s a nice location and everything was nicely organized. Also the look-out…

Read More
Hervé Schweitzer

DOAG2017 my impressions

By | Database Administration & Monitoring | No Comments

As each year at end of November the biggest Oracle European conference takes place in Nürnberg, #DOAG2017. This year is a little bit special, because the DOAG celebrate the 30th edition of the conference. dbi services is for the 5th time present with a booth and 8 sessions at the DOAG. During the last 2 days I already followed many sessions, and I want to give you my impression and feedback’s about the market trends….

Read More
Hervé Schweitzer

DOAG 2016 : it was a great adventure

By | Database Administration & Monitoring | No Comments

As in recent years, dbi services was present at the DOAG 2016 conference with 9 presentations and a 1 day training. Our presentations have been well appreciated with many participants in large conference rooms, and mostly because they contain live demos. You can review our adventure on linkedin Below, a picture from our booth with the full team (Marketing,Sales and Referents)

Read More
Hervé Schweitzer

With Oracle Goldengate take care of additional column creation on the replicated database

By | Database Administration & Monitoring | 3 Comments

This week I worked on a GoldenGate 12.1.2.1.10 POC setup and was facing an issue which for me is a serious drawback of the Oracle GoldenGate product.If you want to create additional columns on the target database online in a GoldenGate configuration you have to be aware of the below situation which can happen in your setup:The below demo was created on a Oracle GoldenGate Downstream server For the test, I have created the schema…

Read More
Hervé Schweitzer

Adding new tables to an existing Oracle GoldenGate replication

By | Application integration & Middleware | 14 Comments

Once a replication environment is set up, it’s rarely forever. Adding tables to an Oracle GoldenGate replication group with minimal impact to the current replication is quite a difficult operation. This posting should help you with this task. In the example below, tables from schema G001 will be added to an existing replication setup from the database PROD1 to REP1. CFG_ADV_COND CFG_NARRATIVE_TEMPLATE CFG_REG_REPORT_RULES CMN_LOOKUP CMN_USER_LOGIN   Stop the replication environment Connect to the source database PROD1 and…

Read More