Rethinking PostgreSQL for AI Apps: Inside Azure HorizonDB

Room 7Tue 27 Oct • 14:30–15:30DataIntermediate
PostgreSQL has become the default database for many applications—but AI workloads are introducing new patterns that go beyond traditional transactional design. Today’s apps need to combine relational data with semantic search, vector similarity, and AI-driven experiences. In practice, this often means multiple systems, data movement, and added complexity. In this session, we’ll take a deep dive into Azure HorizonDB, a PostgreSQL-compatible service engineered for AI-driven workloads. You’ll learn how it brings transactional processing, vector search, and AI integration together in a single system—while improving developer productivity through tools like Visual Studio Code and GitHub Copilot. We’ll focus on what this means for real applications: Where PostgreSQL patterns start to show friction when combining relational queries with AI-driven search How advanced vector search with filtering enables efficient hybrid (relational + vector) queries The shift to shared storage and scale-out compute for performance and elasticity You’ll leave with practical patterns you can apply today—without introducing additional data stores or complex pipelines.

About the speaker

Bob Ward

Bob Ward is a Principal Architect for the Microsoft Azure Data team, which owns the development for Microsoft SQL ground to cloud to fabric. Bob has worked for Microsoft for 32+ years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2025 including Azure SQL and SQL database in Fabric. Bob is a well-known speaker on SQL Server, Azure SQL, AI, and Microsoft Fabric often presenting talks on new releases, internals, and specialized topics at events such as SQLBits, Microsoft Build, Microsoft Ignite, PASS Summit, FabCon, SQLCon, and VS Live. You can also learn Azure SQL from him on the popular series https://aka.ms/azuresql4beginners. You can follow him at @bobwardms or linkedin.com/in/bobwardms. Bob is the author of the books Pro SQL Server on Linux, SQL Server 2019 Revealed, Azure SQL Revealed, SQL Server 2022 Revealed, Azure SQL Revealed 2nd Edition, and SQL Server 2025 Unveiled available from Apress Media.