SQL Server Tools
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...
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...
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.
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.
