sql server

It’s Harvest Time: dbForge Reaps G2 High Performer Fall 2021 Awards

September has been around for mere two weeks, yet we have already added 2 new shiny badges to the wall of dbForge awards.

Why not add a couple more, then?

Our flagship database solutions for SQL Server—SQL Complete and dbForge Studio—have both reaped the G2 High Performer Fall 2021 badge.

(more…)

Write a Review of SQL Complete on Capterra!

It should come as no surprise that user reviews on independent reviewing platforms are extremely important to us. It is your review that can make all the difference to a person looking for a reliable database tool to help them cope with daily tasks most effectively. And it is your review that can become the final incentive for them to try it.

(more…)

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

Evgeniy Gribkov

Evgeniy is an MS SQL Server database analyst, developer, and administrator. He is involved in the development and testing of the SQL Server database management tools. Evgeniy also writes SQL Server-related articles.
Evgeniy Gribkov

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