Are you a seasoned SQL Server developer curious about PostgreSQL but unsure where to start? This session is tailor-made for you. PostgreSQL, a robust open-source database, offers unique features like JSONB, arrays, and extensions such as pgvector for vector search—all while sharing familiar relational concepts with SQL Server. Whether you’re considering PostgreSQL for cost-efficiency, flexibility, or its growing popularity in cloud-native applications, this session will demystify the transition and show you how to leverage your SQL Server expertise in a PostgreSQL world.

In this session, we’ll explore similarities and differences between SQL Server and PostgreSQL, demonstrate how to set up a PostgreSQL environment on Windows, and dive into hands-on examples ranging from table creation to advanced features like vector storage and search. You’ll learn practical tips and gain actionable insights to expand your skill set and open new opportunities. Whether you’re planning a migration or simply broadening your horizons, this session will empower you to confidently navigate PostgreSQL as your next database adventure.

You will learn:

• Understand the similarities and key differences between SQL Server and PostgreSQL, including data types, indexing, and procedural languages.
• How to set up and configure a PostgreSQL environment, both locally on Windows and in Azure, to align with development and production needs.
• Gain practical, hands-on experience with PostgreSQL through live examples, including advanced features like JSONB, arrays, and vector storage/search.