Operations | Monitoring | ITSM | DevOps | Cloud

SQL NTILE Function Explained with Practical Examples

NTILE in SQL transforms raw lists into structured distributions before they reach a dashboard. By pushing distribution logic upstream, it divides ordered rows at the query level, so the insights in Power BI, Tableau, or Excel are accurate, not just polished visuals. This guide explores its syntax, practical examples, and comparisons with other ranking functions. It also highlights how database IDEs bring NTILE insights directly into analysis and reporting workflows. Table of contents.

SecureBridge 11.0, EntityDAC 3.5, and dbExpress Drivers: Latest Versions Released

We are excited to announce a new release of SecureBridge, EntityDAC, and the dbExpress product line. This update introduces support for the newest RAD Studio version, enhances compatibility with popular databases, and adds new components and options to simplify development and strengthen security.

Authentication Methods and Features in Microsoft Entra ID

What is Microsoft Entra ID, and why is this important in the database ecosystem? If you have ever used the Microsoft Authenticator app, you’ve already seen how the MS Entra ID works, but only a fraction of it. Microsoft Entra Identity (formerly Azure Active Directory) is a modern identity platform that unifies authentication, strengthens access controls, and integrates with the applications and databases businesses rely on most.

dbForge Hits a New Milestone With 2025.2!

A new milestone is achieved with the release of dbForge 2025.2! This time, it brings you enhancements in dbForge AI Assistant, long-awaited user interface improvements, and further significant advancements across dbForge tools for SQL Server, MySQL/MariaDB, Oracle, PostgreSQL. Interested in learning more? Let’s get started!

Major DAC Update: Expanded Database Support, Enhanced Security, and AI-Powered Features

We are thrilled to announce a significant update across our DAC (Data Access Components) product line. This release focuses on expanding compatibility with the latest development environments, extending support for modern databases, strengthening security, and adding powerful new functionality for AI-driven applications.

Building a .NET PostgreSQL MCP Server for Claude Desktop

Querying PostgreSQL in plain English is no longer a futuristic idea; it’s something you can build today. With a Model Context Protocol (MCP) server, Claude Desktop connects securely to external systems, including databases, through a structured interface. Here, MCP acts as the bridge between Claude and PostgreSQL, allowing it to run queries, explore schemas, and return results instantly in Markdown. This guide walks you through building that bridge in C#.

Best Practices for SQL Formatting: Write Clear and Consistent Code

Inconsistent SQL formatting is a silent productivity killer. The database will execute it, but for developers, poorly structured queries lead to slower reviews, harder debugging, and errors that slip through unnoticed. Over time, this lack of consistency compounds into costly technical debt. This guide shows how to format SQL code so it remains clear, consistent, and easy to maintain.

How to migrate data from Snowflake to SQL Server using SSIS

Learn how to connect SSIS to Snowflake, access your cloud data warehouse, and load data into SQL Server using Devart SSIS Data Flow Components. This clear, step-by-step guide covers setting up the connection, selecting and previewing Snowflake data, and running smooth, efficient data transfers—all without coding. Ideal for data professionals looking to simplify Snowflake integrations with SSIS.

ClickUp Integration Guide

ClickUp integration has become a key driver of operational efficiency for over 3 million teams worldwide. By connecting the ClickUp platform with business applications, organizations simplify operations, eliminate manual handoffs, and give leaders the visibility needed to act with confidence. But achieving these outcomes requires a stable integration approach because not all methods offer the same flexibility or access.