Skip to content
sqlkitty

sqlkitty

sql for everyone

Menu
  • Home
  • About
  • Auditing
  • Boulder SQL
  • Presenting/Talks
  • 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

Subscribe to SQL Kitty

loader

Email Address*

Name

Recent posts

  • New Job -> Week 3 -> Creating Alerts
  • New Job -> Week 2 -> Creating a Checklist
  • New Job -> Week 1 -> What Tools Do You Need?
  • Creativity in Technology
  • Documentation vs Automation

Categories

  • Azure (2)
  • containerization (12)
  • dba (5)
  • editorial (1)
  • excel and others (3)
  • IT Certifications (1)
    • network+ (1)
  • linux (2)
  • network administration (15)
  • newjob (3)
  • other (3)
  • postgresql (5)
  • security (1)
  • SQL Server (11)
  • sql server administration (114)
    • jobs (2)
  • sql sever syntax (77)
  • web dev (6)
  • zen (1)

Archives

  • March 2023 (5)
  • January 2023 (1)
  • October 2022 (2)
  • 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

  • New Job -> Week 3 -> Creating Alerts
  • New Job -> Week 2 -> Creating a Checklist
  • New Job -> Week 1 -> What Tools Do You Need?
  • Creativity in Technology
  • Documentation vs Automation
© Copyright 2023 – sqlkitty
Chip Life Theme by TutorialChip ⋅ Powered by WordPress