dbforge
Choosing the Best GUI Client for SQL Databases
Most SQL GUI tools share common features that can enhance one’s experience working with a database. We have listed some of the most important ones, as well as made a short comparison table where we analyze the most popular SQL GUI clients and highlight what they have under the hood.
MySQL RADIANS() Function
MySQL RADIANS() function takes an input value that signifies an angle measured in degrees, transforms this value into radians, and then outputs the converted result.
MySQL REVERSE() Function
In this article, we will explore the REVERSE function in MySQL, focusing on its syntax, practical examples, and fundamental definitions.
MySQL REPEAT() Function
This article aims to provide a thorough understanding of the REPEAT function in MySQL, covering its basic syntax, practical usage through examples, and essential definitions.
MySQL LEAVE Statement
In this comprehensive guide, we delve into the intricacies of the LEAVE statement, a pivotal tool in the realm of MySQL programming.
Meet the Grand New dbForge Studio MySQL 10.0 With Integrated Source Control!
We don't say that quite often, but here is an update to end all updates, one of the biggest bulks of new features and enhancements that dbForge Studio for MySQL has ever seen.
Case Study: How the Engineers of SMD Found a Way to Process Millions of Database Records Faster With dbForge Studio for MySQL
Here comes the success story of Specialized Media Dashboard, a project that comprises an open-source media monitoring system. The specialized media in question encompasses the spheres of journalism, law enforcement, and climate change.
Simplify Your Cross-Database Data Import with dbForge Edge
Microsoft Access is a rather popular relational database system, which nevertheless has a slew of considerable limitations. And if your business requirements grow beyond these limitations, you will need a more advanced solution like Microsoft SQL Server, and your migration from Access to SQL Server will begin with data transfers. This is what we are going to explore in this article.
A New Era for Time-Series Databases: dbForge Studio for PostgreSQL + TimescaleDB
A recent update of dbForge Studio for PostgreSQL has added one more entry to its list of supported databases. We're talking about TimescaleDB, a PostgreSQL fork marketed as "the easiest, fastest, and most cost-effective time-series database." Now it can be seamlessly accessed and managed from the Studio.
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...
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...
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...
