Integrate PostgreSQL in your inner and outer loops of modern app development

In this training, you’ll learn how to couple Postgres artifacts -such as schemas, tables, and procedures - with client application code as part of the inner and outer loops of your team's development workflows, for both Azure and open-source PostgreSQL.
You will learn about local development during the inner loop, addressing schema evolution, testing, and query optimization with commonly used OSS tools and programming frameworks like Visual Studio Code, Python, Node.JS, .NET and more.
Then you'll focus on how the outer loop encompasses deployment, monitoring, and scaling, emphasizing CI/CD practices and scaling strategies for both traditional on-premises and cloud environments.
Next, you'll cover tools and techniques to automate deployment of both infrastructure (Infrastructure as Code with Terraform, Bicep and other options) and application plus database artifacts using tools like GitHub Actions and more, with best practices for maintaining a secure, robust, integrated development workflow using Azure Database for PostgreSQL as a reference.

Unlocking Innovations: Latest Updates in Azure Database for PostgreSQL for Developers and Data Pros

This session dives deep into recently released and brand new features and integrations that are revolutionising how we optimise, analyse, and integrate PostgreSQL databases in the cloud. From Automated Index Tuning recommendations to the latest news on Generative AI developments, with vector, azure_ai and azure_local_ai extensions. Whether you're a seasoned developer looking to leverage cutting-edge tools or a data professional aiming to stream or mirror PostgreSQL data in Microsoft Fabric, this session will equip you with the knowledge and practical insights to harness the full potential of Azure Database for PostgreSQL. Join us to explore real-world use cases, best practices, and exciting new announcements for Azure Database for PostgreSQL that can transform your data management strategies.

PostgreSQL for SQL Server Professionals

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.
We will see also how Azure Database for PostgreSQL is a fully managed and intelligent service that allows developers to focus on application innovation, reducing repetitive database management tasks.
If you’re interested in PostgreSQL and are wondering what of your SQL Server existing skills can be reused and what need to be worked on, this session is for you!

Business continuity at a glance with Azure Database for PostgreSQL

Implementing a highly available and resilient database tier for mission critical applications with PostgreSQL is not a walk in the park, and requires a combination of using the right technologies, defining effective workflows and involve people with the right skills. Those are the ingredients that a cloud vendor like Microsoft is actually baking into a PaaS service like Azure Database for PostgreSQL so that customers can get business continuity out of the box. In this session, we will cover available options and capabilities offered by the service, from local and zone-redundant high availability to multi-region disaster recovery scenarios and requirements. We will also see how new features like Virtual Endpoints and Read Replica's Promote to Primary can be leveraged by architects and app developers to create highly reliable solutions with minimal effort.

Building Multi-tenant SaaS solutions on PostgreSQL

SaaS model is taking cloud application business by the storm. Companies are less and less developing in-house solutions and are instead more relying on 3rd party SaaS solutions for larger chunks of their application portfolios, from HR to Finance to Production and procurement. Multi-tenant design is a critical aspect for every SaaS company to increase resource utilisation, cost efficiency and achieve desired margins as, in most cases, databases are the biggest item in their monthly bill. No matter if big or small, finding the right multi-tenancy model at the database layer is a complex subject, and it requires the right trade-off between performance, costs, tenant isolation, security and other critical areas. In this session you will learn some of the most successful design patterns and implementation details that support different requirements and use cases, from few users to millions, and see how these can be applied to your own scenarios.

Application development with PostgreSQL and .NET: a deep dive on your modern toolset!

Building scalable and reliable applications using PostgreSQL as back end requires a good mix of selecting the right toolset and adopting some good design and implementation practices. In this session you will learn about .NET, the free, open-source, cross-platform framework for building modern apps and powerful cloud services. In particular, you will dig into Npgsql and Entity Framework Core, and explore some common data access patterns you can leverage to optimise your database tier.

Build the most effective multi-tenant database tier for your SaaS solution!

Come discover what is powering some of the largest SaaS solutions on the planet sporting millions of tenants. It does that through a combination of multiple multi-tenancy models that support different requirements and use cases. from few users to millions. In this session, we'll dig deeper into some examples of real-world architectures implemented by 1st party and 3rd party solution providers like Microsoft Dynamics 365 and others, and see how these can be applied to your own scenarios.

If you're designing a new SaaS solutions for the millions, this session is for you!

Unleash the power of .NET, PostgreSQL, and Linux as your next OSS stack for modern app development

In the ever-evolving landscape of software development, open-source technologies have become the driving force behind innovation. Join us on a journey where we explore the synergy of three powerful tools: .NET, PostgreSQL, and Linux. These battle-tested components form an exceptional stack for building modern applications that are robust, scalable, and community-driven. You will learn about .NET, discovering how this cross-platform framework empowers developers to create high-performance, cross-device applications, from Web to Mobile. We will unleash the capabilities of PostgreSQL and .NET combined, digging' into Npgsql's ADO.NET and Entity Framework Core providers, and see how we can combine high performance and developer productivity in writing the data access layers of our distributed applications, whether you’re migrating from another database or starting fresh.
All this while embracing the freedom and flexibility of Linux as your development environment, from command-line mastery to containerization with Docker for efficient development workflows, either on-prem or in (cross-)cloud native environments.
Whether you’re a seasoned developer or just starting your journey, this session promises insights, best practices, and a glimpse into the future of modern app development.

Exploring .NET, PostgreSQL, and Linux as your next OSS app development stack

In the ever-evolving landscape of software development, open-source technologies have become the driving force behind innovation. Join us on a journey where we explore the synergy of three powerful tools: .NET, PostgreSQL, and Linux. These battle-tested components form a great stack for building modern applications that are robust, scalable, and community-driven. In this demo-heavy session, you will learn about .NET, discovering how this cross-platform framework empowers developers to create high-performance, cross-device applications, from Web to Mobile. We will explore the capabilities of PostgreSQL and .NET combined, digging into Npgsql's ADO.NET and Entity Framework Core providers, and see how we can combine high performance and developer productivity in writing the data access layers of our distributed applications, whether you’re migrating from another database or starting fresh.
All this while embracing the freedom and flexibility of Linux as your development environment, from command-line mastery to containerization with Docker for efficient development workflows, either on-prem or in (cross-)cloud native environments.
Whether you’re a seasoned developer or just starting your journey, this session promises insights, best practices, and a glimpse into the future of modern app development.