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
Additional Articles
Introducing Pinal Dave to new SQL Monitor features
Pinal Dave from SQL Authority has used – and been a fan of – SQL Monitor since it launched in 2008 (fun fact: it was named SQL Response back then!) There are, however, a few newer features that Pinal isn’t too familiar with, and we were delighted to introduce those to him in this short video.
2022-04-06
Why you need to go beyond dynamic data masking
Data masking is defined as replacing sensitive data with a realistic fictional equivalent. But do you know there are 2 key types of Data masking, and what each offer? Join SQLServerCentral Editor, Steve Jones, in this 30-minute webinar to find out more.
2022-04-04
Working with MySQL Views
Views in MySQL allow you to save a predefined SQL query. Robert Sheldon explains the benefits of views and how to create and query them.
2022-04-04
Exploring New SQL Prompt Features in SQL Toolbelt and SQL Toolbelt Essentials
Roseanna Whitelegg explores new SQL Prompt functionality that has been added to SQL Toolbelt and SQL Toolbelt Essentials to help teams increase their productivity, improve code quality, and make collaboration easier.
2022-04-01
SQL Server and Oracle Create Table Comparison
In this article we look at a comparison of different things you can specify when creating tables in SQL Server and in Oracle.
2022-04-01
Data Types in PostgreSQL: Learning PostgreSQL with Grant
PostgreSQL has an unusually large number of data types. Grant Fritchey reviews each data type and discusses the good and bad points of each.
2022-03-30
Summit 2022 Call for Speakers Closes Soon
Time is running out to submit your abstract for our hybrid PASS Data Community Summit 2022 conference! If you're an expert in a data-related topic that you think would be perfect for the Summit 2022 program, we want to hear from you. Whether you're planning to attend in-person or online, all session submissions and speakers will be considered for this year's event. Don't miss your chance to speak at the leading conference for data platform pros, submit your proposal before March 31.
2022-03-30
Choosing Snowflake vs SQL Server for a Data Warehouse
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
DevOps 101: Getting buy-in across your organization
Implementing DevOps isn’t just a matter of being great at writing code. The key to successful DevOps implementation is gaining buy in across your organization. Join Grant Fritchey live for his tips on how to achieve this.
2022-03-28
Blogs
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers