Tutorial to Create a Power BI Report Using PostgreSQL
Learn how you can use PostgreSQL data in a Power BI report.
2022-11-14
6,373 reads
postgres
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.
2022-03-04
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.
2022-01-31
Connecting to PostgreSQL: Learning PostgreSQL with Grant
Database professionals often work with more than one database platform. Grant Fritchey explains setting up and connecting to PostgreSQL database.
2021-12-17
SQL String functions in SQL Server, Oracle and PostgreSQL
In this article we look at how to use string functions to concatenate, replace, trim and get substrings in SQL Server, Oracle and PostgreSQL.
2021-10-25
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.
2021-08-16
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.
2021-04-19
Delete SQL Statement in SQL Server, Oracle and PostgreSQL
Learn about the differences and similarities when deleting data from SQL Server, Oracle and PostgreSQL with the several examples in this article.
2021-03-16
Introduction to PostgreSQL Database on Amazon RDS
This article explains how to get started with PostgreSQL on AWS.
2020-12-15
1,744 reads
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Claude Context Window
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Forums
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers