dbForge Team posts

SQL-Abfrageoptimierung: Wie man die Leistung von SQL-Abfragen optimiert

In diesem Artikel werden wir untersuchen, wie man SQL-Abfragen optimiert und die Abfrageleistung verbessert, indem man Tipps und Techniken zur Optimierung von SQL-Abfragen verwendet, wie z. B. Ausführungspläne, Indizes, Wildcards u.v.m.

(more…)

Erstellen von Tabellen mit dem MySQL CREATE TABLE-Befehl in dbForge Studio for MySQL

Es gibt zwei Arten, wie man Tabellen in MySQL-Datenbanken erstellen kann:

  • Ausführen einer Abfrage, die einen CREATE TABLE-Befehl enthält
  • Nutzung der entsprechenden Funktionen von MySQL-bezogenen Tools und IDEs
(more…)

Exportieren und Importieren von SQL Server-Datenbankdaten in ein SQL-Skript

Wir stehen recht häufig vor der Aufgabe, Datenbankverzeichnisdaten zu migrieren. Die Datenbank für einen Personalvermittlungsdienst, die wir in der vorangegangenen Artikelserie erstellt haben, bildet dabei keine Ausnahme. In diesem Artikel zeigen wir Ihnen, wie Sie Daten in eine .sql-Datei exportieren und anschließend in die Zieldatenbank importieren können. Sie können entweder die gesamte Datenbank oder bestimmte Objekte migrieren, je nachdem, was Sie vorhaben.

(more…)

How to Create a Table in MySQL

Creating tables is perhaps the most popular task in database development. In this article, we will review the ways of creating MySQL tables.

There are two main ways of creating tables in MySQL databases:

(more…)

PostgreSQL Primary Key: CREATE and ALTER TABLE Statements

Referential Integrity is a must when it comes to proper relational database design. The consistent usage of primary keys can help you ensure the best practices of RDBMS are adhered to. In this article, we are going to focus on using PostgreSQL primary keys while creating a new table or editing the existing one. We will provide you with detailed instructions spiced up with the corresponding code examples and screenshots based on the PostgreSQL GUI tool for better visualization – dbForge Studio for PostgreSQL.

(more…)

How to Debug a Stored Procedure with dbForge Studio for SQL Server

The article provides a detailed overview of the SQL Debugger functionality built into dbForge Studio for SQL Server, a powerful IDE for efficient database development, administration, testing, and deployment boasting superb features and functionalities.

(more…)

What Is the Difference Between SQL and SQL Server?

In the world of data management, SQL and SQL Server are two of the most commonly used terms. However, even though they both contain the term “SQL,” they do not mean the same thing. So, how do SQL and SQL Server differ from one another? That’s exactly what we’ll be talking about in this article.

(more…)

MySQL CONCAT Function: How to Concatenate Strings in MySQL

The MySQL CONCAT function is widely used to concatenate multiple column values into a single column. In this article, we will look into the MySQL CONCAT() syntax, demonstrate to you how to use it, and explore the differences between CONCAT and CONCAT_WS.

(more…)

The Enhanced dbForge Tools for MySQL v9.1 Are Out!

Meet the long-awaited release of dbForge tools for MySQL. We have enhanced them with a few new features that will surely come in handy.  However, the foremost thing in this update is that our tools now can run on Linux and macOS through CrossOver, a solution that helps launch Windows applications on different operating systems.

(more…)

Meet dbForge Studio 2022 for MySQL – Now Available on Linux and macOS

We are happy to announce the new release of our flagship solution for MySQL – dbForge Studio for MySQL – which is now available on Linux and macOS! Check out the updated features and improvements.

(more…)