The whole dbSQWare team wishes you a happy Easter Monday!

Because it is essential to be able to follow the evolution of its databases, the dbSQWare web interface offers a 360 degree view of all of its DBMSs.

Thanks to its indicators, it allows, at the same time, to have:
– a global vision: distribution by DBMS, versions, volumetry
– and a granular vision through a Top-Down approach: vision of the instance, the database, the table, etc.

dbSQWare provides a complete graphical representation necessary for monitoring, security, auditing and compliance.

With dbSQWare, keep control over your databases!

IT and Cybersecurity Meetings 2023 are over!

A big thank you to all the decision-makers who came to meet our team during this show.
Talking about database engine management is always a pleasure for dbSQWare.

Congratulations to Carole Jardon and her team for the organization and the quality of the event.
dbSQWare will be present for the next edition, in 2024.

And thank you to our colleagues and partners for their great sympathy!

To avoid data loss, it is important to make backups of your databases.
But it is also necessary to ensure that these backups are correct and exhaustive, like the skydiver who checks his equipment before jumping.

Using dbSQWare means simplifying and making reliable the management of backups, restores and environment copies, whether physical or logical, while ensuring that the defined backup policy is respected thanks to a daily global check.

With dbSQWare, keep control over your databases!

Today is Candlemas!
The opportunity for pancake lovers to share a good moment of conviviality with colleagues, friends or family!

Enjoy yourself!!

This evening will be held the Annual General Meeting of the CIP – Club Informatique Provence Méditerranée.
Meet at 6 p.m. at the TheCamp innovation center in Aix-en-Provence.
As a member of the office, our president, Michel Payan will be present.

Happy meeting to all participants!

Initially implemented exclusively in the Paris region, our software dbSQWare has since made its way.
It’s thanks to our users: their trust, loyalty and high standards.
The software is constantly evolving to meet customer needs.
This year, 6 patches have completed and enriched the 2022 version of dbSQWare.
The 7th will be released in a few days while waiting for the 2023 version…

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.

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!

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.