I want the ability to search through all the SQL Server logs without having to know how many log files there are, so I created this script to do that:
Run psql in docker exec docker exec -ti NAME_OF_CONTAINER psql -U YOUR_POSTGRES_USERNAME
This requires a different image in Docker. You can’t just use the postgres image and create an extension in it. Instead, you have to use the postgis image. This image will have a database in it already setup for you to use with postgis. If…
This is a super simple way to retain the data and settings that you create and change on your PostgreSQL Docker instance. There’s a lot of talk about attaching databases after you recreate your Docker container, but I found that it’s easier to have persistent…
I went to create a container and got an error that it already existed. Hmm, I thought I had removed it. To see all your Docker containers running or not, run this at the command line: I discovered I had a bunch of them hanging…
This is a super simple way to retain the data and settings that you create and change on your SQL Server Docker instance. There’s a lot of talk about attaching databases after you recreate your Docker container, but I found that you just have to…
The main reason for creating this script was to compare user permissions when someone came to me saying “I need the same permissions as so and so,” and then I would scratch my head trying to figure out how to get this quickly and easily.…
This popup can drive you crazy! I kept having it when RDPing from my Mac to my Linux machine. So annoying! But I found a very nicely written blog post on this, so I will just refer you to it. https://c-nergy.be/blog/?p=12073 The upshot is to…
I’m in the process of setting up a NUC with PopOS and wanted to be able to SSH and RDP into the NUC from either Windows or Mac. SSH So, to start I needed to enable SSH on the NUC. Check if an SSH server…
Yes, a database on SQL Server can be owned by no one! This is a NULL value as the owner. Apparently, this can happen because the login that owned it no longer exists. I discovered this when I was going through databases owned by users…