Working with SQL databases and tables usually implies performing daily data-related tasks using the CRUD operations in order to re-use, manipulate, and access data later. For example, you can create a new table, modify, populate the table with data, retrieve and store data for future use, or delete if needed.

crud, sql complete, sql server, t-sql / March 4th, 2021

Following the release of RAD Studio 10.4.2 Sydney from last week, we are excited to announce support for the new versions of Delphi and C++ Builder IDEs in our data access components. DAC products are now also compatible with macOS Big Sur, iOS 14, and Android 11. Additionally, PostgreSQL 13 was supported in PgDAC.

Read the rest of this entry »

dac, delphi, macOS, rad studio, what's new delphi dac / March 3rd, 2021

Most modern websites and applications ground on data collection, storage, and analysis. Databases take an active part in building the entire Web environment. That’s why it is crucial to ensure correct data retrieval from databases and appropriate ways of data manipulation. To modify your data properly, you will need to execute SQL queries. The current article will focus on the MySQL UPDATE statement and its use.

dbForge Studio for MySQL, mysql, UPDATE statement / March 3rd, 2021

SQL Server Management Studio or SSMS is, perhaps, the most famous product for managing Microsoft SQL Servers and any SQL infrastructure. Many experts consider it the most useful management tool of all. 

Microsoft SQL Server Management Studio, ssms, SSMS tools and add-in / March 2nd, 2021

In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server.

command line, connect to database, database administration / March 1st, 2021

We are delighted to share the great news with our Oracle users – a new version of our Visual Studio plugin for Oracle database management, dbForge Fusion for Oracle, v3.10, has been just released!

dbforge, dbforge fusion, oracle tools, what's new oracle tools / February 26th, 2021

We are glad to inform our MySQL users, that a new version of our Visual Studio plugin for MySQL database development, dbForge Fusion for MySQL, v.6.6, has been just rolled out.

dbforge, dbforge fusion, mysql, mysql tools / February 26th, 2021

Here come this year’s first awards received by Devart products! The Visual Studio Magazine announced the winners of its 27th annual Reader’s Choice Awards, and we’ve got two products among them. The first one is dbForge Fusion for SQL Server, which was awarded the Bronze badge in the Databases and Data Development and Modeling category. The second one, Entity Developer, scored the Bronze badge in the Software Design, Frameworks, and Modeling Tools category.

dbforge fusion, entity developer, sql server / February 24th, 2021

We’re pleased to present dbForge Studio for SQL Server v6.0 hugely packed with new features and major improvements. Database DevOps integration is one of the most demanded features requested by our users, and today we are making it happen.

dbForge Studio for SQL Server, DevOps Automation / February 23rd, 2021

The article provides a comprehensive walkthrough outlining the aspects of how to install MySQL Server on Windows using MySQL Installer. Learn the subtleties of the MySQL installation process step-by-step to ensure you have MySQL Server together with its tools running smoothly.

MySQL Installer, MySQL Server, Windows / February 22nd, 2021