Voice of the DBA

Tag: syndicated

A New Word: Koiniphobia

koinophobia – n. the fear that you’ve lived an ordinary life.

The last one of the year. I’ve enjoyed reading through this dictionary, learning new (made up) words, and thinking about life. Hope you have as well.

What’s an ordinary life? I think that’s what life is for many of us, though we have lots of little ups and downs, joys and sorrows, important events to us.

When I was younger, like many, I think I wanted to be a professional athlete or a rock star or a movie star or someone famous. Later, as I went through school and the tech booms, I wanted to be a rich tech person.

None of those happened, but I’ve had an amazing life. I think in many ways, it’s very pedestrian, and I walk through my days doing ordinary and simple things. I work at a desk, I shop for groceries, I go to the gym, I fix things around the house, I feed horses on the ranch.

I am also blessed to travel for work and stand on stage in front of many people. However, lots of my friends do the same thing.

I know I’m famous in a very narrow, weird way, but I also very much enjoy my anonymity in most of my life. I appreciate the time I have with others in my family, friend group, and community, as someone just participating in life with them.

I have no koiniphobia, not because of my life, but because everyone I know has their own interesting, unique, exciting things in their life. We don’t need to be on stage or in the media to live a very unordinary life. That’s what life is.

From the Dictionary of Obscure Sorrows

December 29, 2023
Friday Flyway Tips–Above Target Migrations

Recently I was working with Flyway Desktop (FWD) and practicing deploying certain migrations and not others. I don’t recommend this, but a customer was doing this and I wanted to reproduce some things they were trying to help them.

In doing this I discovered a bunch of scripts marked as “Above Target” in the GUI, but not in the database. I learned a few things from our support team.

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.

Setting a Target

I’ve got a FWD project here, and you can see the migrations below. In this case, I’ve selected a target of my QA machine and we can see that I have migrations applied up to 3.1 and there are pending migrations from 4-8 (ignore the undo).

Now, I want to migrate QA, but only to version 5. When I do this, from “Advanced Settings” on the right, I’ll see the target is listed as a parameter, and if I’ve highlighted the parameter on in the script.

I’ll run migrate, which works.

When I close this, I now see a different view. I see success next to migrations 4 and 5, but I also now see “above target” listed for the other migrations.

That’s not great, for this reason. If I check the “only show pending migrations”, I lose all my migrations. In large, complex projects, this isn’t good.

Getting Pending Migrations Back

The easy solution to this is to remove the target. If I click the “x” on the target parameters…

And then click Refresh at the top, I now see my migrations as pending.

Seems obvious, but I’d forgotten about the target as I was focused on testing the code I’d released and then wanted to release other code. Peter in support educated me on what I was missing.

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:

December 22, 2023
A New Word: the whipgraft delusion

whipgraft delusion – n. the phenomenon in which you catch your reflection in the mirror and get the sense that you’re peering into the eyes of a strange, as if you’re looking at a police sketch of your own face aged forward twenty years, which would imply the real you is out there somewhere, wandering the streets of your old neighborhood, still at large.

Twenty years? More like thirty.

I thought about this as I don’t really look at myself in the mirror often.I certainly see myself, putting in contacts, brushing teeth, shaving, but I don’t often look closely.

However, once in awhile I’ll look at myself and while I don’t always mentally feel or act my age, I don’t feel this old. However, if I look closely, I realize I look old. As old as my knees and back feel some days. Definitely some whipgraft delusion.

From the Dictionary of Obscure Sorrows

December 22, 2023
Creating a Scripts Folder in SQL Compare

While I was at a conference recently, someone asked me about the Scripts Folder feature in SQL Compare and how to set that up. This post just looks at how to get SQL Compare to set up a Scripts folder on a machine.

This is a part of a series of posts on SQL Compare on my blog. You can read other posts I’ve written by clicking the link.

Getting Started

I’ve got a D: drive on my machine that looks like this.

I’m going to create a folder, called “Compare Script Folders”, which you can see is empty. This is where I’ll store the scripts for various databases.

I also have a couple databases I use to test things on a local instance. You can see below my “compare1” database has a few things in it.

Now, I want to get a text copy of my schema from SQL Compare that I can use to check for changes, so let’s do that.

Creating a Scripts Folder

In order to create a scripts folder, I need to run SQL Compare. Once I do that, I see a screen like that shown below.

By default, SQL Compare looks to compare two databases. However, I can change the source. If I click the drop down next to Source, I see all of the options I have available. One of these is Scripts folder, which I’ll select.

Once I do this, my dialog changes. Now, I have the ability to compare a Scripts folder to a database. How do I get the Scripts folder? I click the Create link shown below.

I missed this a few times, so that’s part of why I wrote this post. Once I click that, I get a new dialog. This is the one that let’s me choose the way I want to create the folder.

Just like the comparison, I have a number of choices for the source. I can use various items, but in my case, I’ll choose database.

Once I do this, I enter the credentials to access the database. Note that I’ve clicked “Trust”, which is required for all modern versions of SQL Server. I have also selected the new folder I created.

Once I click Create, the engine will start to script out my database into separate files. This is the same process used when running a comparison, but in this case the results are just output to files rather than held in memory to compare with another set of objects.

Once the comparison completes, I see a new folder created below the folder that was in my dialog.

Inside this folder are all my objects, separated into different folders, which is the SQL Compare structure. This is the same structure used in SQL Source Control and Flyway.

Now I can use this as the basis for a source or target against another source or target in SQL Compare.

If you want to do this from the menu, there’s also an item in the File menu to get the Create Scripts folder dialog.

SQL Compare is a fantastic product for simplifying work and it does so much more than this. Give it a try if you own it or download an evaluation today.

December 20, 2023