Incontournable CIP – CESI

Tonight, afterwork “Incontournable Aix-en-Provence” organized by the CIP – Club Informatique Provence Méditerranée.

Lucas and Emmy will represent dbSQWare during this event which will be held at the CESI Campus in Aix-en-Provence and which will begin at 6:00 p.m.
Tonight’s theme will be: “Alternating: a solution for your recruitment”.

Good event to all participants!

IT & Cybersecurity Meetings

The Cannes IT & Cybersecurity Meetings is now!

After the welcome cocktail dinner last night, the event continues with 2 days of one-to-one fair, from 8:45 this morning until tomorrow evening, 6:30 p.m.
This show dedicated to professionals aims to promote direct “face to face” between Top Decision Makers and Exhibitors through pre-organized meetings prior to the event.
With :
– more than 2,000 participants per day
– 6,000 one-to-one appointments
– 170 exhibitors.

The dbSQWare team is in place and waiting for you on stand A20-B19 to discuss the management and maintenance of database management systems.
Emmy, Séverine and Michel will present their software with many features (backup, restore, copy of environments, update statistics, etc.) which supports 12 types of DBMS (Oracle, PostgreSQL, MySQL, Sybase, SQLServer, MongoDB, etc.).
Do not hesitate to come and meet them.

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

Incontournable CIP Cannes

Tonight, afterwork “Incontournable Special IT Meetings” organized by the CIP – Club Informatique Provence Méditerranée.

Emmy, Séverine and Michel from dbSQWare will be present at this event which will take place at the Bayou restaurant in Cannes and which will start at 6:00 p.m.
Exchanges, conviviality and networking will be there.

Good event to all participants!

DAILY GLOBAL CHECK

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!

TV REPORT

Television intervention of our president!

A reporter from BFM Marseille came to our premises yesterday to film Michel Payan during a report on Data.
2 issues were addressed:
– What is the date?
– What innovations are made in data?

The program “Perspectives d’Entreprises” will be broadcast on Tuesday February 21, 2023 at 8:10 p.m., then every day at 11:15 a.m. until February 28.

Congratulations to Michel for his participation and a big thank you to BFM Business for the interest shown in our company.

Can’t wait to see the result on BFM Marseille (channel 30)!

THANK YOU

As the end of the year approaches, we would like to thank you, dear users, for your trust and loyalty!

dbSQWare has just celebrated its 15th anniversary and has therefore been installed by some of our historical customers.

THANK YOU for your interest, your involvement and your solicitation!

DBMS: Update Statistics

A statistic (on a table, a column / a set of columns or on an index) provides information on:
– the table (number of lines, average size of a line, number of blocks/page, density),
– the distribution of values ​​for the column(s) (number of distinct values, number of duplicates, existence of null values, histogram of distribution of values),
– the composition of the index (depth, number of blocks, cluster ratio).

These statistics are used by the database optimizer to study the different execution plans that can be used for a query.
The optimizer (based on costs / CBO) chooses the best execution plan (least expensive) from the data calculated from these statistics on, in particular, the number of rows and blocks of data to be shuffled at each stage of these plans (access strategies).

Statistics are essential for the proper calculation of query execution plans. It is therefore essential that they are up to date to take into account changes to the data and therefore to the indexes, columns and tables.
Thanks to update statistics, the optimizer has reliable data to choose the best performing execution plan to serve data to applications.

GEOGRAPHICAL DISTRIBUTION

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…

WELCOME ALBAN

Welcome to Alban Vassallo, our new database administrator!

Alban joined dbSQWare yesterday.
We are very happy with his arrival in the team.

Incontournable CIP Avignon

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

Our CEO, Michel Payan will give feedback on the use of design in software design. He will be accompanied by Aurélien Beguet from the Atrioom agency, with whom we collaborated during the redesign of the dbSQWare web interface.

Exchanges, conviviality and networking will be there.
Good Essential to all participants!