SQL Server Tools

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

Implement Automatic Migration of SQL Server Databases for DevOps

Quite often, migrating a database proves to be a cumbersome task. You have to control both schema and data changes introduced into the database. If you intend to build a reliable automation pipeline, you need to fully understand the process and use the proper tools to enhance your productivity.

(more…)

Version Control System – Version Control with Git

The article deals with the basics of versioning SQL Server databases and goes into the basics of working with the Git version control system.

(more…)

How to Create Customizable CRUD Operations with SQL Complete

Working with SQL databases and tables usually implies performing daily data-related tasks using the CRUD operations in order to re-use, manipulate, and access data later. For example, you can create a new table, modify, populate the table with data, retrieve and store data for future use, or delete if needed.

(more…)

General Review of Microsoft SQL Server Management Studio (SSMS)

SQL Server Management Studio or SSMS is, perhaps, the most famous product for managing Microsoft SQL Servers and any SQL infrastructure. Many experts consider it the most useful management tool of all. 

(more…)

Devart Products Win Visual Studio Magazine Reader’s Choice Awards 2021

Here come this year’s first awards received by Devart products! The Visual Studio Magazine announced the winners of its 27th annual Reader’s Choice Awards, and we’ve got two products among them. The first one is dbForge Fusion for SQL Server, which was awarded the Bronze badge in the Databases and Data Development and Modeling category. The second one, Entity Developer, scored the Bronze badge in the Software Design, Frameworks, and Modeling Tools category.

(more…)

dbForge Studio for SQL Server Is Ready for DevOps Automation

We’re pleased to present dbForge Studio for SQL Server v6.0 hugely packed with new features and major improvements. Database DevOps integration is one of the most demanded features requested by our users, and today we are making it happen.

(more…)

SQL Server Table Variables Overview

In the article, we are going to explore the basics of SQL Server table variables, compare local temporary table vs global temporary vs table variable, and examine a query execution plan performed with dbForge Studio for SQL Server.

(more…)

Automated Database Deployment and Releases with Jenkins and dbForge

Introduction into CI process

The modern software development process is impossible without constant improvement. There will be multiple builds for each change, and it is only an accomplished build tested in its entirety that can be pushed to production.

(more…)

Create Full SQL Server Database Backup with dbForge Studio for SQL Server

The backup process is an important link in the chain of successful database administration and robust data protection. In this article, we are going to apply a comprehensive solution from dbForge Studio for SQL Server that allows quick and efficient database backup and restore.

(more…)