How To
How to download and install SQL Server Express edition
The article covers a step-by-step guide describing how to install a SQL Server Express edition on the computer. MS SQL Server Express 2019 is...
Creating Stored Procedure for Dropping Local Temporary Tables in SQL Server
In this final part of the three-part article series, we will review creating a script, wrap it in a stored procedure, and will...
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...
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...
Tracking Renamed Files
Summary: In this article, we will demonstrate how Review Assistant can significantly simplify tracking renamed or moved files. You will learn how to keep...
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...
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...
