Database Management Systems
In SQL Server, the T-SQL CASE expression is a scalar expression that returns a value based on conditional logic. It evaluates a list of conditions and returns a value, based on the outcome of those conditions..
In some ways, the SQL Server CASE expression is similar to IF...ELSE. However, CASE allows you to check for multiple conditions, whereas IF...ELSE doesn’t.
If you’re using OPENJSON(), but you’re trying to remember how to select an inner fragment from the JSON document, read on.
Did you know that PostgreSQL is available in all Ubuntu versions by default?
Yes, that means that your Ubuntu 20.04 installation probably already has a PostgreSQL package sitting there waiting for you to install it.
And you can install it with one command, which I’ll show you below.
But what if you prefer to run the latest version of Postgres instead? Well, I’ll also show you how to install that. Installing the latest version is almost as easy as installing your local package.
Continue readingThe following steps demonstrate how to install PostgresSQL on Ubuntu 18.04.
There are a couple of ways to go about installing Postgres on Ubuntu.
But before we start jumping in and installing it, did you know that by default, PostgreSQL is already available in Ubuntu 18.04?
So one option is to go right ahead and use the version that’s already included with Ubuntu.
But unless you have reason not to, you will probably want to run the latest version of PostgreSQL, in which case you’ll want to download and install the latest version.
This tutorial covers both options.
Continue readingHere’s a quick tutorial that demonstrates how to check or change the compatibility level of a database using the SQL Server Management Studio (SSMS) graphical user interface (GUI).
If you want to see how to do it in T-SQL, see How to Change the Compatibility Level of a Database using T-SQL.
Continue readingWhen you create a profile in Database Mail, you have the option of making it a private profile or a public profile.
You also have the option of setting it as the default profile.
Continue readingHere, I demonstrate how to change the priority of a Database Mail account within a profile in SQL Server using the SQL Server Management Studio (SSMS) graphical user interface.
If you want to see how to do it using T-SQL, see Change the Sequence Number of an Account in Database Mail (T-SQL).
The priority and the sequence number are the same thing (when you change it with T-SQL you use the @sequence_number parameter).
Here, I demonstrate how to remove a Database Mail account from a Database Mail profile in SQL Server using the SQL Server Management Studio (SSMS) graphical user interface.
If you want to see how to do it using T-SQL, see Remove a Database Mail Account from a Profile (T-SQL).
Continue readingHere, I demonstrate how to delete a Database Mail profile in SQL Server using the SQL Server Management Studio (SSMS) graphical user interface.
If you want to see how to do it using T-SQL, see Delete a Database Mail Profile (T-SQL).
Continue readingHere, I demonstrate how to delete a Database Mail account in SQL Server using the SQL Server Management Studio (SSMS) graphical user interface.
If you want to see how to do it using T-SQL, see Delete a Database Mail Account (T-SQL).
Continue reading