Products

Using SQLite ODBC with .NET on Simple Examples

If you want to know everything about SQLite ODBC and how to use it with .NET, you are on the right way. In this article, we will consider the SQLite ODBC driver, SQL ODBC connection string, SQLite database manager with GUI, and code examples in .Net.

(more…)

Create ER Diagram for SQL Server Database Using SSMS and SQL Designer

Entity Relationship Diagrams are widely used for analyzing database structure and troubleshooting issues with logic or deployment. In this article, we provide a detailed walkthrough of what an ER Diagram is and how to create and manage database diagrams.

(more…)

Oracle DROP USER Command with Examples

Oracle is one of the most popular relational database management systems famous for its flexibility and convenience for information management. You can easily adjust any Oracle database to meet your everyday requirements. Sometimes, it is necessary to delete particular users from your Oracle database. Basically, there are two ways of achieving this goal: by using the Oracle DROP USER command or with the help of an Oracle IDE allowing you to automate the process. This tutorial is valid for all Oracle versions starting from 11g-12c and ending with 19c.

(more…)

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 make it consistent and easy to read, understand, review, and share across teams.

(more…)

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 of the world’s top platforms that helps companies find and purchase the best business software for project and customer management, marketing, and accounting. The names of these awards are rather indicative of what all dbForge products stand for — Trusted Vendor, Happiest Users, and Quality Choice.

(more…)

How to Automatically Synchronize Schema Changes in Two SQL Server Databases on a Schedule

This article introduces a solution on how to automatically synchronize two SQL Server databases on a schedule.

(more…)

SQL Server Activity Monitor for Diagnosing SQL Server Performance Data

Read this article to know how to use SQL Server Activity Monitor and what other SQL monitoring tools you can use to monitor SQL Server performance to be aware of possible performance issues.

(more…)

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 owing to the steadily positive response from our users on a variety of review platforms.

(more…)

The Difference Between an IDE and a Code Editor Explained

How would you like to get your daily coding done? Fast? Obviously. In a neither repetitive nor monotonous manner? Naturally. With all of the tools you might need always at hand? Yes, definitely.

Whether you are going to get it all or not depends on where you choose to write your code. Your two primary options here are either a code editor or an IDE. Both are designed to make your coding easier—however, in different ways.

(more…)

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.

(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