How to Create Customizable CRUD Operations with SQL Complete

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.

Read the rest of this entry »

New in Delphi DAC: Support for RAD Studio 10.4.2 and Multiple Performance Improvements

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 »

Introduction to MySQL UPDATE Statement

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.

Read the rest of this entry »

General Review of Microsoft SQL Server Management Studio (SSMS)

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. 

Read the rest of this entry »

How to Connect to MySQL Server

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

Read the rest of this entry »

Meet dbForge Fusion for Oracle, v3.10 with Fresh Connectivity Options

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!

Read the rest of this entry »

New Connectivity Options in dbForge Fusion for MySQL, v6.6

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.

Read the rest of this entry »

Devart Products Win Visual Studio Magazine Reader’s Choice Awards 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.

Read the rest of this entry »

dbForge Studio for SQL Server Is Ready for DevOps Automation

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.

Read the rest of this entry »

How to Install MySQL on Windows Using MySQL Installer

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.

Read the rest of this entry »