Products

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…)

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.

(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…)

Improvements for EF Core Support and Monitoring in dotConnect Providers

Devart is glad to announce the release of the new versions of dotConnect ADO.NET data providers. New versions of Devart products offer significant improvements for Entity Framework Core and make debugging process easier by adding more configuration options to dbMonitor class.

(more…)

Support for More Providers for EF Core in Entity Developer 6.9

Devart is glad to announce the release of Entity Developer 6.9 – a visual ORM designer for a wide variety of ORMs. The new version supports two more third-party providers for Entity Framework Core.

(more…)

Entity Framework Core Spatials Support in dotConnect ADO.NET Providers

The new release of dotConnect ADO.NET providers for Oracle, MySQL, PostgreSQL, and SQLite support Spatial data in Entity Framework Core 3.

(more…)

Devart Joins the Winners of 2020 ComponentSource Bestselling Awards

The response and appreciation of our users make our company proud of the database solutions we create. This time Devart gladly joins the ranks of Top 25 Bestselling Publishers on ComponentSource, based on sales orders placed by their customers over the course of a year.

(more…)