How To
How to Install and Configure ODBC Drivers on Linux
This article explains how to install, configure, and test Devart ODBC drivers on Debian-based or RPM-based Linux distributions.
Table of contents
What is an ODBC Driver?...
Migrating Data From Oracle to PostgreSQL
In the article, you will learn how to migrate table data from Oracle to PostgreSQL using the dbForge tools.
How to Create Custom SQL Server Replication for Read-only Databases
Quite often there’s a need to create a read-only replica of a SQL Server database. This might be required, for example, for the purpose...
Find and Delete Incomplete Open Transactions in SQL Server – Part 1
Frequently enough, MS SQL Server open transactions are incompleted and their initiators forget about them. This is quite a commonly encountered situation in routine...
How to Create a Pivot Table in PostgreSQL Using the crosstab Function
A typical relational database table contains multiple rows, quite often with duplicate values in some columns. Data in such a table is usually stored...
How to Install and Configure ODBC Drivers on Windows
This tutorial explores how to install 32-bit and 64-bit ODBC drivers in Windows 10 and create a DSN for an ODBC data source.
Table of...
How to Perform Code Review in Visual Studio 2019
Summary: This article will demonstrate how code review workflow in Visual Studio 2019 can be more efficient with Review Assistant. We will introduce you...
How to Generate and Use CRUD Stored Procedures in SQL Server
Most database systems operate based on the four simplest data manipulation operations, which are called CRUD commands in SQL. This acronym stands for Create,...
How to kill certain connections to a MySQL database
Maintenance of databases or servers is quite often performed by database administrators at night. But these routines sometimes get blocked by long-running queries...
How to Access DBF Databases in Delphi
xBase is the generic term for all databases deriving from the original dBase database format (.dbf). The list includes Visual FoxPro, Clipper, dBase III,...
