postgresql

External Article

PostgreSQL Basics: Getting started with psql

  • Article

PostgreSQL has a separate command-line tool that’s been available for decades and is included with any installation of PostgreSQL. Many long-term PostgreSQL users, developers, and administrators rely on psql to help them quickly connect to databases, examine the schema, and execute SQL queries.

Knowing how to install and use basic psql commands is an essential skill to have for anyone that will connect to PostgreSQL.

2023-09-20

External Article

PostgreSQL 101: A guide to PostgreSQL documentation & useful resources

  • Article

It can be a daunting task for new users to get to grips with PostgreSQL documentation, particularly if you are not from a developer background.

If you are not sure where to start, we are here to help break down the different resources available so you can make the most of them.

In the latest webinar of our PostgreSQL 101 series, join Ryan Booz, PostgreSQL Advocate at Redgate, and Grant Fritchey, Microsoft Data Platform MVP, and discover:

- How to navigate PostgreSQL documentation
- The essential things you need to know about PostgreSQL documentation
- Other useful learning resources to help make your journey to using PostgreSQL easier

Register to join us on September 19th at 11am CT (5pm BST)

2023-09-18

External Article

PostgreSQL Schema: Learning PostgreSQL with Grant

  • Article

An important aspect of building and managing a database is organizing the objects within your database. You may have tables that support different functions, for example, a schema for warehousing operations and another for sales. Some logins may need access to some tables, but not others. You might want to isolate one set of objects within a database from other sets of objects. All of this, and more, can be accomplished using schemas within a database and PostgreSQL supports the use of schema for just these types of functions.

2023-08-16

External Article

PostgreSQL 101: The ten PostgreSQL extensions you need to know about

  • Article

Extensions are a unique and powerful capability in PostgreSQL, a feature that other relational databases do not provide. Taking advantage of the extension framework in PostgreSQL is a true advantage to using the platform.

In this webinar, find out how PostgreSQL extensions can help you find solutions to some of your common problems.

Register now and to join on August 22nd

2023-08-11

External Article

Six Things to Monitor with PostgreSQL

  • Article

This article describes six performance metrics that ought to be central to your PostgreSQL monitoring strategy. By using a tool like SQL Monitor to track these metrics over time, and establish baselines for them, you'll be able to spot resource pressure or performance issues immediately, quickly diagnose the cause, and prevent them becoming problems that affect users.

2023-07-17

PostgreSQL 101: The journey towards PostgreSQL - tips and lessons from Grant Fritchey

  • Article

Want to hear someone else’s experience of learning PostgreSQL from scratch? Then look no further.

Grant Fritchey, Microsoft Data Platform MVP, started working with SQL Server in 1995 but more recently has needed to support and understand PostgreSQL. In this webinar, he will go on a deeper dive into the PostgreSQL database and will share top tips from his own learning journey.

Join us on July 25th

2023-07-14

External Article

Are PostgreSQL memory parameters magic?

  • Article

Ordinary PostgreSQL users often do not know that PostgreSQL configuration parameters exist, let alone what they are and what they mean. Some parameter tuning can improve the database performance, and we are usually talking about 10%, 20%, and in rare cases, up to 50% performance improvement.

2023-06-14

External Article

PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers (CT and BST Time Zones)

  • Article

In the first two webinars, we've discussed why PostgreSQL has become such a force in recent years and some of the main differences for SQL Server users to know.
In this follow-up webinar, find out how to take your first steps using PostgreSQL.

Join Ryan Booz, PostgreSQL Advocate at Redgate, and discover:
-The freely available options to help you get started
-The essential tools you will need when using PostgreSQL
-Some learning resources to help you take the next steps

2023-06-07

PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers (AEST and SGT Time Zones)

  • Article

In the first two webinars, we've discussed why PostgreSQL has become such a force in recent years and some of the main differences for SQL Server users to know.
In this follow-up webinar, find out how to take your first steps using PostgreSQL.

Join Ryan Booz, PostgreSQL Advocate at Redgate, and discover:
-The freely available options to help you get started
-The essential tools you will need when using PostgreSQL
-Some learning resources to help you take the next steps

2023-06-07

Blogs

AI Innovation in Microsoft Keynote

By

I’m thrilled to be covering the Microsoft Keynote: Fuel AI Innovation with Azure Databases on Day...

Benefits of Migrating from Azure Synapse Analytics to Microsoft Fabric

By

Many customers ask me about the advantages of moving from Azure Synapse Analytics to...

PASS Summit 2024 – A Very Different World

By

The last data centric conference I attended was the PASS Summit in 2019. A...

Read the latest Blogs

Forums

Unencrypted connections in Always on Availability Group

By Awais Afzal

Hi, In my Always On Availability environment, I am seeing two encrypt_option values as...

Error loading multiple CSV files in SSIS

By water490

Hi everyone I have a bunch of CSV files that I need to bulk...

What's New for the Microsoft Data Platform

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What's New for the Microsoft...

Visit the forum

Question of the Day

Using Outer Joins

I have this data in a SQL Server 2019 database:

Customer table
CustomerID CustomerName
1          Steve
2          Andy
3          Brian
4          Allen
5          Devin
6          Sally

OrderHeader table
OrderID CustomerID OrderDate
1       1          2024-02-01
2       1          2024-03-01
3       3          2024-04-01
4       4          2024-05-01
6       4          2024-05-01
7       3          2024-06-07
8       2          2024-04-07
I want a list of all customers and their order counts for a period of time, including zero orders. If I run this query, how many rows are returned?
SELECT 
  c.CustomerName, COUNT(oh.OrderID)
 FROM dbo.Customer AS c
LEFT JOIN dbo.OrderHeader AS oh ON oh.CustomerID = c.CustomerID
WHERE oh.Orderdate > '2024/04/01'
GROUP BY c.CustomerName

See possible answers