Daily Coping 10 Jul 2020

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here.

Today’s tip is to see the upside in a difficult situation that helped you learn something.

I’m going to take a different tact here, not looking at a situation that was hard in the moment, but looking at the entire last quarter where the pandemic has interrupted my life and changed how I live.

I’ve learned a few things from this pandemic, but two stand out to me as things that I consider often as I go through life. They’ve helped me to make the best of the world.

First, one upside is that I cook more and we get the family together most every day. At least, the two kids that still live with me. Prior to this pandemic, we were often running to different events each night. If I wasn’t heading out, it was one of the kids. We’ve started to get back to the times when my kids were in elementary and middle school, spending more time together.

The second thing is I’ve been working on my Japanese on duolingo. I studied the language in college, but let it fall away. My middle son has been trying to learn, and I decided while I have less travel, less activities to occupy my time, I’ll spend some of the time brushing up on skills. I’m hoping to visit the country at some point, and this is some minor preparation.

For awhile I resisted tackling too many new projects during the pandemic, just trying to mentally cope with the world. As I’ve found that this is more of a new normal, at least for this year, I’ve started to change some habits, finding a positive note in the changes.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 10 Jul 2020

Daily Coping 9 Jul 2020

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here.

Today’s tip is to Eat food that makes you feel good and savor it.

That’s an easy one for me. I enjoy food, but more comfort food than anything fancy or special. I really enjoyed going to Jose Andreas’  restaurant with Brent Ozar, but more so because of the company. The food wasn’t something I’d want to recreate myself.

Instead, my favorite food has to be pizza. It’s my go to, and what my family always suggests for me if it’s my turn to pick. They’ll even indulge me sometimes when they don’t feel like it.

I try not to eat it too often. I’ll eat too much and it’s not the healthiest, but I decided to enjoy it this week, going to a local place, supporting them, and slowly enjoying a simple pepperoni pizza.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 9 Jul 2020

Getting a List of Tags from the Microsoft Container Registry–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I needed to write this post because I keep forgetting this. I’m hoping this will help me remember.

I easily remember that the container registry is at mcr.microsoft.com. This isn’t helpful. On Firefox, I get a redirect.

2020-07-07 15_22_22-Azure Container Registry _ Microsoft Azure

In Chrome, I get less help

2020-07-07 15_22_05-Window

I know that the image path is under /mssql/server, but again, on Firefox, I get to to product home page. On Chrome, I get the same thing.

2020-07-07 15_24_32-Window

On StackOverflow, someone suggested a /v2 in front of the image path, and adding a /tags/list to the end. I did that and got redirected to this long URL: https://mcrflowprodcentralus.data.mcr.microsoft.com/mcrprod/mssql/server?P1=1594158334&P2=1&P3=1&P4=Aszj4JeNRzzbgvYq1xWs5CNXVSSIubeP%2FOko5OfNcpk%3D&se=2020-07-07T21%3A45%3A34Z&sig=ZVZdW1JcHuONk7pFh%2BGo%2FV8V6I7HKaLDsrAz0ru6dIA%3D&sp=r&sr=b&sv=2015-02-21

2020-07-07 15_29_26-Mozilla Firefox

That works since it apparently gets me the Docker API with the v2.

The main problem for me was that I wanted to get the latest 2019 image, without using latest. I tried this:

docker pull mcr.microsoft.com/mssql/server:2019-CU1-ubuntu

However, that doesn’t work. Apparently, since there are now two versions for Ubuntu, I need to add a – with that. Either a 16.04 or an 18.04.

Maybe I’ll remember that.

SQLNewBlogger

Containers are going to be important at some point and knowing how to work with them will be a desired skill. As I try different things, taking 10 minutes to document some knowledge is good. In this case, I give an interviewer a good reason to ask me if I actually remember this.

Posted in Blog | Tagged , , | 2 Comments

Daily Coping 8 Jul 2020

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here.

Today’s tip is to take a photo of something special.

I’m going to use a photo from this past weekend. I was able to get away in the mountains with my wife for a couple days, and it was a nice break from just being at home.

20200703_170723_HDR

My wife and two dogs, enjoying the river that runs through the ski resort. It was neat to see them really enjoying the afternoon.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 8 Jul 2020