Following our previous recap that covered the awards garnered by dbForge products in Q1 2022, and a compelling selection of DBTA 2022 Readers’ Choice Awards, we believe now is the perf… Read More

We are glad to announce the release of new versions of some ODBC drivers for databases and cloud applications. Added support for the latest version of macOS 13 Ventura. Added support for Pos… Read More

It may be news to many database developers and administrators that SQL Server actually performs better on Linux. In this article we will go into how to install SQL Server and SQL Server comm… Read More

We are excited to announce the release of new ODBC Drivers. Devart ODBC drivers allow easy access to these sources from various ETL, BI, reporting, and database management tools and programm… Read More

We are pleased to announce the release of macOS and Linux for the Dynamics 365 ODBC driver — a high-performance connectivity tool with enterprise-level features for accessing Dynamics… Read More

The main purpose of SQL Server ports is to receive and transmit data of a certain type. In this article, we are going to talk about what kinds of ports there are, what are the difference is… Read More

Hey, you there. Yes, you! There’s something going on; something in the air – and you’re one click from all the info. Come on in! Now, after getting your full attention, tha… Read More

DBA hat eine Reihe von Aufgaben, die hauptsächlich darauf abzielen, die Datenbank-Performance und die Datenkonsistenz zu unterstützen. Der Administrator kann den CHECKDB-Befehl ver… Read More

In the article, we are going to provide a brief overview of the Oracle data types, namely character, NUMBER, DATE, binary (LOB, RAW and LONG RAW), ROWID and UNROWID, and XML data types. We w… Read More

Linux has a reputation as an operating system for programmers. So, if you are a software developer who designs MySQL-based solutions, chances are high that you will do it on Linux. Thus, it… Read More

In this article, we will talk about Windows Management Instrumentation (WMI) technology. Also, we will discuss how to work with it in C# and store the hardware details of your computer in a… Read More

In this article, we will discuss how to configure a DSN and connect to Stripe from Python, PHP, and Power BI using the ODBC driver for Stripe. Devart ODBC Driver for Stripe is a  high-p… Read More

Now and then, every database developer faces the need to perform both forward and reverse engineering on their databases and individual database objects. Let’s say you have the task of… Read More

This article explains how to connect to Snowflake using ODBC Driver for Snowflake and make a trace log on Windows, macOS, and Linux operating systems. Besides, you will also know how to acce… Read More

In diesem Tutorial erfahren Sie, wie Sie 32-Bit- und 64-Bit-ODBC-Treiber auf Windows 10 installieren und einen DSN für eine ODBC-Datenquelle erstellen können. Was ist ein ODBC-Trei… Read More

Entity Framework Core is an open-source, popular, lightweight, and flexible cross-platform ORM. In Entity Framework Core (also called EF Core), a Db context is an object that coordinates que… Read More

If you need to work with multiple connections, you can easily import them into dbForge products with just a little preparation. Let us show you how it’s done with dbForge Studio for SQ… Read More

In Oracle, an index is a database object that creates and stores records for all values in specific columns or clusters. With the help of indexes, users can access the necessary data portion… Read More

We are pleased to announce the release of our dbExpress driver for SQL Server, PostgreSQL, SQLite, and InterBase. Now, all drivers support RAD Studio Alexandria Release 2. The dbExpress driv… Read More

Okay, so you deal with SQL code in SSMS every day? Then you most probably would not mind doubling your output without investing too much raw effort. Instead, you would like to work smart, wo… Read More

This short guide describes the connectivity to the Asana database and how you can easily retrieve and review its data with the Tableau, Excel, or Power BI tools using the ODBC driver for Asa… Read More

This article talks about REST concepts, the RESTSharp library, and how it can be used to work with RESTful APIs in ASP.NET 6. We’ll use a PostgreSQL database using Devart dotConnect fo… Read More

The article explains how to connect to the HubSpot database and retrieve its data using the Tableau, Excel, and Power BI tools and the ODBC driver for HubSpot. Devart ODBC Driver for HubSpot… Read More

Devart ODBC Driver for HubSpot is a high-performance connection solution with enterprise-level functionality. With it, you can connect to HubSpot from reporting, analytics, BI, and ETL appli… Read More

