SQL Server Tools

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.

(more…)

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.

(more…)

Overall view of Devart SQL tools for Database CI

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

(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…)

Start debugging in SSMS with SQL Complete 6.4

The dbForge team is thrilled to present the latest version of SQL Complete for SQL Server. The most notable feature of this release addresses the newly introduced debugging functionality designed to take away the pain of combing through scripts to find errors and grant the possibility to debug T-SQL directly in the IDE. From now on, you don’t need to compromise on code quality.

(more…)

Get the most from your data with SQL Complete

Visualize your SQL data to facilitate understanding and decision making with the Data Visualizers feature of SQL Complete. On many occasions, developers and DBAs need to quickly check the table contents and getting data in a readable format without much effort becomes a matter of importance.

(more…)

Benefit from Continuous Integration in Azure DevOps with dbForge Plugin

The Devart team is glad to announce the first release of the Azure DevOps Plugin. Extending the range of supported CI systems, we strive to help the users of dbForge DevOps Automation for SQL Server accelerate database development and get the most out of their DevOps environment.

(more…)

New and redesigned formatting profiles in SQL Complete 6.3

At our users’ request, Devart introduces span-new formatting profiles that let you tune your SQL code like never before. Now you can not only format your code exactly as you want but also switch quickly to an alternative style or apply formatting specifically to certain parts of your SQL script if required.

(more…)

Enjoy Continuous Integration in TeamCity with dbForge DevOps Automation

We are thrilled to inform our users of dbForge DevOps Automation for SQL Server that we have extended the range of supported automation systems with TeamCity.

(more…)