How To
dbForge Studio for MySQL vs MySQL Workbench
Every single year new products and new versions of the leading tools enter the market. Their providers compete, offering database specialists more and more...
How to Set Up Extended Events in SQL Server
Extended Events is a helpful and convenient solution designed to monitor your system performance. First introduced in SQL Server 2008, it has become the...
How to Check SQL Server Query History
The data stored in the history of queries are among the most valuable for any DBA. Tracking back the SQL Server query history is...
How to Synchronize a Table in SQL Server
Database synchronization is an everyday necessity. You need it regularly when you have several similar databases that serve the same “user.”
The typical situation is,...
Shared vs Dedicated Development Models: Key Differences
Developing databases in a secure and efficient way is very important for each database developer in the team. To maintain and keep an...
How dbForge Studio for MySQL is Involved in the DevOps Process
When developing a software application based upon complex database structure, it is often necessary to run diverse business logic test scenarios on the same...
Working with Multiple Branches in Source Control
With the help of dbForge Source Control tool that comes as an add-in for Microsoft SQL Server Management Studio and is included in...
Version-controlling Static Data: Conflicts
Version-controlling static data is vital to maintaining a normalized database structure. The article presents a simple and comprehensive guide through the process of resolving...
How to Export and Import SQL Server Database Data to a SQL Script
Data migration is a common challenge in the field of database development, management, and administration. This guide will illustrate the process of exporting database data to a .sql file and subsequently importing it into the target database.
Searching for Invalid Objects with SQL Complete
The present article deals with one of the bottlenecks in the work of database developers and administrators, namely the occurrence of invalid objects and...
