Friday, December 8, 2023

Empower Yourself with the Latest SSMS 19.2 and dbForge SQL Tools!

On November 13, 2023, Microsoft's new SQL Server Management Studio (SSMS) 19.2 saw the light of day. It's the IDE you will definitely need if you are dealing with the most modern versions of SQL Server.

Champs Recap: Devart’s Award-Winning Products in Q4 2023

The end of the year isn't all that far away, and it's time to tell you about the latest awards garnered by dbForge database tools. This time we'll be mostly talking about the badges that we've recently scored on G2, one of the world's top platforms where you can both find and review business software.

Devart Announces Python Connectors

Devart Python connectors are reliable connectivity solutions for accessing database servers and cloud services from Python applications.

New BETA ODBC Drivers for Freshservice, SendGrid, Twilio, Shippo, QuickBooks Online and Desktop Now Available 

New ODBC drivers make it easier for users to integrate their data from popular platforms into their workflows, reducing the time and effort required for data analysis and reporting.

Attach SQL Server 2005 .mdf/.ldf Files to 2019 Using dbForge Studio

Migrating databases from older versions to the most recent version of SQL Server is a common and crucial task in the world of database management. This process needs to be executed meticulously and with the right tools to guarantee accurate results.

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.