Voice of the DBA

Tag: syndicated

  • Daily Coping 23 Sept 2021

    I 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. All my coping tips are under this tag.

    Today’s tip is to touch base with a friend and share something you appreciate about having them in your life.

    I don’t do this enough. I did earlier in the pandemic, but I’m starting to try and rebuild some of this habit.

    Today I reached out to a friend in Denver and texted back and forth for a few minutes to catch up and schedule lunch. I told them how much I appreciate the little time we get together and the change to share in each others’ lives.

  • Getting Up and Running with Dapr

    I’ve heard about Dapr a few times from developer friends, but hadn’t really understood it that well. I had a webinar coming up, so I decided to spend a bit of time working with it to understand how it might function with an application.

    I went to https://dapr.io/, and saw the basic outline of Dapr is in this video from their site. I also found this getting started video from Donovan Brown.

    What I gathered from this research is that Dapr is really a set of containers that run alongside your app or act as middleware between different components, including state stores. Most of us might think of a state store as a database.

    As a part of my learning, I went through some of the getting started tutorials.

    The Tutorial

    I followed the getting started tutorial. The first thing was to open a cmd prompt with administrative privileges and run this:

    powershell -Command "iwr -useb https://raw.githubusercontent.com/dapr/cli/master/install/install.ps1 | iex"

    Next, I needed to update. I ran the “dapr inti” in an elevated cmd line. I love the first part of this:

    2021-09-13 15_58_38-cmd - dapr init (Admin)

    I already have Docker installed, with Linux containers, so I can quickly continue.

    I need to start an app so that dapr can run as a sidecar. I don’t have an app configured, but I can run this as a blank one, according to the docs:

    dapr run --app-id myapp --dapr-http-port 3500

    The next step is to test this. I am supposed to use curl to post an http request with this command:

    curl -X POST -H "Content-Type: application/json" -d '[{ "key": "name", "value": "Bruce Wayne"}]' http://localhost:3500/v1.0/state/statestore

    When I do that, I get an error. Apparently, this doesn’t work in Windows, and really, it’s a bash request. Since I’m using the Windows CMD Prompt, I’m unable to read the instructions.

    2021-09-13 16_12_30-Use the Dapr API _ Dapr Docs

    I need to click the PowerShell option and get the Invoke-RestMethod cmd. When I do that, I see that the state is working.

    2021-09-13 16_13_16-C__Users_Steve

    I can also test this with an interactive connection to Redis. Again, in the tutorial, this lets me get to the data store.

    2021-09-13 16_14_40-cmd - docker exec -it dapr_redis redis-cli

    That was most of the tutorial. I worked with the config file, and then looked at the Hello, World tutorial. Overall, this was pretty simple and worked well for me.

    My Thoughts

    There is a lot of stuff going on here. The concept of a sidecar, is really a container that gets a network call from your app to do something. Then the sidecar does something else. It’s like middleware, or an app server in the older client/server or 3 tier architecture, but without the tight coupling and dependency. More importantly, this allows dapr to scale out and run as a separate process rather than being part of a monolithic entity.

    More work, but also more consistency and this gest you used to building an API rather than having developers inconsistently connecting things together.

    The goal here is really to think about microservices.  I don’t know if I think that’s the best way to build thing, but it is a trend, I like the cloud native focus, and it’s helpful to understand something about this when talking with developers about pros and cons.

    By the way, after my webinar with Donovan Brown and Mark Fussell, I learned this doesn’t require microservices or containers. It can run in many different software models, but abstracts away a lot of the SDK and API struggled with different technologies.

  • Daily Coping 22 Sep 2021

    I 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. All my coping tips are under this tag.

    Today’s tip is to leave positive messages for yourself to see regularly.

    I haven’t ever really done this in a physical sense. I have tried to keep positive messages in mind, notice the good things in life, nature, and others, and in general try to keep my attitude positive. It doesn’t always work, but I have gotten better at realizing when I am being negative.

    I decided to do this digitally. I have a couple friends that will reach out at times and send a positive note. That’s always good and I thought I’d leave myself a note digitally. I made myself an appointment for a random date and time. A small, 5 min item.

    2021-09-17 09_46_38-Remember a positive thing that happened yesterday and smile - Appointment

    When this comes up, I’ll look at it, take a minute to remember, and then I’ll set another positive message for myself for a random 6-9 days in the future.

  • Daily Coping 21 Sep 2021

    I 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. All my coping tips are under this tag.

    Today’s tip is to find a caring, calming phrase to use when you feel low.

    I have emotional swings, much like most people. I certainly feel low at times, and I’ve noticed them more during the pandemic.

    It might seem silly, and it’s a bit of a family joke, but the phrase from Stuart Smalley character of Al Franken often used is helpful.

    “I’m good enough, I’m smart enough, and doggone it, people like me.”

    It lightens my mood, makes me smile, and it helps me to take a step back from whatever is bothering me. My wife has used this on me a few times, and I’m trying to adopt it as a way to cope.