How To

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 global default solution. SQL Server Extended Events apply to the DBMS state monitoring and help DB developers or DBAs to collect information, view it, and analyze it.

(more…)

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 a must in many cases. For instance, there might be a need to investigate a particular work case, check the backup history, or recover a specific query if your SQL Server suffers a crash.

(more…)

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

(more…)

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 eye on any changes made to the databases, resolve conflicts, and roll back to the earlier versions if needed, the good solution will be to use a version-controlling tool. It can also help developers to compare versions and identify what changes have been made and who is the author.

(more…)

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 input data. That’s where the problem of repeated recovery of test data arises. This article offers the simplest way to automate the process using only one tool – dbForge Studio for MySQL.

(more…)

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 dbForge Studio for SQL Server, you can quickly connect databases you’re working on to your version control system of choice and easily switch between different branches.

(more…)

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 static data conflicts with the help of the dbForge Source Control plugin.

(more…)

How to Export and Import SQL Server Database Data to a SQL Script

We quite often face the task of migrating database directory data. And the database for a recruitment service, which we created in the previous series of articles, is no exception. In this article, we are going to demonstrate how you can export data to a .sql file and then import it to the target database. Is it worth mentioning that you can either migrate the whole database or certain objects depending on your purpose.

(more…)

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 the ways of finding them in the SQL Server database.

(more…)

How to Search for Database Objects and Table Data in SQL Server

Hello and welcome to the fourth part of our series of articles that will help you discover how to design and work with databases. This time we are going to delve into an intricate matter of data and object search in SQL Server, which will be further conducted first with the help of standard scripts and after that, using the dbForge Search tool.

(more…)