A First Look at PostgreSQL Monitoring in SQL Monitor

PostgreSQL monitoring is now supported by Redgate SQL Monitor to improve performance and reduce downtime.

PostgreSQL 101: The 10 key differences between SQL Server & PostgreSQL

Join us for the second webinar in our PostgreSQL 101 series.

As a SQL Server developer or DBA, you have a broad skill set and have become accustomed to interacting with the larger #SQLFamily community. Now, by choice or necessity you've begun to explore PostgreSQL and things feel oddly familiar and foreign at the same time.

Join Ryan Booze on May 25th to find out the things that often trip up SQL Server users when they first start exploring PostgreSQL.

PostgreSQL Basics: Object Ownership and Default Privileges

Understanding how roles and privileges work in Postgres is key to understanding the next, and often more confusing part of security, object ownership.

Tutorial to Create a Power BI Report Using PostgreSQL

Learn how you can use PostgreSQL data in a Power BI report.

How to back up and restore in PostgreSQL: Learning PostgreSQL with Grant

You can perform PostgreSQL backups with the pg_dump command. In this article, Grant Fritchey explains how to back up and restore with the pg_dump and pg_restore utilities.

PostgreSQL in Azure using the Azure Data Studio Extension

Learn how to create a PostgreSQL database and work with it from Azure Data Studio.

Creating a Database and Tables in PostgreSQL: Learning PostgreSQL with Grant

The syntax for creating databases and tables in PostgreSQL is similar to other RDBMS. In this article, Grant Fritchey shows how to create databases and tables.

PostgreSQL in Azure Data Studio

Learn how to install PostgreSQL and using Azure Data Studio to work with it.

SQL VIEW Comparison in SQL Server, Oracle and PostgreSQL

In this article we look at the similarities and differences for views in SQL Server, Oracle and PostgreSQL. We also look at indexed views, materialized views and updatable views.

SQL Window Functions in SQL Server, Oracle and PostgreSQL

In this article we look at using Window Functions in SQL Server, Oracle and PostgreSQL to see the differences and similarities of the syntax.