We are excited to present the updated version of Review Assistant with support for Visual Studio 2022. Now you can easily integrate the code review process into the latest version of Visual… Read More

We are pleased to announce the release of Excel Add-ins version 2.7. The update includes official Windows 11 support, multiple security, and performance improvements. The release addresses g… Read More

We are glad to announce the release of new versions of UniDAC, PgDAC, MyDAC, SDAC, ODAC, IBDAC, LiteDAC, and VirtualDAC. In new versions, we have supported the RAD Studio 11 Alexandria Relea… Read More

For the fourth year in a row, Devart solutions are voted winners of the Readers’ Choice Awards by the Database Trends and Applications magazine, which is one of the leading media focus… Read More

It’s time to unveil a big update of dbForge Studio for SQL Server, dbForge SQL Complete, and dbForge SQL Tools, your go-to solutions for fast and effective tackling of your routine dat… Read More

When working with databases, data conversion is an important aspect. It is an efficient way to manage and organize data into different data types so that they can be synchronized on multiple… Read More

In diesem Artikel untersuchen wir den Prozess der Befüllung der Mitarbeiterdatenbank mit Dummy-Daten, dessen Schema wir vorab entworfen haben. Das Befüllen einer SQL-Datenbank mit… Read More

In diesem Artikel werden wir untersuchen, wie man SQL-Abfragen optimiert und die Abfrageleistung verbessert, indem man Tipps und Techniken zur Optimierung von SQL-Abfragen verwendet, wie z… Read More

Es gibt zwei Arten, wie man Tabellen in MySQL-Datenbanken erstellen kann: Ausführen einer Abfrage, die einen CREATE TABLE-Befehl enthält Nutzung der entsprechenden Funktionen von M… Read More

Wir stehen recht häufig vor der Aufgabe, Datenbankverzeichnisdaten zu migrieren. Die Datenbank für einen Personalvermittlungsdienst, die wir in der vorangegangenen Artikelserie ers… Read More

The release addresses the developers’ potential challenges when using the BigCommeerce ODBC drivers on systems with no prior official support.   Now it takes less effort to p… Read More

Referential Integrity is a must when it comes to proper relational database design. The consistent usage of primary keys can help you ensure the best practices of RDBMS are adhered to. In th… Read More

The article provides a detailed overview of the SQL Debugger functionality built into dbForge Studio for SQL Server, a powerful IDE for efficient database development, administration, testin… Read More

In the world of data management, SQL and SQL Server are two of the most commonly used terms. However, even though they both contain the term “SQL,” they do not mean the same thin… Read More

The MySQL CONCAT function is widely used to concatenate multiple column values into a single column. In this article, we will look into the MySQL CONCAT() syntax, demonstrate to you how to u… Read More

SSIS MultiCast could be the easiest transformation component. Why? You simply drag it into the Data Flow. Then, point the source to it and point it to one or more transformation or destinati… Read More

Meet the long-awaited release of dbForge tools for MySQL. We have enhanced them with a few new features that will surely come in handy.  However, the foremost thing in this update is th… Read More

We are happy to announce the new release of our flagship solution for MySQL – dbForge Studio for MySQL – which is now available on Linux and macOS! Check out the updated features… Read More

Throttling and rate limiting restrict API access, but they serve different purposes. While rate limiting can limit API usage to ensure stability, throttling prevents users from accessing you… Read More

We are excited to announce the release of new ODBC Drivers. Devart ODBC drivers allow easy access to these sources from various ETL, BI, reporting, and database management tools and programm… Read More

SSIS DateTime expressions are mostly a part of daily ETL tasks. And the functions that come to mind are DATEPART, DATEADD, and DATEDIFF. But what are the tricks to better use these functions… Read More

Consider this simple Integration Services package. It’s simple because the task is to upload a CSV file to SQL Server. No transformations. Notice the warning in the OLE DB Destination… Read More

When we plan to develop any web-based application using the .NET Framework, we need to use the ASP.NET for development. But, while we are using ASP.NET for any application development, we ca… Read More

Following the recent release of dbForge SQL Complete, we have rolled out a similar update for the entire SQL Tools bundle. Now every add-in and standalone tool it contains is compatible with… Read More

dbForge Source Control for SQL Server is an SSMS add-in that enables database version control and is compatible with the biggest version control systems, including Git, Mercurial, SVN, TFVC… Read More

You can’t make an SSIS Derived Column useful without expressions. So, how do you write one? This article will give you tips on using derived column transformation. Here’s what we… Read More

In 2022, Oracle is still the world’s most popular database management system, and it is not going to lose its position anytime soon. Learning Oracle is obligatory for database speciali… Read More

In this tutorial you’ll discover what PostgreSQL materialized views are and in what cases you should consider working with them. Moreover, you will get familiar with a convenient IDE b… Read More

This article covers cron jobs and how we can leverage Quartz.Net to schedule cron jobs in ASP.NET 6. It shows how we can store messages in a PostgreSQL database using Devart for PostgreSql… Read More

We are glad to announce the release of SecureBridge 10.1 with the support for macOS Monterey, Windows 11, RAD Studio 11.1 Alexandria, and Lazarus 2.2.0. In this release, we also supported th… Read More

A database scripts folder is a set of scripts that represent a database schema and, optionally, the data contained within. Scripts folders can be used to compare and deploy SQL Server databa… Read More

The article provides a general overview of the databases in simple terms, discusses their advantages and drawbacks, and covers the types of data to be used in databases to better understand… 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. This update includes an official Visua… Read More

This article explains how to install and configure the ODBC Driver Manager on Windows, macOS, and Linux. Also, it shows how to configure the ODBC data source name. Contents What is ODBC Driv… Read More

The SELECT statement is the most widely used SQL method to find and retrieve data from databases according to particular criteria. No matter which RDBMS you are using, you will need this com… Read More

We’ve got a new update of dbForge SQL Complete, your favorite add-in for SSMS and Visual Studio that helps you write clean SQL code faster, delivering context-sensitive code completion… Read More

Database development is a combination of complex processes that work together in order to create a perfectly balanced (just as all things should be) product. Testing is one of the most impor… Read More

Here comes a minor yet rather helpful update of dbForge Studio for SQL Server, your favorite IDE that helps you easily handle nearly any task related to database development and administrati… Read More

Identification and management of differences in database objects and actual data is an indispensable part of database management. Without a doubt, you want it to get done fast, easy, and wit… Read More

If your occupation has anything to do with databases, you face all kinds of routine tasks on data manipulation every day. Does it mean you have to do them all manually? Of course, not. It wo… Read More

In this article, we would like to introduce one of the rock-solid sets of data access components – the PgDAC or PostgreSQL data access component. PgDAC is a library of components that… Read More

In this article, we’re going to share the MySQL tutorial how to use the MySQL GROUP BY function as well as this function usage together with and without aggregate functions. Contents W… Read More

Are you looking for different ways to test an ODBC connection? In this article, we will discuss 4 easy ways to test the connectivity and show how to do it with examples. In our case, the tes… Read More

There are two types of IFs in MySQL: the IF statement and the IF function. Both are different from each other.  In this article, we will explain their diversities and show usage example… Read More

With the right SQL code completion tools by your side, you can get approximately 2 to 4 times more productive with your daily coding routine, as evidenced by our clients in success stories… Read More

We are pleased to announce the release of macOS and Linux for the Salesforce ODBC driver — a high-performance connectivity tool with enterprise-level features for accessing Salesforce… Read More

The three times that the word “search” is repeated in the title of this article might seem an overkill, but what can we do? The feature itself is absolutely crucial to everyone w… Read More

ADO.NET is a part of .NET Framework that provides access to different types of data sources. ADO.NET supports relational, XML and application data. ADO.NET resides in a layer between data so… Read More

If you want to know everything about SQLite ODBC and how to use it with .NET, you are on the right way. In this article, we will consider the SQLite ODBC driver, SQL ODBC connection string… Read More

Entity Relationship Diagrams are widely used for analyzing database structure and troubleshooting issues with logic or deployment. In this article, we provide a detailed walkthrough of what… Read More

Oracle is one of the most popular relational database management systems famous for its flexibility and convenience for information management. You can easily adjust any Oracle database to m… Read More

