CRIP: M-3

This year again, the members of the dbSQWare team will be present at the annual convention of CRIP, the Club of Infrastructure and Production Managers.
On June 3 and 4, come and meet them at the Espace de la Grande Arche de la Défense, to discuss DBMS!
A fair that promises to be rich in sharing and discussion.

M-1: IT & IT SEC. MEETINGS

In 1 month, it will be the IT & IT Security Meetings, at the Palais des Festivals et des Congrès de Cannes.
A one to one trade show, dedicated to IT and security professionals.
On March 17, 18 and 19, members of the dbSQWare team will be present on stand 121 to discuss with you.
Come meet them!

SQL / NoSQL

Relational databases are manipulated with SQL (Structured Query Language), while NoSQL databases (Not Only SQL) are characterized by a logic of non-relational data representation and do not (or rarely) offer query interface in SQL.
Some differences :
– Structure: In a relational database, the data schema (tables, keys, procedures, …) must be designed to be able to manipulate data. With NoSQL, data can be added anywhere and at any time (in most cases).
– SQL normalization / NoSQL denormalization: In SQL, the data are not duplicated and are linked together by foreign keys. In NoSQL, they can be duplicated and copied into several different records.
– Join: SQL queries allow the JOIN clause. NoSQL generally has no joins.
– Scalability: Following an increase in load, relational side, it is often chosen to increase the size of the server rather than putting clusters on the instances. With NoSQL, data organization allows partitioning and scaling up of the database on current deployed hardware.
Their common point: dbSQWare!

TRY & BUY

The experience is only worth it if it was lived … That’s the reason why we propose the “Try & Buy” of dbSQWare!
The principle is to offer 3 months of subscription and allow users, from each company, to use dbSQWare for free to manage their database.
At the end of the evaluation period, convinced users will only have to subscribe to the software subscription.

INSTALLATION STEPS

Unique, dbSQWare allows its users to manage, in a completely homogeneous way, all of its DBMS despite their heterogeneity.
Its installation takes place in 4 essential phases:
– the definition and study of the architecture in place,
– the setting and customization of dbSQWare according to the environment,
– the software deployment,
– and finally, the passage of knowledge on its daily use.
Installing dbSQWare means choosing reliability, agility and serenity, through a global management and vision of your database.

DBA

– “Do you know what the job of DBA is?”
A DBA (DataBase Administrator) is responsible for the design, implementation and management of DBMS.
He also ensures the maintenance by adapting them according to the technological evolutions and the needs of the company.
The database administrator is responsible for the accessibility, quality and security of the data.
He also acts as technical support and support for IT developers and users.

– “What is the benefit of dbSQWare for a DBA?”
Thanks to our software of SGBD management and maintenance, backup, restore, environment copy and indicator collection tasks become easy and are followed.
DBA teams can free up time and focus on higher value-added tasks.

INTERFACE

Following the UX / UI Design mission carried out by Atrioom, the developments began.
Our software dbSQWare will soon have a more ergonomic and intuitive interface to offer users a smoother navigation.
No more square and rigid cuts, instead of roundness and glide!
Obviously, new expected features will complete this version.
Still a little patience…

V2019.05

The 2019.05 version of dbSQWare has just been released!
With 2 new features:
– for Sybase: the addition of tracing of changes on structures (tables, columns and indexes) and the ability to compare the structures of two schemas;
– for MariaDB: the integration of the MariaBackup backup system.

For more information, all changes are available on the “Release Notes” page of our website (“Technical” tab).

WELCOME

The dbSQWare team is growing!
Welcome to our new trade assistant, Marine Lario!
Student in Master 2, Marine joined the company on Monday and the whole team is very happy to welcome her.