All articles

Concrete5 CMS

Today, a lot of CMS are existing, WordPress, Joomla, Magento, and others, in this blog I will share my experience Concrete5 through a web agency specialized based in Geneva: 8 Ways Media What Concrete5? Not only a(…)

EMC World 2015 – Day 3 at Momentum

In this post I would like to relay some advices around the upgrade to Documentum 7.2 I have got in the session from Patrick Walsh about “What’s New, what’s Next: EMC Documentum Platform”. With Documentum 7.2 the processes for the(…)

EMC World Las Vegas – Momentum 2015 third day D2 news

This was a more day of networking with EMC partner contact and third party software editors. On the other side I attended a session about D2 news and what is comming next. EMC divided D2 enhancements by 3 main major(…)

Variations on 1M insert (2): write commit

In this blog post, I will try to do the same than my colleagues about Oracle and for PostgreSQL. As a reminder, we’ve seen in my previous blog post that SQL Server is designed(…)

Variations on 1M rows insert (4): APPEND_VALUES

By Franck Pachot . In the first variation I did a bulk insert with the PL/SQL FORALL statement. A comment suggests to add the APPEND_VALUES hint that appeared in 11gR2. APPEND_VALUES hint does the same than APPEND but(…)

Variations on 1M rows insert (1): bulk insert

I think you already have read the interesting series of blog posts of my colleagues Franck and Daniel about inserting on 1 million rows for Oracle and PostGreSQL. So it’s time to write the first of the same series(…)

Rebuilt index on increasing values after deletes?

By Franck Pachot . Yesterday while giving our Oracle tuning workshop I discussed with the customer about a job they have that rebuilds indexes every Sunday. Except in very rare cases Oracle indexes are maintained so that free(…)

the fastest way to load 1m rows in postgresql

There have been several posts on how to load 1m rows into a database in the last days: Variations on 1M rows insert (1): bulk insert Variations on 1M rows(…)

getting started with postgres plus advanced server (4) – setting up the monitoring server

If you followed the first, second and the third post the current ppas infrastructure consists of a primary database, a hot standby database and a backup and recovery server. Now we will add(…)

When tempdb database may cause indirect issues

A couple of weeks ago, I had an interesting discussion with one of my friend that faced a weird issue with a SQL Server instance that lacked worker threads. Because I can’t use his own information I decided to reproduce(…)