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...
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.
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,...
