DBA has a number of duties that are primarily targeted at supporting database performance capabilities and data consistency. The administrator can use the CHECKDB command to easily verify data consistency; however, in case they need to find an invalid object in a database schema, some difficulties may occur. Introduction Running smooth operations and ensuring data […]
The post Find Invalid Objects in Your Databases appeared first on Devart Blog.
Last season was quite fruitful in terms of awards scored by our products on independent review platforms. And today, we've got a lot more of those to share. Without further ado, let's get started!
The post Champs Recap: Devart’s Award-Winning Products in Q1 2024 appeared first on Devart Blog.
We will walk you through the process of connecting to SQL Server using Devart SDAC, including installation and examples of how to interact with the components.
The post How to Connect to SQL Server in Delphi with Devart SDAC appeared first on Devart Blog.
This article will explore how to connect to Oracle in Delphi using the Devart ODAC library. We'll cover the installation of Devart ODAC, provide concrete examples of its usage, and even compare it to FireDAC.
The post How to Connect to Oracle in Delphi with Devart ODAC appeared first on Devart Blog.
We will provide step-by-step instructions on installing MyDAC, demonstrate its usage with practical examples, and compare it with FireDAC to highlight its advantages.
The post How to Connect to MySQL in Delphi with MyDAC: A Comprehensive Guide appeared first on Devart Blog.
In the ever-evolving world of database management systems, SQL Server and MySQL stand as two of the most popular and widely-used solutions. Both platforms offer robust features and reliable performance, but which one is the right choice for your needs?
The post SQL Server vs MySQL: Difference, Performance, and Features appeared first on Devart Blog.
Introduction In this article, we are going to see what a Clustered Index is and why it’s very important to understand how tables are organized when using a relational database system. B+ Tree The most common index used in a relational database system is the B+ Tree one. Like the B-Tree index, the B+ Tree is a self-balanced ordered tree data structure. Both the B-Tree and the B-Tree start from a Root node and may have Internal Nodes and Leaf Nodes. However, unlike the B-Tree, the B+ Tree stores all the keys... Read More
The post Clustered Index appeared first on Vlad Mihalcea.
Introduction Welcome to a new issue of the High-Performance Java Persistence Newsletter in which we share articles, videos, workshops, and StackOverflow answers that are very relevant to any developer who interacts with a database system using Java. Articles From version 2.12, Percona PMM uses Victoria Metrics instead of Prometheus. Victoria Metrics provides better disk I/0 utilization and less memory usage. For more details about this change and its benefits, check out this article. By default, the MySQL JDBC Driver only emulates prepared statements. If you wonder whether server-side prepared statements perform better... Read More
The post High-Performance Java Persistence Newsletter, Issue 22 appeared first on …
[Read more]Introduction In this article, we are going to see how the SQL EXISTS operator works and when you should use it. Although the EXISTS operator has been available since SQL:86, the very first edition of the SQL Standard, I found that there are still many application developers who don’t realize how powerful SQL subquery expressions really are when it comes to filtering a given table based on a condition evaluated on a different table. Database table model Let’s assume we have the following two tables in our database, that form a one-to-many... Read More
The post SQL EXISTS and NOT EXISTS appeared first on Vlad Mihalcea.
Introduction In this article, we are going to see how a CROSS JOIN works, and we will also make use of this SQL join type to build a poker card game. Database table model For our poker card game application, we have created the ranks and suits database tables: The ranks table defines the ranking of cards, as well as the name and symbol used for each card rank: The suits table describes the four possible categories used by the French playing cards: Cartesian product In the set theory, the Cartesian product... Read More
The post A beginner’s guide to SQL CROSS JOIN appeared first on Vlad Mihalcea.