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 Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers