How To

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 previous parts:

(more…)

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 pack. As an example, we will use the JobEmplDB database for a recruitment service:

(more…)

Creating a TFVC Repository in Azure DevOps and Linking It to Source Control

The article provides a complete walkthrough to help you create a TFVC repository in Azure DevOps and link your database to the repository via the Source Control tool by dbForge. You will be able to version control your database and keep a history of changes.

(more…)

How to Rollback Committed Transactions on MS SQL Server

The MS SQL Server database management system suggests that all changes are carried out via transactions. Transactions are created to ensure the ACID requirements:

(more…)

How to Download and Install dbForge DevOps Automation PowerShell for SQL Server

dbForge DevOps Automation helps automate SQL Server database development, testing, and deployment. It was designed to minimize deployment risks and speed up the release cycle, making the overall workflow safe and consistent.

(more…)

How to Set Up Version Control of Your SQL Server Database from Scratch

Version-controlling SQL Server databases in GitHub has never been easier with Devart solutions. You can commit and revert changes, view and resolve conflicts, track changes and link static data with convenience. And such tools as dbForge Source Control will help you easily and effectively manage your GitHub repository.

But now let’s go back and see where it all begins. Let’s see how to create a new repo on GitHub and then clone it to your local computer.

(more…)

MySQL JOINs Tutorial with Examples

The article presents a detailed tutorial on MySQL JOINs. In it, you will learn about different types of JOINS that are supported in MySQL, their syntax, and how to use them.

(more…)

How to Use SQL Server DBCC SHOW_STATISTICS

Database statistics are a powerful weapon. They store a vast array of information about the database data that helps identify slow-running queries and allows you to devise an algorithm to optimize query execution. The query optimizer embedded in your SQL Server database uses statistical data to tune execution plans according to the way your data characteristics change. That is why it is vital to keep the statistics up to date and to understand them well. Therefore, in this article, we are going to look at how to collect statistical information and how to interpret it correctly.

(more…)

Database Versioning with Examples

To properly manage the database development process, stay informed of the changes delivered by other developers, and avoid conflicts or missing data in the database, one needs database versioning. This allows you to reconstruct any version of the database, view the history of changes, and ensure smooth database delivery.

(more…)

How to Rename a MySQL Database

Eventually, it appears necessary to change the name of a database in MySQL. For that purpose, we used to apply a simple RENAME DATABASE command that existed in earlier versions of MySQL. However, it became no longer available in the newer versions as it posed risks. The reason was that the RENAME DATABASE query could result in the loss of essential database contents, which clearly was undesirable.

(more…)