SQL Server Tools

How to Use SQL Server DBCC SHOW_STATISTICS?

Database statistics are a powerful weapon. They store a vast array of information about the database data that helps identify slow-running queries and allows you to devise an algorithm to optimize query execution. The query optimizer embedded in your SQL Server database uses statistical data to tune execution plans according to the way your data characteristics change. That is why it is vital to keep the statistics up to date and to understand them well. Therefore, in this article, we are going to look at how to collect statistical information and how to interpret it correctly.

(more…)

Database Versioning with Examples

To properly manage the database development process, stay informed of the changes delivered by other developers, and avoid conflicts or missing data in the database, one needs database versioning. This allows you to reconstruct any version of the database, view the history of changes, and ensure smooth database delivery.

(more…)

dbForge Studio for SQL Server Has Been Awarded G2 High Performer Spring 2021

dbForge Studio for SQL Server is an all-encompassing IDE, designed for efficient development, management, and administration of SQL Server databases. It comprises a set of tools that accelerate and automate a number of related tasks, including data and schema comparison, analysis, and reporting. Today we add another valuable entry to the list of its achievements – the G2 High Performer Spring 2021 award.

(more…)

Implement Automatic Migration of SQL Server Databases for DevOps

Quite often, migrating a database proves to be a cumbersome task. You have to control both schema and data changes introduced into the database. If you intend to build a reliable automation pipeline, you need to fully understand the process and use the proper tools to enhance your productivity.

(more…)

Version Control System – Version Control with Git

The article deals with the basics of versioning SQL Server databases and goes into the basics of working with the Git version control system.

(more…)

How to Create Customizable CRUD Operations with SQL Complete

Working with SQL databases and tables usually implies performing daily data-related tasks using the CRUD operations in order to re-use, manipulate, and access data later. For example, you can create a new table, modify, populate the table with data, retrieve and store data for future use, or delete if needed.

(more…)

General Review of Microsoft SQL Server Management Studio (SSMS)

SQL Server Management Studio or SSMS is, perhaps, the most famous product for managing Microsoft SQL Servers and any SQL infrastructure. Many experts consider it the most useful management tool of all. 

(more…)

Devart Products Win Visual Studio Magazine Reader’s Choice Awards 2021

Here come this year’s first awards received by Devart products! The Visual Studio Magazine announced the winners of its 27th annual Reader’s Choice Awards, and we’ve got two products among them. The first one is dbForge Fusion for SQL Server, which was awarded the Bronze badge in the Databases and Data Development and Modeling category. The second one, Entity Developer, scored the Bronze badge in the Software Design, Frameworks, and Modeling Tools category.

(more…)

dbForge Studio for SQL Server Is Ready for DevOps Automation

We’re pleased to present dbForge Studio for SQL Server v6.0 hugely packed with new features and major improvements. Database DevOps integration is one of the most demanded features requested by our users, and today we are making it happen.

(more…)

SQL Server Table Variables Overview

In the article, we are going to explore the basics of SQL Server table variables, compare local temporary table vs global temporary vs table variable, and examine a query execution plan performed with dbForge Studio for SQL Server.

(more…)