How To
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 use it for deleting all local temp tables and one particular local temporary table.
(more…)How to Compare Multiple Databases from the Command Line
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 line.
(more…)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 require the iODBC driver manager, but it appears that the current version only supports the x64-86 Intel architecture.
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 track of file name changes and easily see which files were moved and where.
(more…)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 MySQL database. Learn the basics of user account management and find hints.
(more…)Creating a New Database in MySQL: Tutorial with Examples
The article provides a detailed overview of how to create a database in MySQL using different methods and tools (including the Command Line, Workbench, and dbForge Studio for MySQL).
(more…)How to Write Complex Queries in SQL Server
One of the regular jobs performed by a database administrator and developer is creating and executing queries of higher complexity to resolve complicated tasks. This requires extra caution and seriousness because any inaccuracies in the code can result in undesirable bugs and application downtime.
(more…)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 implement this statement visually using dbForge Query Builder.
(more…)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 data and analyze how the performance changes with the database growth.
(more…)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:
- Part I: Version Control with Git
- Part II: Database Versioning with Examples
- Parts III & IV: Database Version Control Using Source Control for SQL Server