CANDLEMAS

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

Enjoy yourself!!

CIP General Meeting

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!

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.

V2023.01

The new version V2023.01 of dbSQWare has just been released!

This first version of the year includes several major new features, such as:

– the addition of the “tee” command and the removal of the “tail” command at the log management level, in all scripts,
(the custom scripts in place will have to be adapted)
– the management of a locking file for SQL Server, in order to avoid having two backups of the same type at the same time on the same database,
– use of pigz (if installed) instead of gzip for archive backups, PITRs and dumps in PostgreSQL.

Constantly evolving, dbSQWare adapts to the demands of our users to make their daily life easier and to gain in efficiency and time, on the daily tasks of operating database engines.

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!

DBMS

dbSQWare is a multi-DBMS operating and maintenance software that supports 12 types of database engines which are among the most widespread and most used.
Supported versions have a range of 30 years, from the early 90s for some DBMS (Oracle 7, SQL Server 6.5) until today.

dbSQWare supports 9 RDBMS (Relational Database Management System):
– Oracle, most popular on UNIX/Linux
– SQLServer, developed by Microsoft and mainly deployed on Windows
– Teradata, a historical RDBMS with colossal storage capacities
– Sybase, acquired by SAP and former market leader
– DB2 LUW, the distributed system version of the Mainframe engine
– Ingres, dating from the 80s and in Open Source since 2004
– MySQL, the most popular Open Source RDBMS
– MariaDB, a fork of MySQL
– PostgreSQL, the most advanced Open Source RDBMS

and 3 NoSQL:
– Cassandra and her column-oriented organization
– MongoDB, the most popular NoSQL, with a document-oriented organization
– Adabas Linux version, accessible by the natural language.

Despite the diversity of these database engines and their heterogeneity, dbSQWare makes it possible to have a common approach via a centralized and homogeneous exploitation.

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.