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.
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…)