Find and delete incomplete open transactions in SQL Server – Part 3

how to delete lost transactions part 3

In two previous articles, we have reviewed a solution for deleting incomplete open transactions in SQL Server. 

Read the rest of this entry »

How to view the SQL Server transaction log with SQL Transaction Log Reader Tool

How To Read Transaction Logs SQL Server

Just like any information system, databases are constantly changing. Quite often you need to roll back some operations. There is undoubtedly an opportunity to restore the database to a specific point in time and you can also undo the latest transactions with both regular and third-party utilities.

Read the rest of this entry »

Installing and Configuring an ODBC Driver on Linux (DEB / RPM)

Installing ODBC driver on Linux

This article explains how to install, configure, and test Devart ODBC drivers on Debian-based or RPM-based Linux distributions.

Read the rest of this entry »

New Versions of ODBC Drivers: Oracle, PostgreSQL, QuickBooks, xBase

New versions of ODBC drivers for Oracle, PostgreSQL, QuickBooks were released with improved compatibility with Power Pivot, Visual Basic, and RStudio.

Read the rest of this entry »

Find and delete incomplete open transactions in SQL Server – Part 2

In the first part of the series of our articles on this subject, we presented the general algorithm for deleting open transactions that are not completed from a SQL Server database and considered the process of creating a table to record incomplete transactions. Now, let’s look at the process of creating a CRUD stored procedure to find and delete active transactions in SQL Server.

Read the rest of this entry »

Entity Developer 6.7 with Console App, .NET Core Support Improvements and More

Devart is glad to announce the release of Entity Developer 6.7 – a visual ORM designer for a wide variety of ORMs. The new version comes with a console application added for convenient development processes automation and improves support for .NET Core development and third-party providers.

Read the rest of this entry »

Migrating data from Oracle to PostgreSQL database

There are several reasons you may want to migrate your databases from Oracle to PostgreSQL:

1. Oracle can be very expensive, with some important features requiring additional investments on top of that.

Read the rest of this entry »

Adopt flawless Continuous Integration into Bamboo with new dbForge DevOps plugin

We are glad to inform our SQL Server users that we have just extended the compatibility of dbForge DevOps Automation for SQL Server with just-released dbForge DevOps Automation Bamboo Plugin for SQL Server.

Read the rest of this entry »

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. 

Read the rest of this entry »

Overall view of Devart SQL tools for Database CI

Devart offers the following tools that are involved in Continuous Integration both directly and indirectly.

Read the rest of this entry »