New in Delphi DAC: Support for RAD Studio 11.1 Alexandria, Lazarus 2.2.0, macOS Monterey, and Windows 11.

We are pleased to inform you that we have released new versions of ODAC, IBDAC, PgDAC, MyDAC, LiteDAC, SDAC, VirtualDAC, and UniDAC.

Now, all these Data Access Components support the new RAD Studio 11.1 Alexandria and Lazarus 2.2.0 versions. Besides, the support of Windows 11 and macOS Monterey was added.

Read the rest of this entry »

Understanding PostgreSQL Date Types and Functions (by Examples)

In this article, we will look into working with dates in PostgreSQL, including the various date data types and formats, their functions, and the ways how to deal with them in your everyday routine. We will be using dbForge Studio for PostgreSQL to illustrate the examples.

Read the rest of this entry »

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.

Read the rest of this entry »

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.

Read the rest of this entry »

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?

Read the rest of this entry »

OLEDB vs ODBC: Which Driver to Choose?

Let me guess. You’re here because you’re cracking your brain on which to use. Is it ODBC or OLEDB? It’s kind of confusing because both are used for data access. Is one better than the other? Let’s find out in this face-off article between OLEDB vs ODBC.

Read the rest of this entry »

How to Work With Inheritance in Entity Framework Core

Entity Framework Core from Microsoft is a cross-platform, lightweight, and flexible version of its predecessor, Entity Framework. EF Core is an object-relational mapper (ORM) tool that offers a standardized way of storing and retrieving data to and from diverse data sources.

Read the rest of this entry »

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!

Read the rest of this entry »

Support Ukraine in Her Fight for Freedom!

Dear friends!

On February 24, the world changed forever. The beautiful and peaceful Ukraine was attacked by Russian invaders who wanted to break Her spirit and trample on Her values. But the invaders failed. Ukraine is strong and united like never before.

Read the rest of this entry »

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.

Read the rest of this entry »

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