Skip to content

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

Month: February 2021

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

  • Posted onFebruary 21, 2021February 21, 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 Docker container’s IP

  • Posted onFebruary 20, 2021February 20, 2021
  • containerization
Continue Reading

Exploring a Docker container’s file system

  • Posted onFebruary 15, 2021February 16, 2021
  • containerization

There are three ways to get into bash in a docker container: docker exec -it containername bash docker exec -it containername “bash” docker exec -it containername /bin/bash Once you run those from the command line, it brings you to the top level of the file…

Continue Reading

Reading all of your SQL Server Logs with one query

  • Posted onFebruary 9, 2021February 9, 2021
  • SQL Server

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:

Continue Reading

Using psql in Docker

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

Run psql in docker exec docker exec -ti NAME_OF_CONTAINER psql -U YOUR_POSTGRES_USERNAME

Continue Reading

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

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