The Excel-Addins update, version 2.8 has just dropped. Check out the new features and implementations! The post Release: Excel-Addins Update – ver. 2.8 appeared first on Devart Blog Read More

A primary key is a unique identifier for each record within a table that prevents duplicate values and allows for efficient data retrieval and manipulation. As such, a primary key is one of… Read More

The upcoming tutorial will focus on the ROUND function, which is used to round numeric values for precision and accuracy. Rounding is vital in databases to avoid discrepancies in calculation… Read More

Read this blog post on to see what the dbForge line products won DBTA's Readers' Choice Awards in 2023. The post Devart Products Become the Winners of DBTA 2023 Readers’ Choice Awards… Read More

In the article, we are going to explore the importance of the database deployment in MySQL and how automation can enhance this process. In addition, we'll examine how to set up schema compar… Read More

Microsoft Access is a rather popular relational database system, which nevertheless has a slew of considerable limitations. And if your business requirements grow beyond these limitations, y… Read More

We are thrilled to share the exciting news that our dbForge tools now support SQL OPENQUERY, a powerful feature introduced in SQL Server 2022. With this integration, our users can take full… Read More

We are pleased to announce the release of the long-awaited update for SQL Server Integration Services Data Flow components (SSIS), version 2.1. SSIS is a high-performance connectivity produc… Read More

SQL column aliases are the secret to clearer code and more user-friendly query results. Assigning custom names to database objects in SQL scripts results in improved readability and valuable… Read More

PostgreSQL stands out as one of the world's most favored database management systems, and a substantial number of PostgreSQL users are also devoted macOS users. They need tools that are full… Read More

This article builds a simple application that does some background processing to demonstrate the concepts covered using PostgreSql as the database to store data and dotConnect for PostgreSQL… Read More

It is necessary to have a reliable and efficient way to transfer data from databases to the BI tool. MySQL, one of the most popular open-source relational database management systems, comes… Read More

Integrating MySQL with Excel can offer several advantages, including analyzing data in real-time and creating powerful reports. This article will show several methods to connect MySQL to Exc… Read More

Exploring the advanced usage of IF-THEN statements and understanding how dbForge Studio SQL Server aids in handling these tasks will be the main focus of this article. The post Mastering IF… Read More

In the article, we explore the role and importance of SET NOCOUNT in SQL Server, discussing how it reduces the processing load on the client and improves query execution time. Additionally… Read More

Here, we will explore the ins and outs of MySQL DATEDIFF and its practical applications. We will look deeply into its syntax and provide you with real-world examples to showcase how DATEDIFF… Read More

Recently, we have rolled out extensive updates of our product lines for MySQL, Oracle, and PostgreSQL databases. But what if you are a SQL Server user? Well, you don't need to worry. dbForge… Read More

A recent update of dbForge Studio for PostgreSQL has added one more entry to its list of supported databases. We're talking about TimescaleDB, a PostgreSQL fork marketed as "the easiest, fas… Read More

In this article, we will explore the fundamentals of SQL Server concatenation, delve into different techniques for concatenating strings, and uncover advanced concepts that can take your str… Read More

ChatGPT, a powerful language model developed by OpenAI, has a wide range of applications across various realms, including database development. In this article, we will demonstrate how devel… Read More

In the article, you will learn how to migrate data from Oracle to a MySQL table using dbForge Studio for MySQL and ODBC driver. The post How to Migrate Data from Oracle to MySQL: Step-by-Ste… Read More

Addressing work challenges in SQL Server database development and deployment: a case study of DevOps engineers from a financial services company. The post How dbForge Schema Compare helped t… Read More

This article delves into the benefits of tab color customization, exploring how the combination of native SSMS and SQL Complete features empowers you with seamless navigation and a visually… Read More

In today's data-centric society, the quantity and diversity of information are expanding at an unprecedented pace. From social media interactions and financial transactions to scientific res… Read More

In this article, we will provide you with a screenshot-infused step-by-step tutorial on how to convert a Microsoft Access database to SQL Server using dbForge Studio for SQL Server. The post… Read More

