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
On May 8, 2025, we hosted our first official event in Switzerland at Prime...
By Steve Jones
Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...
By Kevin3NF
Too many IT teams run index rebuild jobs on autopilot. Every night. Every index....
I have a record, in those the three columns where firstname / last name...
Comments posted to this topic are about the item Execution Plan Operators
--for a given member if the startdate and endate is continous we need to...
When looking at an execution plan in SSMS, what types of operators are shown?
See possible answers