Azure Database for MySQL: How to connect and migrate databases with dbForge Studio for MySQL

In this article, you’ll learn how to connect to Azure Database for MySQL and discover three scenarios of database migration from MySQL to Azure using dbForge Studio for MySQL.

Read the rest of this entry »

New in SecureBridge: Support for the SMTP/SMTPS Protocols

SMTP was supported in SecureBridge

We are excited to announce the release of Devart SecureBridge with support for the SMTP and SMTPS protocols.

Read the rest of this entry »

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 features. Thus, users have a whole bunch of possibilities to achieve their goals with the best-fit solutions. The only challenge remaining is which tool to use.  Read the rest of this entry »

PostgreSQL 13 support in dotConnect for PostgreSQL, LinqConnect, SSIS Components, and Entity Developer

Devart is glad to announce support for the latest PostgreSQL version – PostgreSQL 13 – in the newly released dotConnect for PostgreSQL 7.19 and SSIS Data Flow Components 1.15 as well as in LinqConnect, and Entity Developer products.

Read the rest of this entry »

Audit and Rollback Transactions Live with dbForge Transaction Log for SQL Server

Today we’d love to unveil a big update of dbForge Transaction Log for SQL Server. This tool was designed to provide detailed information on all changes in your SQL Server database, recover data, and easily revert unwanted transactions.

Read the rest of this entry »

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.

Read the rest of this entry »

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.

Read the rest of this entry »

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

Read the rest of this entry »

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.

Read the rest of this entry »

Azure Data Studio vs SSMS: Who’s the Winner?

For 15 years, SSMS has held the title of the top SQL Server database tool. That’s no easy feat, especially in the software world, where things can change faster than you say “blueberry pie.” But then a contender emerged, developed and released by the same Microsoft folks in 2018. It was Azure Data Studio – obviously less mature, weaker in terms of database administration, yet very promising and eager to win its audience. And today, we’re going to put them face to face and find out who’s better.

Read the rest of this entry »

Warning: file_get_contents(/var/www/ failed to open stream: No such file or directory in /var/www/ on line 18