Devart dotConnect line of products has received a significant update, making it even more compatible with the latest development environments. The post New in ADO.NET Data Providers, Entity… Read More

In this article, we'll learn how to clone data from one column to another within the same SQL table using T-SQL and dbForge Data Compare. The post How to Clone Data From One Column to Anoth… Read More

This article discusses how we can build a custom class to intercept HTTP 400 and 404, and 500 responses and return customized responses from the action methods. This article builds a simple… Read More

In today's data-driven world, it is essential to have the ability to transfer data between various databases and services quickly and efficiently. Oracle Database is one of the most widely u… Read More

Microsoft Excel is a popular software tool for creating spreadsheets and performing calculations. Many businesses and organizations use Excel to store and manage data, but there may come a t… Read More

The well-known as-a-service business model has long encompassed various digital solutions presented to customers, and databases are no exception. In this article, we'll have an overview of A… Read More

Navigating the process of SQL Server version upgrades and downgrades can be a daunting task, often accompanied by various challenges and complexities. However, with the assistance of the dbF… Read More

Creating a table is the core of the database design and one of the fundamental skills for all database professionals. This article will review default methods of creating tables on Microsoft… Read More

In this article, we will dive into the intricacies of ALTER SESSION, exploring its syntax, usage scenarios, and the wide range of settings it can manipulate. We will examine how this command… Read More

In todays technological landscape, artificial intelligence has carved a significant niche for itself, offering unparalleled assistance in numerous domains. One such domain is database devel… Read More

Coming on the heels of our recent big update of dbForge tools for MySQL, we'd love to share some more good news—and this time it's all about our product line for PostgreSQL database. T… Read More

In the fast-paced world of artificial intelligence (AI) advancements, developers are looking for the most efficient and groundbreaking solutions to expedite and improve their work quality. F… Read More

The SQL language provides a lot of effective operators for retrieving and presenting data from databases. One popular tool is the UNION clause. In this article, we will delve into what the U… Read More

Devart ODBC line of products has received a significant update, making it even more compatible with the latest development environments. The post New in ODBC: Support for Visual Basic, Link… Read More

Now that Q1 2023 is over, it's time to deliver our traditional champs recap and showcase the awards and badges garnered by dbForge solutions on independent review platforms over this period… Read More

The role of professional GUI tools is exceptional for database development, management, and administration. Let us review the best GUI tools designed for PostgreSQL – one of the most p… Read More

This article builds a simple data-centric application and demonstrates how to disallow data access to certain IP Addresses. In this article, we’ll connect to PostgreSQL using dotConnec… Read More

Learn how to seamlessly connect Power BI to SQL Server using ODBC, Python, and Excel with this step-by-step guide. Improve your data analysis and visualization skills today! The post Connect… Read More

Learn how to easily connect Power BI to your Oracle Database with our comprehensive guide. Unlock the full potential of your data insights today! The post How to Connect Power BI to Oracle D… Read More

Contents 1. Abbreviation 2. Objective 3. Technology Background 3.1. Python with Anaconda platform 3.2. Oracle Autonomous Data Warehouse Database 3.3. Devart ODBC for Oracle Driver 4. Prerequ… Read More

In the ever-evolving world of database management systems, SQL Server and MySQL stand as two of the most popular and widely-used solutions. Both platforms offer robust features and reliable… Read More

We have been talking about different MySQL operators in their guises for quite a while now: along with WHERE condition or SELECT statement, you name it. Now, the time to shine has come for t… Read More

SQL (Structured Query Language) is a widely-used programming language for managing and manipulating data stored in relational databases. As the need for data analysis and database management… Read More

Today, we've got some good news for all users of MySQL and MariaDB databases—we are rolling out a rather big update of our dbForge tools for MySQL with quite a few handy enhancements t… Read More

We have already explored the capabilities of the much-hyped ChatGPT in terms of writing SQL JOIN queries and retrieving data from MySQL databases. Now the time has come to take one more step… Read More

