Columnstore indexes give great performance to queries that scan large sets of rows (millions of rows typically), and also provides huge savings in storage space. Typical compression rates can be 90%.

Abstract: Azure SQL DB offers disaggregated storage architecture called Hyperscale. While this architecture provides storage scale out, it comes at the cost of performance of I/O from remote storage.

Azure HorizonDB introduces cloud-native PostgreSQL with disaggregated compute and storage for faster scaling and failover. HorizonDB’s Rust-based storage engine improves security, reliability, and ...

Getting ready for a SQL interview can feel like a big task. There are so many things to know, and interviewers love to ask about them! This guide is here to help. We’ve gathered some of the most ...

Microsoft unveiled Azure HorizonDB at the Ignite conference, a new fully managed, scalable, and high-throughput PostgreSQL cloud database in private preview. At the Ignite conference, Microsoft today ...

At today’s Ignite 2025 event, Microsoft announced one of the biggest Azure data updates in years. The company has announced the general availability of SQL Server 2025. That has come after a long ...

Abstract: Generating accurate SQL from users’ natural language questions (text-to-SQL) remains a long-standing challenge due to the complexities involved in user question understanding, database ...

Locking down AI pipelines in Azure? A zero-trust, metadata-driven setup makes it secure, scalable and actually team-friendly. AI pipelines are transforming how enterprises handle data, but they’re ...

Microsoft has launched Azure Arc-enabled SQL Server on Windows in the US Government, Virginia region. The Redmond giant called this a "major first step". Microsoft has recently announced that Azure ...

Microsoft is making it easier to migrate to Azure SQL by taking the grunt work out of schema setup. A new update to Azure Database Migration Service (DMS) introduces a built-in schema migration tool ...