How To
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.
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.
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...
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...
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...
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...
Version Control System – Version Control with Git
The article deals with the basics of versioning SQL Server databases and goes into the basics of working with the Git version control system....
Column-Level SQL Server Encryption Example Using SQL Complete
The article provides an overview of the column-level SQL Server encryption, including the definition of the Always Encrypted feature, the keys it uses,...
MySQL SELECT Statement Basics
The article covers the basic syntax of a MySQL SELECT statement and provides examples that show how to use a MySQL SELECT statement to...
MariaDB Tutorial: An Introductory Guide With Examples
MariaDB is a popular relational database management system (RDBMS) that has a striking resemblance to MySQL. That is why we decided to compare and...
