Skip to content

Menu
  • Home
  • About
  • Auditing
  • Boulder SQL
  • Presenting
  • Publications
  • Volunteering
  • Contact

Using PostGIS in Docker

  • Posted onFebruary 2, 2021February 2, 2021
  • containerization

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…

Continue Reading

Using Docker on Windows to have persistent PostgreSQL settings and databases

  • Posted onFebruary 1, 2021February 2, 2021
  • containerization

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…

Continue Reading

Docker pruning

  • Posted onJanuary 23, 2021
  • containerization

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…

Continue Reading

Using Docker on Windows to have persistent SQL Server settings and databases

  • Posted onJanuary 23, 2021January 24, 2021
  • containerization

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…

Continue Reading

Get user permissions on SQL Server with a script

  • Posted onJanuary 22, 2021January 22, 2021
  • security

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.…

Continue Reading

xRDP “Authentication Required to Create Managed Color Device”

  • Posted onJanuary 8, 2021
  • linux

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…

Continue Reading

Connect to your Linux machine from Windows or Mac

  • Posted onJanuary 4, 2021
  • linux

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…

Continue Reading

Can a database on SQL Server be owned by no one?

  • Posted onDecember 29, 2020December 30, 2020
  • sql server administration

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…

Continue Reading

setup mysql in docker

  • Posted onDecember 29, 2020December 29, 2020
  • containerization

sudo docker run -d -p 3306:3306 –name=mysqlserver –env=”MYSQL_ROOT_PASSWORD=strongpasswordhere” mysql

Continue Reading

pgadmin upgrade and saved servers list

  • Posted onNovember 24, 2020
  • postgresql

I used to freak out each time (and especially the first time) I upgraded pgadmin on my local computer. What happened to my saved servers list?!? Of course, I could recreate it because I have a listing of all the servers in Confluence, but ugh…

Continue Reading

Posts navigation

Previous Page Page 1 Page 2 Page 3 … Page 19 Next Page

Recent posts

  • Standards Matter
  • What I’ve Been Up To
  • Testing SQL Server backups and offloading integrity checks
  • What perms does a user need to create a table variable?
  • Get the schema of a temp table

Categories

  • Azure (1)
  • containerization (12)
  • excel and others (3)
  • IT Certifications (1)
    • network+ (1)
  • linux (2)
  • network administration (15)
  • other (3)
  • postgresql (4)
  • security (1)
  • SQL Server (8)
  • sql server administration (111)
    • jobs (2)
  • sql sever syntax (77)
  • web dev (6)
  • zen (1)

Archives

  • April 2022 (1)
  • December 2021 (1)
  • May 2021 (1)
  • April 2021 (2)
  • February 2021 (7)
  • January 2021 (5)
  • December 2020 (2)
  • November 2020 (1)
  • January 2020 (2)
  • December 2019 (3)
  • August 2019 (2)
  • February 2019 (1)
  • June 2018 (1)
  • January 2018 (1)
  • September 2017 (1)
  • May 2016 (4)
  • January 2016 (2)
  • December 2015 (2)
  • August 2015 (2)
  • July 2015 (4)
  • June 2015 (3)
  • May 2015 (9)
  • April 2015 (4)
  • November 2014 (7)
  • October 2014 (19)
  • September 2014 (3)
  • July 2014 (2)
  • July 2013 (1)
  • December 2012 (1)
  • October 2012 (1)
  • December 2011 (6)
  • October 2011 (6)
  • September 2011 (5)
  • July 2011 (1)
  • June 2011 (1)
  • May 2011 (2)
  • April 2011 (1)
  • February 2011 (15)
  • January 2011 (19)
  • December 2010 (14)
  • November 2010 (16)
  • October 2010 (3)

RSS SQL Kitty RSS

  • Standards Matter
  • What I’ve Been Up To
  • Testing SQL Server backups and offloading integrity checks
  • What perms does a user need to create a table variable?
  • Get the schema of a temp table
© Copyright 2022 –
Chip Life Theme by TutorialChip ⋅ Powered by WordPress