PostgreSQL in Azure Data Studio
Learn how to install PostgreSQL and using Azure Data Studio to work with it.
2022-01-31
7,385 reads
postgresql
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
Upgrade PostgreSQL 9.X to 12.X in Windows
Learn how you can upgrade a PostgreSQL server and ensure your databases follow to the new version.
2021-02-09
42,073 reads
SQL Update Statement with Join in SQL Server vs Oracle vs PostgreSQL
In this article we look at the different SQL syntax you need to use when updating data when joining tables for SQL Server, Oracle and PostgreSQL.
2021-01-29
Getting started with PostgreSQL on MacOS
This article covers how to install PostgreSQL on the macOS.
2020-11-19
3,703 reads
Installing PostgreSQL 11 on Windows with Step-by-step Instructions
PostgreSQL is a free database management system (DBMS). PostgreSQL 11 is the new version of this DBMS. We will take a look at how to install PostgreSQL 11 on Windows. This article covers where to download PostgreSQL 11, how the installation process looks like, and how to connect to the PostgreSQL server. Step-by-Step Installation on Windows […]
2020-09-03
21,024 reads
Postgresql JDBC Tutorial on Linux
PosgtreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language. Though originally designed to run on UNIX platforms, Postgres is able to run on various platforms, such as macOS, Solaris, Windows, Unix, and Linux. PostgreSQL databases provide enterprise-class database solutions and are used by a wide […]
2020-05-11
9,783 reads
Blogs
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Stop Being Surprised by Your Azure Bill: Use Budgets
By John
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
Forums
The Max PK Length
Comments posted to this topic are about the item The Max PK Length
My experience using the GitHub Copilot in SSMS 22
Comments posted to this topic are about the item My experience using the GitHub...
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
Question of the Day
The Max PK Length
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers