How To

How to write complex MySQL queries?

Advanced queries aimed to solve complex tasks or multiple tasks constitute an essential part of any database administrator or developer job. MySQL complex queries must be handled with the utmost seriousness since inaccurate MySQL code or poorly performing scripts can cause severe bugs and application failures. 

(more…)

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 of separating analytical and operative tasks. The first cause high load on databases and in order to reduce it, the replica of the primary database is created to perform analytical read-only queries. 

(more…)

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 database development. The most striking example is when one uses SQL Server Management Studio to run a script that starts an explicit transaction with the BEGIN TRANSACTION statement, but then the batch is canceled in the middle of a transaction without issuing a COMMIT or ROLLBACK statement to complete the transaction and the transaction is left open.

(more…)

Pivot Tables in PostgreSQL

A typical relational database table contains multiple rows, quite often with duplicate values in some columns. Data in such a table is usually stored in random order. By running a query to select data from a database table, you can perform filtering, sorting, grouping, selection and other operations with data.

(more…)

Data migration from MySQL to Oracle server

Data migration is a tiresome task requiring a great deal of manual activity. In this article, we will examine how to migrate MySQL data to the Oracle server, using Data Export feature built-in dbForge for MySQL products. In the given worked example, we will move data from the actor table and the query result from the sakila database that exist on MySQL server to the SCOTT schema on Oracle server.

(more…)

Installing and Configuring an ODBC Driver in Windows 10 (32 / 64-bit)

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.

(more…)

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 to some great capabilities of our code review tool. (more…)

How to generate and use CRUD stored procedures in SQL Server

Most database systems operate on the basis of 4 simplest data manipulation operations that are called by the acronym CRUD. This acronym stands for Create, Read, Update, and Delete.

(more…)

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 or applications that hang onto locks much longer than expected.

(more…)

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, dBase IV, and many others. These databases are informally known as dBase clones because they are either direct descendants of dBase or mimick it.
(more…)