Friday Flyway Tips–Commit and Push

Posted on September 15, 2023 by way0utwest

Flyway Desktop includes version control features with Git. One thing that was added in v6.5+ was the ability to commit and push.

I’ve been working with Flyway Desktop for work more and more as we transition from older SSMS plugins to the standalone tool. This series looks at some tips I’ve gotten along the way.

All in One Press

This isn’t a big change, but it is one that customers have asked for. On the version control tab, when you have changes, they are listed with a commit button in the lower right.

2023-08-25 16_06_35-Flyway Desktop

We’ve added a drop down to this.

2023-08-25 16_07_13-Flyway Desktop

If you click this, you now have commit or commit and push options.

2023-08-25 16_07_17-Flyway Desktop

Pick the lower one, and you’ll get things committed and pushed up.

2023-08-25 16_17_42-Flyway Desktop

The choice isn’t saved, which I think isn’t a great design choice, but for now, you do have the option with each commit.

Try it out today. If you haven’t worked with Flyway Desktop, download it today. There is a free version that organizes migrations and paid versions with many more features.

Video Walkthrough

I made a quick video showing this as well. You can watch it below, or check out all the Flyway videos I’ve added:

https://youtu.be/QsWVcYxFdnM

Posted in Blog | Tagged , , , , , | Comments Off on Friday Flyway Tips–Commit and Push

Advice To Be a Better Person

Posted on September 15, 2023 by way0utwest

As a hobby, I coach volleyball for kids. Each year I meet new kids and parents and talk about my philosophy. Part of that is that I teach skills, athletics, how to compete, and more. However, I do emphasize as well that I’m trying to build better people, not just athletes. I want these kids to be better prepared for life, for job interviews, for future teachers and coaches, and for better relationships.

While I’m not perfect, or maybe not even a great person, I do try to improve myself on a regular basis. Or at least learn to be a better person to others. This isn’t because of any ideal or goal, but because life is more fun when I have more skills. Whether that’s working with objects or interacting with people. The smoother things go, the more I enjoy the world.

I ran across some advice from Kevin Kelly, who helped co-found Wired Magazine. He wrote down 68 pieces of advice for his children on his 68th birthday. A few of them are in this post, though he’s written a book with 450 pieces of advice. A few more items are in his post of 99 pieces, and 103 pieces.

The advice is about career, life, and more. Some of the more interesting ones I saw are listed below, with my comments:

  • About 99% of the time, the right time is right now – I struggle with this, but as I think about it, it’s been often true
  • Don’t keep making the same mistakes; try to make new mistakes. – I certainly aim for this. I hate making the same mistakes
  • If you stop to listen to a musician or street performer for more than a minute, you owe them a dollar. – I love seeing street musicians and I carry dollars/euros/pounds and more I can give out.
  • If you have any doubt at all about being able to carry a load in one trip, do yourself a huge favor and make two trips. – I find doing this means I drop less things. Not doing this means I drop more.
  • Recipe for success: under-promise and over-deliver. – Often my mantra at work
  • It’s not an apology if it comes with an excuse. It is not a compliment if it comes with a request. – This is hard, but I’ve been working on this.
  • Learn how to learn from those you disagree with, or even offend you. See if you can find the truth in what they believe. – Important in today’s world
  • Being able to listen well is a superpower. While listening to someone you love keep asking them “Is there more?”, until there is no more. – I need to do this more

I grabbed his book, and you can as well. However, I might also suggest you collect your own words of wisdom and advice that you can share with your own loved ones at some point.

If you want to see Mr. Kelly speak his advice, watch this video.

Steve Jones

Listen to the podcast at Libsyn, Spotify, or iTunes.

Posted in Editorial | Tagged , | Comments Off on Advice To Be a Better Person

A New Word: Justing

Posted on September 15, 2023 by way0utwest

justing – n. the habit of telling yourself that just one tweak could solve all your problems – if only you had the right haircut, if only you found the right group of friends, if only you made a little more money, if only he noticed you, if only she loved you back, if only you could find more time, if only you were confident – which leaves you feeling perpetually on the cusp of a better life, hanging around the top of the slide waiting for one little push.

I find a lot of people that have justing, thinking their are quick, easy solutions just out of reach. Of they focus so much on the one thing they desire, ignoring the rest of life. Or at least diminishing it.

I try hard not to have justing. In fact, lots of comedians have helped me to view the world differently. I accept where things are, I know there is chaos and struggle and other difficulties. I have to just accept and account for them, not wish things were different. Instead, I view the world as imperfect and not always here for me but still a place to appreciate and enjoy.

I can’t always get to the gym or I don’t always eat as well as I should. I accept that and work with it, not wishing it were different. I accept my faults and frailties, and I try to nudge them in better directions, knowing they will always be there.

I remind clients of this at work. There is no perfect way to build software, and you will always have some issues. You’ll always have some staff insufficiently trained, you’ll always have some people you don’t like. Work with that imperfection and don’t think about justing.

From the Dictionary of Obscure Sorrows

Posted in Blog | Tagged , | Comments Off on A New Word: Justing

Creating Empty Repos in Azure DevOps–#SQLNewBlogger

Posted on September 13, 2023 by way0utwest

I saw someone struggling with getting started with a Visual Studio project and Azure DevOps. They got a conflict, which I’ll show and then get you started with an empty repo.

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

The Problem with Initialized Repos

First, I’ll open VS 2019 and create a new database project. I won’ t walk through that, but once I do, then I can add my project to source control. In the lower right corner, this is an option:

2023-08-09 12_58_07-Zoomit Zoom Window

I’ll choose a local repository here. I see plenty of people do this if they don’t want to use GitHub.

2023-08-09 12_58_34-

Now, I go to Azure DevOps and create a project. I initialize that project with a Readme, which seems like a good idea. You can see my online repo below:

2023-08-09 12_56_01-VS DB Project Test - Repos

When I create this, I get the options to link an existing repo or push up.

2023-08-09 12_59_54-Database2 - Microsoft Visual Studio

However, if I try to link my existing local repo, I get an error.

2023-08-09 13_00_19-Database2 - Microsoft Visual Studio

Why? I have a commit in the report (initialized with a readme) and commits locally. That’s a conflict.

Creating an Empty Repo

The way to avoid this is make an empty repo in Azure DevOps without anything in it. When you see this screen, un check the “add a README”. No matter how much you want to have one, don’t do this.

2023-08-25 16_35_11-VS DB Project Test - Repos

Now, you have an empty repo for the remote. You should see this online, with the first line noting this is empty. From here, you can use the second box to push your repo from the command line.

2023-08-25 16_36_17-Files - Repos

SQLNewBlogger

This post was easy for me, but I’ve been in the situation where I’ve made this mistake. It’s annoying, but it’s also confusing as you should be able to make changes in both repos. That’s why we use git.

You can, but not when both are initialized. You need to clone one from the other.

This post took me about 15 minutes to create, with a good portion of time spent creating the scenario twice (two repos) and the db project in VS, which is slow. You could do this same thing and show how (and why) you set up a project linked to source control. If you use a couple systems (one at work and one at home) make two posts!

Posted in Blog | Tagged , , , , | 2 Comments