SQL Server Tools

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.

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.

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.

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

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.

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.

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.

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.