SQL Server Tools

Champs Recap: Award-Winning dbForge Products in Q2-Q4 2022

Following our previous recap that covered the awards garnered by dbForge products in Q1 2022, and a compelling selection of DBTA 2022 Readers’ Choice Awards, we believe now is the perfect moment to catch up with the rest of the year as it’s coming to a close. We have gathered all of the accolades in one place—and as it turned out, there’s a whole lot of them to tell you about. Now sit back, relax, and enjoy the ride!

(more…)

How to Install SQL Server on Linux (Ubuntu)

It may be news to many database developers and administrators that SQL Server actually performs better on Linux. In this article we will go into how to install SQL Server and SQL Server command-line tools on Ubuntu and show how to connect to the server remotely.

(more…)

What Is an SQL Server Port?

The main purpose of SQL Server ports is to receive and transmit data of a certain type. In this article, we are going to talk about what kinds of ports there are, what are the difference is between them, what is the default SQL port, and many other theoretical things. Moreover, here you will find a practical illustrated guide on how to connect to a port in dbForge Studio for SQL Server.

(more…)

Finden Sie ungültige Objekte in Ihren Datenbanken

DBA hat eine Reihe von Aufgaben, die hauptsächlich darauf abzielen, die Datenbank-Performance und die Datenkonsistenz zu unterstützen. Der Administrator kann den CHECKDB-Befehl verwenden, um die Datenkonsistenz einfach zu überprüfen, falls sie jedoch ein ungültiges Objekt in einem Datenbankschema finden müssen, können einige Schwierigkeiten auftreten.

(more…)

How to Script Tables with Parent Objects in dbForge Studio for SQL Server

Now and then, every database developer faces the need to perform both forward and reverse engineering on their databases and individual database objects. Let’s say you have the task of recreating a table from one SQL Server database in another—and in order to do that, you will need to generate a DDL script of the required table.

(more…)

Import/Export Connections Using dbForge Studio for SQL Server

If you need to work with multiple connections, you can easily import them into dbForge products with just a little preparation. Let us show you how it’s done with dbForge Studio for SQL Server, one of our flagship solutions that help you perform dozens of diverse database development and management tasks from a single IDE.

(more…)

11 Reasons Why You Need dbForge SQL Complete

Okay, so you deal with SQL code in SSMS every day? Then you most probably would not mind doubling your output without investing too much raw effort. Instead, you would like to work smart, work with convenience, and still not feel tired by the end of the day. If that’s correct, we’ve got a solution that will definitely help you get it right, and it’s called dbForge SQL Complete.

(more…)

Devart Products Become the Winners of DBTA 2022 Readers’ Choice Awards

For the fourth year in a row, Devart solutions are voted winners of the Readers’ Choice Awards by the Database Trends and Applications magazine, which is one of the leading media focused on data science, big data, and information management.

(more…)

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

How to Use a CONVERT Function in SQL Server

When working with databases, data conversion is an important aspect. It is an efficient way to manage and organize data into different data types so that they can be synchronized on multiple platforms. This will allow users to access, view, or modify data when required.

(more…)