How To
iODBC Driver Manager for Apple Silicon M1
As you may have heard, Apple has started shipping Macs with its own custom-designed Arm-based chip called M1. ODBC drivers for Mac...
How to Create a New User Account in MySQL and Grant Permissions on a Database
This article provides a complete overview of how to create a new user account in MySQL and grant different types of privileges on a...
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...
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...
