SQL Server Tools

Get the Latest Update of dbForge Studio and SQL Tools With Support for SQL Server 2022

It’s time to unveil a big update of dbForge Studio for SQL Server, dbForge SQL Complete, and dbForge SQL Tools, your go-to solutions for fast and effective tackling of your routine database-related tasks. This update delivers support for SQL Server 2022 Community Technology Preview 2.1 (CTP 2.1) alongside extended keyword suggestions and newly supported syntax constructs.

(more…)

Get the New Update of SQL Tools With Support for SSMS 19

Following the recent release of dbForge SQL Complete, we have rolled out a similar update for the entire SQL Tools bundle. Now every add-in and standalone tool it contains is compatible with SSMS 19 Preview 2, the latest preview release of SSMS.

(more…)

How to Compare Two Formatting Styles in dbForge SQL Complete

One of the primary features of dbForge SQL Complete—a top-tier add-in for SSMS and Visual Studio—is code formatting, which helps beautify SQL code and make it consistent and easy to read, understand, review, and share across teams.

(more…)

How to Automatically Synchronize Schema Changes in Two SQL Server Databases on a Schedule

This article introduces a solution on how to automatically synchronize two SQL Server databases on a schedule.

(more…)

SQL Server Activity Monitor for Diagnosing SQL Server Performance Data

Read this article to know how to use SQL Server Activity Monitor and what other SQL monitoring tools you can use to monitor SQL Server performance to be aware of possible performance issues.

(more…)

SQL SELECT Statement

SQL SELECT is probably the most widely used SQL statement. That’s why we have decided to investigate options that can be used in the query.

Besides, the article contains a bunch of use cases of the SELECT statement with practical examples and lists three simple ways to retrieve data with the help of dbForge Studio for SQL Server.

(more…)

How To Export SQL Server Data From Table To a CSV File

In this article, we are going to export a table from SQL Server to a .csv file using four different tools. Besides, you will learn how to export SQL query results with and without headers to a .csv file.

(more…)

SQL Delete Statement: Remove One or Multiple Rows From a Table

The article is dedicated to the SQL Server DELETE statement. Here you will find detailed information about how to use the query in order to remove one or several rows from one or several tables. Also, we will compare DELETE with TRUNCATE because at first glance they may seem to perform the same task.

(more…)