dbforge
MySQL UNION Explained: A Tutorial with Practical Examples for All Skill Levels
The SQL language provides a lot of effective operators for retrieving and presenting data from databases. One popular tool is the UNION clause. In this article, we will delve into what the UNION clause is, its benefits, and how to use it effectively in MySQL.
Champs Recap: Award-Winning dbForge Database Solutions in Q1 2023
Now that Q1 2023 is over, it's time to deliver our traditional champs recap and showcase the awards and badges garnered by dbForge solutions on independent review platforms over this period.
Watch Out for a Big New Update of dbForge Tools for MySQL!
Today, we've got some good news for all users of MySQL and MariaDB databases—we are rolling out a rather big update of our dbForge tools for MySQL with quite a few handy enhancements that will make your routine work faster and easier.
How ChatGPT Can Help Database Developers Write Unit Tests for SQL Server
We have already explored the capabilities of the much-hyped ChatGPT in terms of writing SQL JOIN queries and retrieving data from MySQL databases. Now the time has come to take one more step further and scrutinize a more narrow-focused yet crucial topic for database developers—unit testing. We'll see how ChatGPT fares when it comes to writing unit tests for various database objects.
How a Data Engineer Streamlined His Team’s Operations Using dbForge SQL Tools
Recently, we've explored the case when dbForge SQL Complete was adopted by a group of SQL developers working under the banner of a tech company and seeking to get their routine coding done faster. Our today's case dwells on the same idea—but the difference is that this time we'll be dealing with a company of a much larger scale.
How dbForge SQL Complete Enhanced the Collaboration Within Two Development Teams at a Finland-Headquartered Tech Company
It is always interesting to explore a case where dbForge tools are used in a collaborative process. Take SQL Complete, for instance. It was created to make individual SQL developers exceptionally productive and help them write error-free code much faster.
Meet dbForge Edge, Your Ultimate Multidatabase Solution!
If you are a database developer dealing with several projects, it means you have to handle a number of database management systems simultaneously. And for each of these systems, you need to have a proper set of tools at hand. Moreover, the said set of tools must be complete and flexible enough to follow the evolving project and its current requirements.
Empower Yourself With the Brand New dbForge Studio for PostgreSQL v3.0!
Hey PostgreSQL users, we've got some excellent news for you! There's a huge update of dbForge Studio for PostgreSQL coming your way.
Meet the Latest Update of dbForge Data Compare for PostgreSQL – v4.0!
Here comes the fourth major version of dbForge Data Compare for PostgreSQL, and it packs a bunch of new features and helpful enhancements.
How to Rename a SQL Server Database
When working with SQL databases for quite a long period of time, you might come across a situation when you need to give your...
Compare 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...
Champs Recap: Award-Winning dbForge Products in Q2-Q4 2022
Following our previous recap that covered the awards garnered by dbForge products in Q1 2022, and a compelling selection of DBTA 2022 Readers' Choice...
Finden Sie ungültige Objekte in Ihren Datenbanken
DBA hat eine Reihe von Aufgaben, die hauptsächlich darauf abzielen, die Datenbank-Performance und die Datenkonsistenz zu unterstützen. Der Administrator kann den CHECKDB-Befehl verwenden, um...
How to Script Tables with Parent Objects in dbForge Studio for SQL Server
Occasionally, database developers encounter the necessity to conduct both forward and reverse engineering on their databases and specific database objects, which may involve object...
Import/Export Connections Using dbForge Studio for SQL Server
If you need to work with multiple connections, you can easily import them into dbForge products with just a little preparation. Let us show...
Devart Products Become the Winners of DBTA 2022 Readers’ Choice Awards
For the fourth year in a row, Devart solutions are voted winners of the Readers' Choice Awards by the Database Trends and Applications magazine,...
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...
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...
dbForge Studio for SQL Server Scored 3 Crozdesk Awards
Today we would like to tell you more about the three awards that dbForge Studio for SQL Server has recently scored on Crozdesk, one...
Champs Recap: Devart’s Award-Winning Products in Q1 2022
It's time for a brief recap that covers all the badges that dbForge products for MySQL, Oracle, and PostgreSQL were awarded in Q1 2022—all...
The Difference Between an IDE and a Code Editor
How would you like to get your daily coding done? Fast? Obviously. In neither repetitive nor monotonous manner? Naturally. With all of the tools,...
How to Switch From SSMS to dbForge Studio Effortlessly
If you are reading this, chances are that you are an active user of Microsoft SSMS. And following the title that has brought you...
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...
One More Achievement in the New Year: dbForge Studio for Oracle Got Two G2 Badges
We are excited to announce that dbForge Studio for Oracle won two G2 badges, which further prove how valuable it is to our users....
Here Comes dbForge Studio 4.4 with the Updates You Don’t Want to Miss!
Meet the latest update of dbForge Studio for Oracle! It packs quite a punch that we believe you will find interesting: updated connectivity, a...
How to Create, Update, and Drop Views in PostgreSQL
The definition of a view in PostgreSQL—and in other SQL database management systems, for that matter—is rather simple: a view is a virtual table...
InnoDB vs MyISAM: A Detailed Comparison of Two MySQL Storage Engines
If you are looking to improve the performance of MySQL databases in your software, you may need to know all the differences between InnoDB...
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...
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...
dbForge Product Line Is Ready for Windows 11
Following our recent announcement that dbForge tools for SQL Server were updated and tested for seamless work on Windows 11, we hurry to make...
SSMS Tools Pack vs dbForge SQL Complete: A Clash of SSMS Add-ins
Undoubtedly, SSMS is a proven database management and administration tool that does its job well. Yet we all tend to expand our capabilities as...
Topping the Charts Again: dbForge Studios Awarded G2 High Performer & Leader Fall 2021
More good news coming our way!
It is inspiring to see that all the hard work we put into our products pays off as happy...
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...
Detailed Review of Two Best Visual Studio Plugins for Oracle Database
The article deals with the Visual Studio add-ins for Oracle database development and management and provides an extensive comparison of two contenting add-ins for...
How to Rollback Committed Transactions on MS SQL Server
The MS SQL Server database management system suggests that all changes are carried out via transactions. Transactions are created to ensure the ACID requirements:
A...
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...
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...
Meet dbForge Fusion for Oracle, v3.10 with Fresh Connectivity Options
We are delighted to share the great news with our Oracle users - a new version of our Visual Studio plugin for Oracle database...
Automated Database Deployment and Releases with Jenkins and dbForge
Introduction to the CI process
The modern software development process is impossible without constant improvement. There will be multiple builds for each change, and...
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...
Audit and Rollback Transactions Live with dbForge Transaction Log for SQL Server
Today we'd love to unveil a big update of dbForge Transaction Log for SQL Server. This tool was designed to provide detailed information on...
How to Check SQL Server Query History
The data stored in the history of queries are among the most valuable for any DBA. Tracking back the SQL Server query history 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,...
Devart Joins the Winners of 2020 ComponentSource Bestselling Awards
The response and appreciation of our users make our company proud of the database solutions we create. This time Devart gladly joins the ranks...
Compare and Find Data Differences Between Two Tables in SQL Server with SSIS and dbForge Tools
Systems often work with distributed databases that contain distributed tables. Distribution is supported by various mechanisms, including replication. In this case, it is...
How to View the SQL Server Transaction Log with the dbForge Transaction Log Reader Tool
Just like any information system, databases are constantly changing. Quite often you need to roll back some operations. There is undoubtedly an opportunity to...
