Tag: how to

Install PostgreSQL on Ubuntu 18.04

Posted on by Ian

The 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 reading →

How to Install Azure Data Studio on Ubuntu 20.04

Posted on by Ian

Azure Data Studio is a neat little graphical tool for managing databases.

It’s available on Windows, MacOS, and Linux. On Linux it’s available on Red Hat (RHEL), SUSE Linux Enterprise Server, and Ubuntu.

This tutorial shows you how to install Azure Data Studio on Ubuntu 20.04 via the GUI. Screenshots included.

I’ve also included the commands for installation via the command-line in case you prefer that method.

Continue reading →

Change the Priority of an Account within a Database Mail Profile (SSMS)

Posted on by Ian

Here, 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).

Continue reading →