sql server

Pivot Tables and Reporting in SQL

Quite enough, there’s a need to change how data is displayed in a database so that the users could analyze it more easily. One of the cases of such transformation is transposing data from rows to columns in SQL Server.

(more…)

Compare and Find Data Differences Between Two Tables in SQL Server with SSIS and dbForge Tools

Systems often work with distributed databases that contain distributed tables. Distribution is supported by various mechanisms, including replication. In this case, it is necessary to constantly maintain the synchronization of a particular data segment. It is also necessary to check the synchronization itself. This is when the need to compare data in two tables appears.

(more…)

Is UNPIVOT the best way for converting columns into rows?

To start with, let’s give definitions and highlight the difference between PIVOT and UNPIVOT operators in SQL Server.

(more…)

Meet new Standard edition of SQL Tools

We are delighted to announce the release of the brand new Standard Edition of our SQL Server mega tool pack, dbForge SQL Tools.

(more…)

Find invalid objects in your databases

DBA has a number of duties that are primarily targeted at supporting database performance capabilities and data consistency. The administrator can use the CHECKDB command to easily verify data consistency; however, in case they need to find an invalid object in a database schema, some difficulties may occur.

(more…)

New version of dbForge Source Control for SQL Server released

We are excited to announce that a new version of the SSMS add-in for SQL Server database change management, dbForge Source Control for SQL Server, v2.1, has been just rolled out!

(more…)

Export SQL Stored Procedure to a File and Generate its Script

In previous articles, we have reviewed a general algorithm of finding and deleting incomplete open transactions in SQL Server databases, created a table for fixing incomplete transactions and a CRUD-stored procedure, and implemented numerous settings that will make our document workflow productive and handy.

(more…)

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. 

(more…)

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

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.

(more…)

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