dbForge Team posts

WHERE Condition in MySQL with 16 Different Query Examples

In this article, we are going to talk about the WHERE clause and how to use it in MySQL. Besides SELECT, the scope of the WHERE clause includes the UPDATE and DELETE statements. The WHERE clause is indispensable for quality work with MySQL databases. That’s why the current article will deal with this clause and explore its distinguishing features in-depth.

(more…)

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 as the SQL Server receives and processes the request, and then returns the required result.

(more…)

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 here, you may ask us: why should you bother switching? What should dbForge Studio ever offer to make you leave the convenient familiarity of SSMS?

(more…)

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 it with a few new functions that will surely come in handy. Let’s check them out!

(more…)

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 Spring 2022 badges on G2, the world’s largest tech marketplace for business software. Additionally, dbForge Studio for SQL Server has been included by G2 in their Small-Business Grid Report as a High Performer.

(more…)

The DevOps Mindset: 3 Ways to Motivate DBAs to Use DevOps

Nowadays, DevOps is a key technology in the world of software development. With the advent of microservices and cloud technologies, the delivery process of software has been modified much. IT companies are actively involving DevOps Engineers in creating and maintaining a competitive product on the market.

(more…)

MySQL vs Postgres Comparison: Differences, Performance, and Syntax

When it comes to choosing the database management system, different questions might arise. It is crucial to find the DBMS that meets your needs and shows the highest effectiveness while solving the challenges you face. In this article, we are going to discuss the differences between PostgreSQL and MySQL database management systems.

(more…)

The Future of Database DevOps: Latest Trends and Challenges for 2022

Today we cannot imagine software development and deployment processes without applying the DevOps methodology. This methodology is focused on establishing the interaction between developers and system administrators in a company. Thereby, the DevOps practice creates a smooth development circle and speeds up the delivery of a software product.

(more…)

Oracle CREATE TABLE Command in PL/SQL with 10 Examples

In this article, we are going to talk about the CREATE TABLE command. To be more precise, we will focus on how to create a table in Oracle with a primary and foreign key, as well as not null and date columns, take a close look at how to create a new table on a basis of the existing one, and more. Also, we will review the perks and benefits of using dbForge Studio for Oracle when working with tables.

(more…)

SQL SELECT Statement

SQL SELECT is probably the most widely used SQL statement. That’s why we have decided to investigate options that can be used in the query.

Besides, the article contains a bunch of use cases of the SELECT statement with practical examples and lists three simple ways to retrieve data with the help of dbForge Studio for SQL Server.

(more…)

Your subscription could not be saved. Please try again.
Confirm your email by clicking the link in your inbox!

Subscribe to our blog

to get the latest posts delivered to your inbox