studio for sql server

Wie man Testdaten mit Hilfe des SQL Data Generators erzeugt

In diesem Artikel untersuchen wir den Prozess der Befüllung der Mitarbeiterdatenbank mit Dummy-Daten, dessen Schema wir vorab entworfen haben. Das Befüllen einer SQL-Datenbank mit Dummy-Daten kann für die Durchführung von Tests nützlich sein. Der einfachste Weg ist die Befüllung von SQL-Tabellen mit Zufallsdaten mit Hilfe von Tools zur visuellen Datengenerierung.

(more…)

Another Day, Another Badge – dbForge Products for SQL Server Win G2 and SoftwareSuggest Awards

We are happy to announce that the dbForge product line has received multiple remarkable awards. dbForge Studio for SQL Server and SQL Complete have won two badges each: both G2 and SoftwareSuggest users found these Devart products to be among the best of their kind. This is yet another proof that Devart is able to constantly evolve and adjust to the market demands.

(more…)

dbForge Studio for SQL Server Earns Crozdesk Happiest Users Award

Hardly had the winter started when dbForge Studio for SQL Server received yet another award. According to Crozdesk users, the IDE has everything you might need to set up your SQL development environment, manage and develop SQL Server databases.

(more…)

Creating Stored Procedure for Dropping Local Temporary Tables in SQL Server

In this final part of the three-part article series, we will review creating a script, wrap it in a stored procedure, and will use it for deleting all local temp tables and one particular local temporary table.

(more…)

dbForge Studio for SQL Server Has Been Awarded G2 High Performer Spring 2021

dbForge Studio for SQL Server is an all-encompassing IDE, designed for efficient development, management, and administration of SQL Server databases. It comprises a set of tools that accelerate and automate a number of related tasks, including data and schema comparison, analysis, and reporting. Today we add another valuable entry to the list of its achievements – the G2 High Performer Spring 2021 award.

(more…)

Working with Multiple Branches in Source Control

With the help of dbForge Source Control tool that comes as an add-in for Microsoft SQL Server Management Studio and is included in dbForge Studio for SQL Server, you can quickly connect databases you’re working on to your version control system of choice and easily switch between different branches.

(more…)

How to Generate Test Data with the Help of SQL Data Generator

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 Examples

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

(more…)

Is UNPIVOT the Best Way for Converting Columns into Rows?

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

(more…)

Pimp the database diffs management with new dbForge Studio for SQL Server v5.8

We are glad to announce that we have just rolled out the new dbForge Studio for SQL Server, v5.8. This version features massive improvements of data and schema comparison features, including redesigned diffs presentation, and provides as convenient and effective management and deployment of data and schema diffs as never before. (more…)