sql server

How to Set Up Version Control of Your SQL Server Database from Scratch

Version-controlling SQL Server databases in GitHub has never been easier with Devart solutions. You can commit and revert changes, view and resolve conflicts, track changes and link static data with convenience. And such tools as dbForge Source Control will help you easily and effectively manage your GitHub repository.

But now let’s go back and see where it all begins. Let’s see how to create a new repo on GitHub and then clone it to your local computer.

(more…)

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

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

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

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

Create Full SQL Server Database Backup with dbForge Studio for SQL Server

The backup process is an important link in the chain of successful database administration and robust data protection. In this article, we are going to apply a comprehensive solution from dbForge Studio for SQL Server that allows quick and efficient database backup and restore.

(more…)

How to Install 15 dbForge SQL Tools in 15 Minutes Using Chocolatey

Getting prepared for work need not take long, no matter whether you deal with physical or digital tools. Undoubtedly, there are better things to spend time on than make your way through a dozen wizards, however simple and convenient they might be. And if you are a SQL database developer or administrator, we can give you a quick example and equip you with a set of 15 top-notch tools in next to no time with even less effort.

(more…)

Introduction to SQL Server Temporary Tables

We all need to refer to temporary tables quite often. They are necessary to deal with interim aggregations or outputting intermediate results. However, it is also essential to delete temporary tables after using them. 

In this article, we’ll examine the basics of temporary tables and define how they differ from table variables. Then, we’ll learn how to delete temporary tables correctly, and we’ll create a stored procedure for deleting temporary tables in a current session.

(more…)

What Is Azure Data Studio and How to Get Started with It?

Azure Data Studio is one of the best-known and most popular solutions for database specialists who work with local and cloud platforms on Windows, macOS, and Linux. This product is a lightweight modern environment for SQL code development with numerous embedded features. Its goal is to simplify the users’ daily tasks and continually improve their professional experience.

(more…)