One of the primary features of dbForge SQL Complete—a top-tier add-in for SSMS and Visual Studio—is code formatting, which helps beautify SQL code and make it consistent and easy… Read More

Today we would like to tell you more about the three awards that dbForge Studio for SQL Server has recently scored on Crozdesk, one of the world’s top platforms that helps companies fi… Read More

We have been repeatedly asked if UniDAC is better and faster than FireDAC, so we decided to conduct a detailed study of the performance and memory consumption of these two products. Test Env… Read More

Today, we are going to talk about whether schema and database is the same. To be more precise, we will describe the main differences between these two terms in general. After that, we will t… Read More

This article introduces a solution on how to automatically synchronize two SQL Server databases on a schedule. How to set up automatic schema sync between two SQL Server databases Prerequisi… Read More

Read this article to know how to use SQL Server Activity Monitor and what other SQL monitoring tools you can use to monitor SQL Server performance to be aware of possible performance issues… Read More

It’s time for a brief recap that covers all the badges that dbForge products for MySQL, Oracle, and PostgreSQL were awarded in Q1 2022—all owing to the steadily positive response… Read More

How would you like to get your daily coding done? Fast? Obviously. In a neither repetitive nor monotonous manner? Naturally. With all of the tools you might need always at hand? Yes, definit… Read More

We are pleased to inform you that we have released new versions of ODAC, IBDAC, PgDAC, MyDAC, LiteDAC, SDAC, VirtualDAC, and UniDAC. Now, all these Data Access Components support the new RAD… Read More

In this article, we will look into working with dates in PostgreSQL, including the various date data types and formats, their functions, and the ways how to deal with them in your everyday r… Read More

In this article, we are going to talk about the WHERE clause and how to use it in MySQL. Besides SELECT, the scope of the WHERE clause includes the UPDATE and DELETE statements. The WHERE cl… Read More

Microsoft SQL Server has a client-server database architecture, where the process typically begins with the client app sending a request to the server—and continues as the SQL Server r… Read More

If you are reading this, chances are that you are an active user of Microsoft SSMS. And following the title that has brought you here, you may ask us: why should you bother switching? What s… Read More

Let me guess. You’re here because you’re cracking your brain on which to use. Is it ODBC or OLEDB? It’s kind of confusing because both are used for data access. Is one bett… Read More

Entity Framework Core from Microsoft is a cross-platform, lightweight, and flexible version of its predecessor, Entity Framework. EF Core is an object-relational mapper (ORM) tool that offer… Read More

It’s time to unveil the latest update of dbForge SQL Complete, your favorite code completion add-in for SSMS and Visual Studio. We have enhanced it with a few new functions that will s… Read More

We’ve got yet another achievement to tell you about! dbForge SQL Complete and dbForge Studio for SQL Server have been awarded the High Performer Spring 2022 badges on G2, the world&rsq&hell…Read More

We’ve got yet another achievement to tell you about! dbForge SQL Complete and dbForge Studio for SQL Server have been awarded the High Performer Spring 2022 badges on G2, the world&rsq&hell…Read More

Nowadays, DevOps is a key technology in the world of software development. With the advent of microservices and cloud technologies, the delivery process of software has been modified much. I… Read More

When it comes to choosing the database management system, different questions might arise. It is crucial to find the DBMS that meets your needs and shows the highest effectiveness while solv… Read More

Today we cannot imagine software development and deployment processes without applying the DevOps methodology. This methodology is focused on establishing the interaction between developers… Read More

Dear friends! On February 24, the world changed forever. Beautiful and peaceful Ukraine was attacked by Russian invaders who wanted to break her spirit and trample on her values. But the inv… Read More

People are ever more in a hurry. They want their data almost right now. And even more, data is getting bigger and bigger. So, you can’t use good old techniques because they’re &l&hell…Read More

In this article, we are going to talk about the CREATE TABLE command. To be more precise, we will focus on how to create a table in Oracle with a primary and foreign key, as well as not null… Read More

SQL SELECT is probably the most widely used SQL statement. That’s why we have decided to investigate options that can be used in the query. Besides, the article contains some use cases… Read More