How To
Find and Delete Incomplete Open Transactions in SQL Server – Part 3
In two previous articles, we have reviewed a solution for deleting incomplete open transactions in SQL Server.
By incomplete transaction, we shall basically understand an...
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 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...
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 on the basis of 4 simplest data
manipulation operations that are called by the acronym CRUD. This
acronym stands for Create, Read,...
