Voice of the DBA

Tag: syndicated

  • Installing Flyway Community on Windows

    One of the things I’ve been trying to do is dig in more deeply to the Flyway command line (CLI) as part of my work with Redgate. While Flyway Desktop is amazing, it’s a wrapper, and my inclination is to ensure I understand the underlying technology.

    When I first downloaded Flyway, it wasn’t obvious what needed to be done to connect in different ways, so I decided on a short tutorial that would help me remember how and teach others a few things. This post goes over downloading Flyway and getting started.

    Setup

    The setup for Flyway is easy. The Community version is free, though there are also Teams and Enterprise editions.

    2022-12-27 10_42_52-Download pricing - Flyway — Mozilla Firefox

    Flyway Community works on many platforms. I’ll choose Windows below.

    2022-12-27 10_44_47-Community edition - Flyway — Mozilla Firefox

    The Windows version is a zip file. Click this, and it will download.

    2022-12-27 10_45_35-Command-line - Command-line tool - Flyway by Redgate • Database Migrations Made

    Then unzip this. I have a c:\Utilities folder where I keep stuff and I’ve added a flyway folder there. I unzip the latest into this folder.

    2022-12-27 10_46_47-flyway

    If you care about versioning, you might drop Flyway into a version named folder, but I typically don’t on this machine. For production deployments, I would be more careful.

    You then need to add this to your PATH. If you are on Windows 10 or 11, then in the Control Panel (Windows+I), search for environment. Edit the variables for your account.

    2022-12-27 10_47_57-Settings

    Once the new dialog appears, find the PATH variable and click Edit.

    2022-12-27 10_48_04-Environment Variables

    Now add an entry for the folder where you extracted the Flyway files. For me, this is c:\utilities\flyway.

    2022-12-27 10_48_12-Edit environment variable

    That’s it, Flyway is installed.

    We can check at the command line with “flyway version”.

    2022-12-27 10_51_19-cmd

    If you have entered a license key, then you’ll see that message.

    2022-12-27 10_50_47-cmd

  • Daily Coping 4 Jan 2023

    Today’s coping tip is to share something helpful with a friend that you learned recently.

    I share a lot with my wife and kids. They are a big part of my life, and it’s important to make them a part of mine. I’m not a big shar-er in general, and they might say I don’t share a lot, but they get more than anyone else.

    One of the things I learned recently was during my volleyball coaching certification. One of the modules looked at a seasonal plan for coaching. I hadn’t thought of breaking the season this way, but the advice was:

    • First third – 50% single skills, 30% controlled drills, 20% play, bonding
    • Second third – team system, look at stats, strategies, hide weakness
    • Final third – 80% play, offense/defense concepts

    I think that’s a good approach and my wife and I are thinking to implement this.

    The other thing I learned and shared was serving percentages over time from different locations to different ones. We’re emphasizing players think about this:

    2022-11-09 12_42_20-Volleyball_ Correlation between server location and serve success2022-11-09 12_41_53-Volleyball_ Correlation between server location and serve success2022-11-09 12_40_49-Volleyball_ Correlation between server location and serve success

    I started to add a daily coping tip to the SQL Server Central 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.

  • Daily Coping 3 Jan 2023

    Today’s coping tip is to use one of your strengths in a new or creative way.

    I have a lot of strengths. They’ve helped me to be successful. This tip is a hard one for me, as I need to get out of my comfort zone and try something new.

    One of the strengths that has helped me is explaining concepts, ideas, etc. to others. It’s a lot of what has helped grow SQL Server Central over the year.

    I’m going to take some time to explain how I approached some problems in Power BI and then take feedback. I’m sure there will be lots of suggestions and advice that helps me improve, but my goal is to provide a model that even though I’m not a guru or an expert, I’m going to display what I know, and then improve based on what I learn from others.

    Hopefully I get more of you to blog and showcase your knowledge in the same way.

    I’m starting with two projects. A Flyway one (first post tomorrow) and a Power BI one next week.

    I started to add a daily coping tip to the SQL Server Central 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.

  • Daily Coping 2 Jan 2023

    Today’s coping tip is to start the new year off with something new – listen, watch, read something completely different.

    I started listening to more country music last year. It’s an interesting genre, especially from the guitar standpoint. I’ve learned a few songs and want to work on a few more.

    I’m starting today out with a few playlists that are outside of the normal things I listen to. No work (maybe), but I’ll put in the top songs from

    • Kelsea Ballerini
    • Luke Combs
    • Thomas Rhett

    It will be an interesting day.

    I started to add a daily coping tip to the SQL Server Central 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.