sql server

Searching for invalid objects with SQL Complete

The present article deals with one of the bottlenecks in the work of database developers and administrators, namely the occurrence of invalid objects and the ways of finding them in the SQL Server database.

(more…)

How to Search for Database Objects and Table Data in SQL Server

Hello and welcome to the fourth part of our series of articles that will help you discover how to design and work with databases. This time we are going to delve into an intricate matter of data and object search in SQL Server, which will be further conducted first with the help of standard scripts and after that, using the dbForge Search tool.

(more…)

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

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