IT & Cybersecurity Meetings: M-2

In 2 MONTHS, the IT and Cybersecurity Meetings show will take place in Cannes!

This one-to-one 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 1,850 participants per day
– 6,000 one-to-one appointments
– 160 exhibitors.

The dbSQWare team will be present on stand A20-B19, at the Palais des Festivals et des Congrès in Cannes.
The opportunity to exchange on the DBMS, their backups and restorations, the copies of environments, the reorganizations, the updates statistics and the 360° vision of the IT infrastructure.

HAPPY NEW YEAR 2023

The dbSQWare team wishes you a Happy New YEAR 2023!
May it allow you to accomplish all your professional and personal projects.

For our part, we will continue to do our utmost to satisfy our customers and respond to DBMS management and maintenance issues.
Because facilitating the daily lives of DBA teams and their CIOs will remain our priority once again this year!

MERRY CHRISTMAS

The dbSQWare team wishes you a Merry CHRISTMAS 2022!
Very happy holiday season.
See you next year!

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!

TECHSHOW 2022

The TECHShow 2022 is today and it’s happening at the Aix-en-Provence Congress Center.
Michel Payan and Séverine Payan are waiting for you on the dbSQWare stand to present our multi-DBMS operating and maintenance software.
A good day in perspective, made of meetings and exchanges, multiple and varied.

Good event to all!

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.

2006-2022

16 years old !
16 years have passed since the idea of ​​developing software that could handle the day-to-day administration tasks of several different database engines was born.

Born of a real need for companies, faced with the same problem of setting up (and then maintaining) operating scripts for their DBMS, the project first appeared to be audacious, even utopian for some.
However, by dint of reflection and work, the software was created in 2007 respecting the specifications for 4 engines.
Today, 12 engines are supported.

Modular, dbSQWare is constantly evolving to follow technical developments and meet customer needs.
Thank you to our users for their trust and their solicitation, because it is for them and thanks to them that the software exists.

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!