sql server

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

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

Continuous Delivery of Database Changes to SQL Server When Working Remotely

In the process of software product development that involves a database, one of the key points is the possibility of continuous delivery of changes from the development environment to the production environment.

(more…)

SQL Unit Testing Stored Procedure with dbForge Unit Test for SQL Server

Unit testing is an essential component of the database DevOps process. Its primary goal is to test the constituent parts of the database objects in order to identify any malfunctions or flaws early in the project. This approach allows database developers to ensure the changes they have made are verified, and the project will work properly. In our article, we will mainly focus on unit testing a stored procedure in a SQL Server database and exemplify how simple it is to conduct unit tests with the dbForge Unit Test tool.

(more…)

Database Reverse Engineering

In our fast-changing world, observations of certain events, operations, and processes determine the development of business and implementation of any solutions or ideas. Such observations are captured in the form of data usually stored and processed in a database.

(more…)

Devart Becomes the Winner of 2020 CV Magazine Technology Innovator Awards

For more than 15 years, Devart has been developing database tools and data-related solutions. One of its most popular product lines, dbForge, is designed to facilitate and simplify database development, management, and administration for SQL Server, MySQL, Oracle, and PostgreSQL.

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

Devart Joins the Winners’ Circle of 2020 DBTA Readers’ Choice Awards

For the second year in a row, readers of DBTA — a magazine focusing on data, information management, and analytics — choose Devart products as winners among the world’s top solutions for database development, management, and administration.

(more…)