Developing powerful and intelligent apps using the Azure managed PostgreSQL service
summary
Overview of Azure managed PostgreSQL service: managed Postgres (9.5/9.6) is in preview since May and available in 13 regions, offers 35-day PITR with RPO <5 minutes, AES-256 encryption for data and backups, automated patching, and ~23 extensions enabled. Architecture uses a gateway with optional direct connections, scales compute with minimal downtime (tens of seconds), and integrates with Cortana Intelligence, Azure Machine Learning, Power BI and Npgsql. Demo ingests 1.6 million tweets from 3,000 investors to predict next-day stock price (example: $74.21) and runs under $100.
AI-written summary · about
chapters (29)
- 0:00Introduction
- 1:06Open innovation
- 5:46Customer pain points
- 13:26The hard work in designing
- 17:41Azure managed PostgreSQL architecture
- 23:51Performance scaling
- 26:56Security
- 29:18Database security
- 29:53Backups
- 30:41Monitoring
- 32:15Automated patching
- 33:07Server parameters
- 34:46Extensions
- 35:30App developers
- 36:17Freedom
- 36:45Performance management
- 37:18Pricing
- 41:43Intelligent apps
- 41:55Predict stock price
- 42:29How the app works
- 42:55Cortana Intelligence Suite
- 43:44Azure Machine Learning
- 45:13Action
- 46:22Demo
- 48:09Another browser
- 50:22Back in action
- 51:16The database
- 52:24The query
- 54:26Customer success
related talks
26mWhat Enterprises like about Azure Database for PostgreSQL - Flexible Server
32mWhat makes Azure Database for PostgreSQL Great for Developers?
25mWhat’s New with Azure Database for PostgreSQL- Flexible Server
50mUnleashing the Power of Azure for PostgreSQL
31mBuild scalable and secure enterprise apps on OSS databases Q&A
21mWhat Microsoft is Building for Postgres in 2025
46mEmpowering Developers: Microsoft’s Commitment to Ope...
56mSeamless Migration to Azure Database for PostgreSQL