sql server

Meet SQL Tools v6.0 with Massive Updates

We are delighted to inform our dbForge for SQL Server users that we have just released the hugely updated pack of our SQL Server tools, dbForge SQL Tools, v.6.0. Take a sneak peek of new features and improvements introduced in this release!

(more…)

Creating Stored Procedure for Dropping Local Temporary Tables in SQL Server

In this final part of the three-part article series, we will review creating a script, wrap it in a stored procedure, and will use it for deleting all local temp tables and one particular local temporary table.

(more…)

How to Write Complex Queries in SQL Server

One of the regular jobs performed by a database administrator and developer is creating and executing queries of higher complexity to resolve complicated tasks. This requires extra caution and seriousness because any inaccuracies in the code can result in undesirable bugs and application downtime.

(more…)

SQL INSERT INTO Statement – Overview with Examples

The article presents a step-by-step guide to SQL INSERT INTO statement. You will learn the basic principles underlying this command and see how to implement this statement visually using dbForge Query Builder.

(more…)

DBeaver vs HeidiSQL vs dbForge Studio: Comparing Open-Source and Paid SQL Server Tools

If a company has to choose between a free database tool and a paid one, and both of them deliver the same features and performance, it is natural that the paid one doesn’t stand a chance. But what if the free tool doesn’t contain all the necessary functionality for the workflow? What if it has limitations that prevent the employees from becoming more productive? And if it turns out that their work requires either 7 separate, perhaps even hardly compatible free tools, wouldn’t it be more effective to pay for just one tool that would have it all in place?

(more…)

Using Object Filters to Adjust Schema Comparison

In this article, you will learn how to apply object filters within dbForge Schema Compare for SQL Server to be able to adjust the schema comparison and synchronization process to your needs by excluding and including the necessary objects and object types.

(more…)

How to Download and Install dbForge DevOps Automation PowerShell for SQL Server

dbForge DevOps Automation helps automate SQL Server database development, testing, and deployment. It was designed to minimize deployment risks and speed up the release cycle, making the overall workflow safe and consistent.

(more…)

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