MongoDB is a general purpose, document-based, distributed data platform built for modern application developers and for the cloud.
MongoDB is classified as a NoSQL database. It uses JSON-like documents with optional schemas.
This tutorial shows you how to install MongoDB on a Mac via Homebrew.
Continue readingOne of the cool things about Azure Data Studio is that you can install extensions to extend its capabilities. One of those extensions is the SQL Server Agent extension.
This extension allows you to do stuff like create jobs, view jobs, view job history, stop/start jobs, etc.
This article shows you how to install the SQL Server Agent extension on Azure Data Studio.
Continue readingDid 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 readingAzure 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 readingSQL Server used to be available on Windows machines only. If you didn’t have Windows, you didn’t install SQL Server.
Now, SQL Server is available on Windows, Linux, and even Mac (via Docker containers).
This obviously means that an article titled “how to install SQL Server” is not as simple as it used to be!
Continue readingStarting from SQL Server 2017, you can now install SQL Server on Linux.
More specifically, you an install it on Ubuntu, Red Hat (RHEL), and SUSE.
Below are instructions for installing SQL Server on each of these Linux distributions.
Continue readingAzure Data Studio is a graphical tool for managing databases.
It is available on Windows, MacOS, and Linux. On Linux it’s available on Red Hat (RHEL), SUSE Linux Enterprise Server, and Ubuntu.
Below is a step-by-step guide to installing Azure Data Studio on Ubuntu 18.04 via the GUI. Screenshots included.
I’ve also provided the commands for installation via the command-line in case you prefer that method.
Continue readingYou can install Azure Data Studio on to Red Hat either via the GUI or command-line.
This article outlines both methods. I’ve included screenshots for the GUI installation.
Continue readingIf you’ve installed SQL Server on your Red Hat machine, you’ll need some tools to connect to it and run queries, etc.
The sqlcmd and bcp utilities are a couple of good options for helping you perform the most common tasks.
Continue reading