SQL Server
Get the Latest Update of dbForge Studio for SQL Server With a Few Useful Additions
Here comes a minor yet rather helpful update of dbForge Studio for SQL Server, your favorite IDE that helps you easily handle nearly any...
dbForge Compare Bundle vs Visual Studio Diff Tools: Which One Compares Databases Better?
Identification and management of differences in database objects and actual data is an indispensable part of database management. Without a doubt, you want it...
dbForge Search vs Redgate SQL Search vs ApexSQL Search: A Comparison of SSMS Add-ins
The three times that the word "search" is repeated in the title of this article might seem an overkill, but what can we do?...
How to Compare Two Formatting Styles in dbForge SQL Complete
One of the primary features of dbForge SQL Complete—a top-tier add-in for SSMS and Visual Studio—is code formatting, which helps beautify SQL code and...
What is the Difference Between Schema and Database?
TL;DR
The difference between schema and database lies in their roles: a database stores data, while a schema defines its structure....
SQL Server Architecture: An In-Depth Guide
Microsoft SQL Server has a client-server database architecture, where the process typically begins with the client app sending a request to the server—and continues...
Here Comes the Latest Update of SQL Complete!
It's time to unveil the latest update of dbForge SQL Complete, your favorite code completion add-in for SSMS and Visual Studio. We have enhanced...
dbForge Tools for SQL Server Scored Three More G2 Badges
We've got yet another achievement to tell you about! dbForge SQL Complete and dbForge Studio for SQL Server have been awarded the High Performer...
Another Badge on the Wall: Why G2 Users Love dbForge SQL Complete
More good news coming our way! dbForge SQL Complete, your favorite add-in for SSMS and Visual Studio—packing a punch with its SQL code completion,...
Get the Latest Maintenance Update of SQL Complete 6.9
We have just released a maintenance update of dbForge SQL Complete, an add-in for SSMS and Visual Studio that can accelerate your daily SQL...
Another Day, Another Badge – dbForge Products for SQL Server Win G2 and SoftwareSuggest Awards
We are happy to announce that the dbForge product line has received multiple remarkable awards. dbForge Studio for SQL Server and SQL Complete have...
Don’t Miss the Latest Maintenance Update of SQL Complete 6.9
Here comes the maintenance update of dbForge SQL Complete, your favorite SSMS and Visual Studio add-in for context-sensitive code autocompletion, formatting, and refactoring.
Our team...
How to Export SQL Server Data to an Excel File
If you are in search of the optimal way to export data from SQL Server to Excel spreadsheets, look no further. Just check this...
Understanding a SQL Schema
The article describes the basics of a database schema, the advantages of using schemas, and covers how to create, modify, and delete them in a SQL Server database.
Review SQL Complete on GetApp!
Enjoying dbForge SQL Complete? Why not share your opinion in a review?
This would take just a few minutes of your time yet would be...
Update Your dbForge Tools to Prevent Diagram Control Errors
If you are using any dbForge tools for SQL Server, MySQL, Oracle, and/or PostgreSQL, please make sure you have read this post.
Recently, Microsoft released...
Software Development Life Cycle Tutorial with Examples
SDLC (Software Development Life Cycle) is a series of steps for developing, improving, and sustaining a software system. Learn more about the stages and best practices.
https://blog.devart.com/wp-content/uploads/2024/07/ElevenLabs_2024-07-04T06_53_04_Software-Development-Life-Cycle-Tutorial-with-Examples.mp3
Sometimes we cannot...
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...
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...
How to download and install SQL Server Express edition
The article covers a step-by-step guide describing how to install a SQL Server Express edition on the computer. MS SQL Server Express 2019 is...
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...
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...
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...
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...
Recovering Accidentally Deleted Data with dbForge Transaction Log
Read on about how to recover deleted files using redo and undo scripts generated with the help of dbForge Transaction Log. In addition, the article covers some basics of ACID properties in transactions and best practices for rollback operations.
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...
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...
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...
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...
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...
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....
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 to reuse, manipulate, and access data later. For...
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,...
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...
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...
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...
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,...
Restore SQL Server Database Backup Using T-SQL Script and SSMS
The third article in the series about SQL Server backup and restore will take us through the database restore process and demonstrate the two...
Implementing a Scheduled Automatic SQL Server Backup Process
Now that we have reviewed the backup basics in the first article of our series dedicated to SQL Server backup, let’s proceed to the...
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...
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.”
The typical situation is,...
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,...
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...
Working with Multiple Branches in Source Control
With the help of dbForge Source Control tool that comes as an add-in for Microsoft SQL Server Management Studio and is included in...
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...
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...
Export and Import SQL Server Data to SQL Script (SSMS, CLI, dbForge)
Data migration is a common challenge in the field of database development, management, and administration. This guide will illustrate the process of exporting database data to a .sql file and subsequently importing it into the target database.
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...
Searching for Invalid Objects with SQL Complete
The present article deals with one of the bottlenecks in the work of database developers and administrators, namely the occurrence of invalid objects and...
Database DevOps Tools for Continuous Integration
Over the past few years, CI has come to be one of the best practices for software development. Indeed, it has numerous advantages: including...
