Friday, December 1, 2023

How to Connect to PostgreSQL in Delphi with Devart PgDAC

We will guide you through the steps to connect to PostgreSQL in Delphi using Devart PgDAC.

How to Create a Pivot Table in SQL Server

Working with databases involves dealing with a substantial amount of data. Every day, database administrators face challenges on how to analyze and summarize this data. Pivot tables can assist in solving this "brainteaser" and improve the efficiency of data analysis and reporting.

Understanding and Implementing Foreign Keys in SQL Server

Managing foreign keys in SQL Server is a critical aspect of database design and maintenance. This article provides a comprehensive guide, covering everything from the creation of foreign keys to effective troubleshooting of any potential issues that may arise during the process.

How to Connect to SQL Server in Delphi with Devart SDAC

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.

New in EntityDAC: Support for RAD Studio 12 Athens, Mobile Platforms Expansion, and More

Devart EntityDAC, ORM for Delphi with LINQ support, product has received a significant update, bringing Rad Studio 12, macOS Sonoma and mobile platforms official support.

New in dbExpress Drivers: Support for RAD Studio 12 Athens, New Database Versions support, and More

Devart dbExpress line of products has received a significant update, bringing Rad Studio 12 and databases updated support to the table.

New in ADO.NET Data Providers, Entity Developer, and LinqConnect: .NET and EF Core support implementation, and more

Devart dotConnect line of products has received a significant update that brings long-awaited .NET 5, 6 and 7 support.

New in Delphi DAC: Support for RAD Studio 12, new versions of SQL Server, Oracle, MariaDB, and PostgreSQL

Devart Delphi Data Access Components line of products has received a significant update, making it even more compatible with the new database versions.

How to Connect to Azure SQL Database

This article explores connecting to Azure SQL Database with such solutions as SSMS, Visual Studio, Power BI, dbForge Studio for SQL Server, and PowerShell.

What Is AWS IAM? How to Connect to Amazon RDS Using IAM Database Authentication

Navigating the security landscape of cloud services can be complex, but AWS IAM provides a robust framework for secure access management. In this article, we'll explore what AWS Identity and Access Management (IAM) is and how it enhances security.