Products
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,...
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....
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...
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...
Dedicated Link Source Control Repository
This is the fifth part of an extensive article dedicated to database versioning. Before you proceed with it, we suggest that you read the...
Database Version Control Using Source Control for SQL Server
There are many solutions for version-controlling databases. We are going to review one of them, namely Source Control which comes in the SQL Tools...
Creating a TFVC Repository in Azure DevOps and Linking It to Source Control
In the article, we'll guide you through the step-by-step process of establishing a TFVC repository in Azure DevOps and linking your database to it using the dbForge Source Control tool.
New Versions of ODBC Drivers for Salesforce, Dynamics 365, and Zoho CRM
We are glad to announce new versions of the ODBC drivers for Salesforce, Dynamics 365, and Zoho CRM. The most notable updates include OAuth...
Using Object Filters to Adjust Schema Comparison
In this article, you will learn how to apply object filters within dbForge Schema Compare for SQL Server to be able to adjust the...
Recovering Accidentally Deleted Data with dbForge Transaction Log
Read on about how to recover deleted files using redo and undo scripts generated with the help of dbForge Transaction Log. In addition, the article covers some basics of ACID properties in transactions and best practices for rollback operations.
