An optimized database improves query performance, reduces processing times and reduces resource consumption (CPU, RAM, Storage, etc.). This is why it is essential to maintain an efficient organization of databases.

Hence the need for reorganization when this is not the case.
This task consists of physically reorganizing indexes and/or tables with the aim of optimizing the use of disk space and improving access to data (through their organization), recovering unused disk space, left by deleted records and/or data updates.

The operation to be carried out depends on the degree of dispersion of the index (or table) information in the database (called fragmentation):
– compaction (REORGANIZE or COMPACT) is often necessary for fragmentation between 10 and 30%
– beyond that, a reconstruction (REBUILD) must be carried out.
A “side effect” of rebuilding a table is rebuilding all of its indexes.

In any case, a successful database is a database that is monitored and maintained.

Welcome to Julien Cornand and Ewan Ducouet who started their new alternation yesterday!
Both are in Bachelor 3. Julien is training as a system and network administrator from CESI and Ewan is training as a computer and information systems expert from AIX YNOV CAMPUS.
We are delighted to welcome them to our team.

We also wish a good continuation to 2 of our work-study students, who after a year of apprenticeship at dbSQWare, are leaving for new horizons: Agnès Nagamany, on the international trade side and Ruben Ruiz, on the cybersecurity side.

Good way to all!

This evening, Festive Evening of the Club Informatique Provence Méditerranée – CIP, at the TheCamp innovation center, in Aix-en-Provence.

dbSQWare will participate with great pleasure in this annual event, expected by all.
Theme of the evening: “Summer Party”… Atmosphere assured!

Congratulations to the members of the CIP for the organization and good evening to all the participants!

The 31st edition of COTER-NUMERIQUE (the 1st for dbSQWare) has come to an end.

A big thank you to all the decision-makers who came to meet our team during this show.
Discussing the management of database engines is always a pleasure for Séverine Payan and Michel Payan.

Congratulations to Antoine Trillard and his entire team for the organization and the quality of the event.
Looking forward to the next edition, in 2023, in Deauville.

Thank you also to our colleagues and partners for their great sympathy.

– “The environment copy, what is it for?”

The environment copy allows you to duplicate an environment and thus have 2 identical environments (same structure, same tables, same data) on 2 different servers.

The interest is to have, for example, a development environment identical to that of production (in the case where the prod environment is copied in dev) and to provide developers with a working base reliable and up-to-date before they start coding (Caution, it may be necessary to anonymize the data!).
In other cases, the environment copy can make it possible to put a test environment into production, if it has successfully passed all the validation stages, or to set up a DRP (Disaster Recovery Plan) on D-1.

Finally, if the duplication is done through backups, this makes it possible to validate their viability.

This evening, afterwork “Incontournable Nice – Sophia Antipolis” organized by the Club Informatique Provence Méditerranée – CIP.

dbSQWare will be present during this unique event which will begin in Le Muy, with a visit to the company Mecatech, which specializes in the machining of industrial parts, and will continue in Les Arcs-sur-Argens with a visit to the Domaine de Font du Broc and its remarkable vineyard.

Exchanges, conviviality and networking will be there.
Good Indispensable to all the participants who will have the chance to be present and a big congratulations to the CIP for the organization of this exceptional event!

dbSQWare was chosen by one of the PACA region Hospital Centers to manage and maintain its databases.
With this new collaboration, a new sector of activity is opening its doors to us: health.

We are very pleased with this new mark of trust.

The dbSQWare team is proud to present its new Motion Design video.

A big thank you to Damien Dalmasso of Mooovie Studio for his listening and his remarkable work.
And this is only the beginning of our collaboration, since other small videos will soon come to complete this one.

The IT & Cybersecurity Meetings in Cannes is now!
After setting up the stand last night and the welcome meal, the show opens its doors to visitors from 9:00 a.m. this morning until tomorrow evening, 6:00 p.m.

The dbSQWare team is in place and waiting for you on stand G14 to discuss the management and maintenance of database management systems. It will present its software with many features (backup, restore, copy of environments, update statistics, etc.) which supports 12 types of DBMS (Oracle, PostgreSQL, MySQL, MariaDB, Sybase, SQLServer, MongoDB, etc.).
Do not hesitate to come and meet him.

And above all, a very good show to all the participants!

This evening, afterwork “Incontournable Nice – Sophia Antipolis” organized by the Club Informatique Provence Méditerranée – CIP.

Michel Payan from dbSQWare will be present at this event which will take place at the Mercure Antibes Sophia Antipolis hotel and which will start at 6:30 p.m.
Exchanges, conviviality and networking will be there.

Good Essential to all!