On 13th of April 2023, Devart is sponsoring the PGDay/MED 2023 annual conference on PostgreSQL and other open-source technologies The post PGDay/MED 2023 Conference On April 13th appeared fi… Read More

Recently, we’ve explored the case when dbForge SQL Complete was adopted by a group of SQL developers working under the banner of a tech company and seeking to get their routine coding… Read More

Database security offers new challenges emerge daily, and you have to pay all your efforts to prevent risks. Reliable protection grounds on a system with several security levels. Let's talk… Read More

In this article, we'll give a brief overview of SSH protocol and tunnel, as well as explore how to connect to a MySQL server remotely using the SSH tunnel created with the help of PuTTY, a p… Read More

As businesses grow, so do their databases. With the increasing amount of data that needs to be processed, it can become overwhelming to manage multiple databases and execute scripts across a… Read More

It is always interesting to explore a case where dbForge tools are used in a collaborative process. Take dbForge SQL Complete, for instance. It was created to make individual SQL developers… Read More

New ODBC drivers make it easier for users to integrate their data from popular platforms into their workflows, reducing the time and effort required for data analysis and reporting. Th… Read More

If you are a database developer dealing with several projects, it means you have to deal with a number of database management systems simultaneously. And for each of these systems, you need… Read More

This article talks about how you can upload one or more files in an ASP.NET Core 6 application.  The post Uploading Files in ASP.NET Core 6 MVC  appeared first on Devart Blog Read More

Salesforce provides a centralized platform for businesses to manage customer interactions, track sales, and streamline operations.In this article, we will describe options for obtaining data… Read More

The integration of PostgreSQL with a .NET 6 Web API provides a powerful and flexible solution for building data-driven .NET applications. The post Two ways to connect .NET 6 API to PostgreSQ… Read More

Dates are fundamental to many database applications, and correctly formatting them is crucial for ensuring data accuracy and efficient data retrieval. Oracle provides a plethora of date func… Read More

Devart DAC line of products has received a significant update, making it even more compatible with the latest development environments. The post New in Delphi DAC: Support for RAD Studio 11… Read More

Following the recent update of our PostgreSQL product line, we are genuinely excited to unveil yet another new release that's just as big and essential—a rich collection of newly suppo… Read More

In the world of database management, regular backups are crucial to safeguard against data loss or corruption. This article provides a step-by-step guide on how to set up daily SQL Server ba… Read More

In today's data-driven world, having the right tools can make all the difference for small businesses seeking to gain a competitive edge. This was certainly the case for a small data analyti… Read More

Devart is glad to announce the release of the new versions of multiple high-performance ADO.NET data providers, LinqConnect, and Entity Developer. The post Entity Framework Core 7 Support i… Read More

Data exchange is the transfer of information from one application or system to another, enabling organizations to share and process information between different platforms and tools. The pos… Read More

A data specialist or a data analyst is the type of specialist who would need to import leads and contacts from Salesforce to Excel. This is because they have the technical skills and knowled… Read More

Connecting to a PostgreSQL database via ODBC (Open Database Connectivity) drivers allows for greater flexibility regarding the programming languages and tools used to interact with the datab… Read More

ASP.Net Core is a popular web development framework with many features for building web modern web applications. One of its many great features is the ability to implement health checks to d… Read More

Configuring PostgreSQL for remote connections is essential for accessing data from different locations. By default, PostgreSQL only allows connections from the local machine, which can be a… Read More

SQL JOINs are a fundamental aspect of relational database management and allow for the retrieval of data from multiple tables based on a specified condition. With the advent of advanced lang… Read More

Modern databases must keep up with dynamic business demands, and it is often a real challenge. The most important requirement is to ensure regular database updating that will preserve all th… Read More

With clear examples and explanations, the article demonstrates how ChatGPT can simplify and streamline the process of creating complex MySQL queries, making it easier for users to interact w… Read More

