Blog

Archive:

Search site:

Tags:

Concurrency (3) debian (2) docker (2) Execution Plans (6) Indexes (4) internals (11) linux (5) MongoDB (2) MR2 (2) Optimization (7) Parameterization (1) Performance (9) Performance Tuning (3) postgres (6) Powershell (2) RCSI (2) SQL Server (26) Statistics (2) Stored Procedures (1) Version Store (2)

Categories:

Docker (2) Linux (4) MongoDB (2) PostgreSQL (6) Powershell (1) SQL Server (26)

Tag: linux

  • Installing MongoDB on Debian

    Installing MongoDB on Debian

    In preparation for an upcoming project (stay tuned for more details), I needed to set up a MongoDB database server. In this post, we’ll walk through how to install and configure MongoDB on Debian 12. At the time of writing, Debian 13 is the most up to date stable version of Debian, though MongoDB is…

    Keep reading

  • Setting up the Stack Overflow database in Postgres

    Setting up the Stack Overflow database in Postgres

    I’ve worked with Microsoft SQL Server for many years as well as dipping my toes into the MySQL world as and when required, however, I have not done as much with PostgreSQL. It’s hard to ignore the momentum that Postgres has built in recent years; it is moving up the Stack Overflow Developer Survey and…

    Keep reading

  • Four Flavours of Postgres Install – Part 2 (Docker Container, Linux Host)

    Four Flavours of Postgres Install – Part 2 (Docker Container, Linux Host)

    In the last post, the first in this series about installing PostgreSQL, we looked at how to install PostgreSQL on Linux. This post is an alternative install method where we’ll look at how to install PostgreSQL on a Docker container, where the container is run on a Linux host. As before, we’ll run through the…

    Keep reading

  • Four Flavours of Postgres Install – Part 1 (Linux)

    Four Flavours of Postgres Install – Part 1 (Linux)

    This is the first post in a short series documenting the various methods of installing PostgreSQL. In this post, we’ll look at how to install PostgreSQL natively on Linux and connect to the cluster we install from a remote client. The VM Firstly, let’s create a VM to install PostgreSQL on. I won’t detail the…

    Keep reading

  • Installing PGAdmin on Linux Mint

    Installing PGAdmin on Linux Mint

    This is a quick walkthrough of how I installed pgAdmin on Linux Mint. pgAdmin is one of the main management and query tools for PostgreSQL, which I like to use in conjunction with DBeaver. Installation The pgAdmin tool isn’t in the standard Linux Mint repositories, only phpPgAdmin, which is a web-based tool, similar to the…

    Keep reading