SQL Server Tools

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.

Explore the most popular database design tools that aid users in visualizing, refining, and converting database schemas into functional databases.

This article explores various methods to view and analyze transaction logs, including SQL Server's native capabilities and third-party graphical user interface (GUI) solutions.

In this article, we will explore how to recover recently closed tabs and documents using built-in features of SSMS as well as third-party solutions like dbForge SQL Complete.

SQL column aliases are the secret to clearer code and more user-friendly query results. Assigning custom names to database objects in SQL scripts results in improved readability and valuable insights into data. In this article, we'll explore the power of SQL aliases, their practical applications, and the benefits they bring to database management and reporting.

Is data visualization important? Yes, visual is easier to comprehend than verbal, and graphical data presentation helps us grasp the necessary information easier and dive deeper to make the right decision.

When we speak of modern cloud solutions, we mean much more than just data storage. Cloud technologies cover virtual services, including analytics, databases, networking,...

In this article, we will demonstrate to you how to set up automatic email delivery of the log file in both cases: when SQL...

The main purpose of SQL Server ports is to receive and transmit data of a certain type. In this article, we are going to...

Occasionally, database developers encounter the necessity to conduct both forward and reverse engineering on their databases and specific database objects, which may involve object...

Okay, so you deal with SQL code in SSMS every day? Then you most probably would not mind doubling your output without investing too...

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...

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...

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...

This article introduces a solution on how to automatically synchronize two SQL Server databases on a schedule. Prerequisites To automate and schedule schema changes, we...

Read this article to know how to use SQL Server Activity Monitor and what other SQL monitoring tools you can use to monitor SQL...

In this article, we are going to export a table from SQL Server to a .csv file using four different tools. Besides, you will...

The article is dedicated to the SQL Server DELETE statement. Here you will find detailed information about how to use the query in order...