Silvano Coriani

After more than 25 years helping customers and partners build and troubleshoot SQL Server applications, both on-premises and in the cloud, I began working with PostgreSQL and quickly discovered that some of the things I assumed were “obvious” were not universal after all. Not the fundamentals: an 8 TB database with roughly 80% unused indexes, or a supposedly “slow” web page firing off 63...

Please Note: This tutorial is hosted in the Microsoft Office across the courtyard from the conference center and not inside the CCIB. PostgreSQL is becoming the foundation for a new generation of intelligent applications.

PostgreSQL has become the foundation of modern applications. But AI, real-time analytics, and global-scale workloads are redefining what developers expect from a database platform.

Logical Replication in PostgreSQL is a tool that can be leveraged to encompass multiple critical data integration and movement scenarios, including moving all or a portion of your data in and out, from and to fully managed database services in the cloud like Azure Database for PostgreSQL. From creating an exact copy of your original data in a different environment to applying vertical and...

This session will provide an overview of PostgreSQL architecture, its key differences and similarities from Microsoft SQL Server, drawing parallels between the two technologies and compare their features. We will cover areas like indexing, partitioning and the programming surface including JSON, geospatial data types, time series and more.