Hey PostgreSQL users, we’ve got some excellent news for you! There’s a huge update of dbForge Studio for PostgreSQL coming your way. The new incarnation⁠—v3.0⁠… Read More

Here comes the fourth major version of dbForge Data Compare for PostgreSQL, and it packs a bunch of new features and helpful enhancements. From CrossOver-powered support for Linux and macOS… Read More

To catch up with the rest of the dbForge product line for PostgreSQL, Schema Compare has also received a couple of nice features in the newly released v1.3—namely, the option to select… Read More

Connecting Excel, Power BI, Tableau, and Python to Amazon Redshift using an ODBC (Open Database Connectivity) driver is one way to establish a connection between these tools and the Redshift… Read More

Introduction Consider a scenario where you already have an API live and being used by users. Let’s assume you want to enhance existing API capabilities while maintaining existing funct… Read More

We’ve got some good news for you today! The extensive compatibility of our database tools became even broader with a good number of cloud services that you can now seamlessly use with… Read More

Surrogate keys let software developers identify records uniquely in cases where it is impossible to use natural keys. However, what exactly is a surrogate key in SQL? What advantages and dis… Read More

In this article, we are going to talk about the MySQL SUBSTRING() function with its variations. Here, you will find a detailed guide with the basic syntax and examples of how to use this fun… Read More

Is data visualization important? Yes, visual is easier to comprehend than verbal, and graphical data presentation helps us grasp the necessary information easier and dive deeper to make the… Read More

The article will overview the TRUNCATE TABLE statement in SQL on particular examples and describe the differences between the TRUNCATE, DELETE, and DROP statements. When you use the TRUNCATE… Read More

When working with SQL databases for quite a long period of time, you might come across a situation when you need to give your database a different name. It can be done in several different w… Read More

Contents 1. Abbreviation 2. Objective 3. Technology Background 3.1. Power BI Desktop 3.2. Oracle Autonomous Data Warehouse Database 3.3. Devart ODBC for Oracle Driver 4. Prerequisites 5. Arc… Read More

Introduction Testing is an integral element of the development process for every application. There are many types of tests such as unit tests, integration tests, etc. Unit testing is an app… Read More

The article provides a quick way to count the number of all objects grouped by an object type in a SQL Server database using the COUNT() function and the sys.objects system view. In your day… Read More

In MySQL, the ORDER BY clause is used to sort the records fetched by the SELECT statement, in ascending or descending order. And while the usage of this command is simple in basic cases, the… Read More

The dbForge team is thrilled to announce the latest release of its dbForge tools for SQL Server product line. New Year is here soon, and we have a present for you – the entire dbForge… Read More

Formatting makes SQL code accurate, readable, understandable, and standardized for teams and individuals. SQL formatter is a tool that beautifies code automatically. Formatting tools are var… Read More

Want to make git ‘commit’ automatically run every time a database schema is updated? Read more to find out how you can do this with dbForge Schema Compare for SQL Server. In a pe… Read More

We are pleased to announce the release of the update for SecureBridge, version 10.2 – it includes official supports for multiple environments. SecureBridge is a toolset of client and s… Read More

When we speak of modern cloud solutions, we mean much more than just data storage. Cloud technologies include virtual services, including analytics, databases, networking, servers, and stora… Read More

Foreign keys help normalize data in databases and reduce redundancy.  In fact, it is the FOREIGN KEY mechanism that provides the relationality of relational databases. Read on to find o… Read More

This tutorial is to build the Sales Analytics dashboard by leveraging Power BI Desktop, Devart ODBC for Oracle driver and Oracle Database. It will not be used as the instruction on how to wo… Read More

Well, we can’t argue that Windows is the key platform for database development and management software—but what if you are a Mac user? Who said you can’t have equal opportu… Read More

In this article, we will demonstrate to you how to set up automatic email delivery of the log file in both cases: when SQL data and schema comparison goes well and when it fails. The task wi… Read More

MySQL variables store data, label data, and let developers create more accurate and efficient code by turning long and complicated strings of characters into one simple variable. This articl… Read More