SQL Server Tools

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.

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.

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.

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

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.

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.

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.

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.

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

(more…)

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