SQL Server Tools
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.
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.