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!