dbForge Team posts

How to Create Login, User, and Grant Permissions in SQL Server

In the article, we are going to examine how to create a new user account and grant/revoke permissions and roles on a database object, as well as how to check SQL Server user permissions on the database using T-SQL and dbForge Studio for SQL Server.

(more…)

How to Restore a MySQL Database with Command Line or Restore Tools

The article gives a deep insight into how to restore MySQL database from a backup file using the mysqldump utility and third-party backup and restore tools, such as dbForge Studio for MySQL, MySQL Workbench, and phpMyAdmin.

(more…)

Don’t Miss the Latest Maintenance Update of SQL Complete 6.9

Here comes the maintenance update of dbForge SQL Complete, your favorite SSMS and Visual Studio add-in for context-sensitive code autocompletion, formatting, and refactoring.

(more…)

How to Automatically Track Database Schema Changes With PowerShell Scripts

In the article, you will find a detailed guide on how to automatically monitor a SQL Server database for schema changes and automatically create a report and log file. The examples of scripts to set up the process are provided.

(more…)

How to Export SQL Server Data to an Excel File

If you are in search of the optimal way to export data from SQL Server to Excel spreadsheets, look no further. Just check this article. Here we tried to gather together different methods—any of them could turn out to be useful for your particular case. Without further ado, let’s get started!

(more…)

Understanding a SQL Schema

The article describes the basics of a database schema, the advantages of using schemas, and covers how to create, modify, and delete them in the SQL Server database.

(more…)

PostgreSQL ADD COLUMN Statement to Add One or Multiple Columns To a Table

If you have been looking for a tutorial on the ALTER TABLE command in Postgres, your search ends here. This statement changes the definition of an existing table. In this article, we will be focusing on the ALTER TABLE ADD COLUMN syntax, which narrows down the functionality of ALTER TABLE to a single action: adding a column. We will walk you through different ways of adding a column using the command line, and also, a convenient GUI tool for PostgreSQL.

(more…)

MySQL Performance Monitoring Tools and the Most Important Metrics to Monitor

The article covers the key performance metrics available in MySQL that can help users improve and optimize query performance in MySQL databases. In addition, there is a brief overview of some MySQL performance monitoring tools.

(more…)

How to Create New Oracle Database in 4 Different Ways

This article will describe the steps to create a database in Oracle: from the first preparation activities to using the Oracle CREATE DATABASE syntax. Here, you will find four ways to create a database in Oracle step by step. Two of them will be based on the command line: using the CREATE DATABASE command, as well as generating the CREATE DATABASE script from an existing DB. The other two will describe how to use such GUI utilities as DBCA, and Oracle SQL Developer. This tutorial is relevant for Oracle versions 12c, 11g, 10g, and higher.

(more…)

Relationships in SQL – Complete Guide With Examples

In this article, we are about to take a close look at the SQL Server relations, including one-to-one, many-to-many, and many-to-one relations, and get into details of creating those with the help of dbForge Studio for SQL Server.

(more…)