Following the best practices of RDBMS involves the consistent usage of Primary Keys when designing databases to create and enforce Referential Integrity which is a major requirement for Data Quality and proper relational database design. In this tutorial, we provide background information on Primary Keys and their function as well as give code examples to illustrate the theory.

studio for mysql / August 5th, 2020

The overwhelming popularity of MySQL means that people need convenient tools to work with it. Software providers compete to produce the best MySQL client. However, the goal is not to develop a ton of options and thrust them all into one solution. It is to make a complete product that would match any user’s needs and suit both the basic operations and the most sophisticated and challenging tasks.

mysql, mysql tools / July 28th, 2020

Over the past few years, CI has come to be one of the best practices for software development. Indeed, it has numerous advantages: including high speed of product development, good code quality, enhanced communication between team members, and increased reliability of the process.

continuous integration, devops, sql server / July 28th, 2020

Devart is glad to announce the release of Excel Add-ins 2.5 with support for secure SSL and SSH connections to Oracle in the Direct mode. Now you can connect both to on-premises Oracle and Oracle Database Cloud — a Database as a Service (DBaaS) solution from Oracle — via secure SSL/TLS and SSH protocols in the Direct connection mode.

direct mode, excel addins, oracle, what's new excel addins / July 23rd, 2020

In the previous articles, we studied the basic rules of SQL database design, created a database schema diagram for a recruitment service, and filled the newly-created database with test data on employees.

data export, data import, sql server / July 23rd, 2020

In this article, we will examine the process of populating the employee database with dummy data, whose schema we designed in the previous part. Filling a SQL database with dummy data can be very useful when we want to run some tests. The most convenient way is the population of SQL tables with random data with the help of visual data generation tools.

sql server, studio for sql server / July 22nd, 2020

It is a common practice that a DB architect has to design a relational database tailored to a particular solution.

database diagram, sql server, studio for sql server / July 22nd, 2020

Devart is glad to announce support of SSH connections in the Direct mode in dotConnect for Oracle 9.12 and SSIS Data Flow Components 1.14. Now you can connect both to on-premises Oracle and Oracle Database Cloud — a Database as a Service (DBaaS) solution from Oracle — via secure SSH protocol in the Direct connection mode.

dotconnect, oracle, ssis, what's new dotconnect, what's new ssis / July 16th, 2020

We are thrilled to announce that a new version of  Source Control – our advanced SSMS add-in for SQL Server database change management – has been released. The most notable feature of this release is the support for a new Git client – Git for Windows.

/ July 16th, 2020

The necessity to export data from Amazon RDS to the on-premises MySQL database may be spawned by various reasons such as a user request, an upgrade to a system, data consolidation, need for back up, etc. The fact that data are usually required yesterday and export tasks need to be repeated again and again only compounds the difficulty. This article presents a walkthrough on how to export data quickly and easily with the help of dbForge Studio for MySQL.

studio for mysql / July 16th, 2020