Voice of the DBA

Category: Blog

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

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

  • Daily Coping 7 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 few minutes and do something fun for yourself.

    Last week I drove to the mountains to be sure I could host the SQL in the City Streamed – APAC. We were having construction at the house and I couldn’t find a quiet place there. I expected to go up, work, spend the night, and then have my wife and kids join me.

    Instead, my wife decided to stay home and work, sleeping in our camper. My daughter joined her, which uses up all the comfortable beds in there. My son went to hand out with friends, and that left me alone at our condo for a few nights.

    At first I thought about going back early, but decided not to crowd anyone out of a bed and instead take some time and reflect on life and enjoy myself. I had to work, but I also spent time walking around, enjoying the beautiful Colorado mountains, and getting away from my normal life. All in all, a bit of an indulgence for me, but a good one.

  • Getting the Proc Code–#SQLNewBlogger

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

    I saw a question recently about getting the code in a stored procedure. I’ve become dependent on SQL Prompt, which gives me a nice preview of code when I see a proc:

    2020-06-30 16_42_34-ObjectDefinitionBox

    The main way I’ve gotten code is right clicking a proc in Object Explorer and clicking Modify. That opens up an ALTER statement for the proc.

    2020-06-30 16_42_44-

    However, there’s one more way to do this: sp_helptext.

    2020-06-30 17_26_18-SQLQuery2.sql - ARISTOTLE_SQL2017.Sandbox (ARISTOTLE_Steve (82))_ - Microsoft SQ

    Not the best solution, but it gives me a quick look from SQL without futzing through a big list in the OE.

    SQLNewBlogger

    This is a quick example of some knowledge that I can use in my regular work. When someone asked the question, I knew the code for procs was stored somewhere, but I wasn’t sure what the proc to get this was. I tried sp_help, but that wasn’t right, so I had to go look up sp_helptext.

    This took about ten minutes to write.