COALESCE(), ISNULL() , NULLIF() and alternatives in SQL Server, Oracle and PostgreSQL
In this article we look at the SQL functions COALESCE, ISNULL, NULLIF and do a comparison between SQL Server, Oracle and PostgreSQL.
2022-04-06
In this article we look at the SQL functions COALESCE, ISNULL, NULLIF and do a comparison between SQL Server, Oracle and PostgreSQL.
2022-04-06
In this article we take a high level view of choosing to use Snowflake in the cloud versus SQL Server on-premises and some things to consider.
2022-03-28
In this article we look at how to install SQL Server and Oracle using PowerShell to create development environments using Windows Containers.
2022-01-28
In this article we demonstrate how to transfer data via a CSV file from a SQL Server database to a Pandas dataframe and then subset the dataframe in Python.
2021-09-03
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
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
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
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
Joe Celko explains why questions requiring yes or no answers are more complicated than you might realize in both spoken language and computing.
2019-08-22
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
Disclosure: this post may contain links to books as an affiliate link. If you...
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
Comments posted to this topic are about the item 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