Now that Postgres is eating the world, you might consider joining the dark side - here's a quick overview of Postgres for SQL Server users.

Neon

Microsoft SQL Server and Postgres both share their origins in 1989, but they have grown in different directions. SQL Server uses T-SQL, while Postgres uses PL/pgSQL, each with distinct syntax and features for procedural programming, string delimiters, date functions, and more. Postgres, an open-source community-driven database, offers flexibility and earlier access to innovative features compared to the company-driven SQL Server. Switching from SQL Server to Postgres includes adapting to different syntactical nuances but opens up a broader range of tools and hosting options.

What To Know About Postgres if You’re Coming From SQL Server