SQL Server Tools

Database DevOps Tools for Continuous Integration

Over the past few years, CI has come to be one of the best practices for software development. Indeed, it has numerous advantages: including high speed of product development, good code quality, enhanced communication between team members, and increased reliability of the process.

(more…)

How to export and import JSON data via dbForge Data Pump for SQL Server

In the previous articles, we studied the basic rules of SQL database design, created a database schema diagram for a recruitment service, and filled the newly-created database with test data on employees.

(more…)

How to generate test data with the help of the SQL Data Generator Tool?

In this article, we will examine the process of populating the employee database with dummy data, whose schema we designed in the previous part. Filling a SQL database with dummy data can be very useful when we want to run some tests. The most convenient way is the population of SQL tables with random data with the help of visual data generation tools.

(more…)

SQL Database Design Basics with Example

It is a common practice that a DB architect has to design a relational database tailored to a particular solution.

(more…)

New Git client is implemented in dbForge Source Control v2.2

We are thrilled to announce that a new version of  Source Control – our advanced SSMS add-in for SQL Server database change management – has been released. The most notable feature of this release is the support for a new Git client – Git for Windows.

(more…)

Find invalid objects in SQL Server databases

In the course of time, we can experience situations when some certain database objects have not been distributed on one or several databases or database instances. This can happen for a number of reasons. An example of that would be a case when a stored procedure refers to a nonexistent table. In this article, we are going to take a closer look at the issue of how to find invalid objects in SQL Server databases with the help of dbForge SQL Complete.

(more…)

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