dbForge Team posts

Meet SQL Tools v6.0 with Massive Updates

We are delighted to inform our dbForge for SQL Server users that we have just released the hugely updated pack of our SQL Server tools, dbForge SQL Tools, v.6.0. Take a sneak peek of new features and improvements introduced in this release!

(more…)

Detailed Review of Two Best Visual Studio Plugins for Oracle Database

The article deals with the Visual Studio add-ins for Oracle database development and management and provides an extensive comparison of two contenting add-ins for the aforesaid purpose, dbForge Fusion for Oracle and Oracle Tools for Visual Studio.

(more…)

How to Automatically Synchronize Multiple Databases on Different SQL Server Instances

In this article, we share a step-by-step guide on how to compare the schema and data of multiple SQL Server databases from the command line.

(more…)

dbForge Source Control versus Visual Studio Version Control: What’s Different?

Having a database under source control brings huge benefits. Therefore, we decided to review and compare two popular version control tools, dbForge Source Control add-in for SSMS and Visual Studio Version Control, to help you pick a tool that meets your needs best.

(more…)

Storage Engines in MySQL

This article focuses on the database storage engines for MySQL that ensure appropriate performance and manage SQL operations for multiple table types. The article examines the differences between the most widely used MySQL storage engines.

(more…)

How to Create a New User Account in MySQL and Grant Permissions on a Database

This article provides a complete overview of how to create a new user account in MySQL and grant different types of privileges on a MySQL database. Learn the basics of user account management and find hints.

(more…)

Creating a New Database in MySQL: Tutorial with Examples

The article provides a detailed overview of how to create a database in MySQL using different methods and tools (including the Command Line, Workbench, and dbForge Studio for MySQL).

(more…)

How to Write Complex Queries in SQL Server

One of the regular jobs performed by a database administrator and developer is creating and executing queries of higher complexity to resolve complicated tasks. This requires extra caution and seriousness because any inaccuracies in the code can result in undesirable bugs and application downtime.

(more…)

SQL INSERT INTO Statement – Overview with Examples

The article presents a step-by-step guide to SQL INSERT INTO statement. You will learn the basic principles underlying this command and see how to implement this statement visually using dbForge Query Builder.

(more…)

How to Speed Up Populating Tables with a Large Amount of Random Data for SQL Server Performance Testing

Very often, developers and QAs need to load a large amount of test data to assess the speed of populating the database with generated data and analyze how the performance changes with the database growth.

(more…)