Come to a Redgate Summit in 2024

This week is the first Redgate Summit of 2024. It’s Wednesday, in Atlanta and you can register and join me if you’re in the area.

These are full day conferences, with multiple tracks, similar to the SQL in the City conferences we used to run. With our move to supporting database professionals on any platform, anywhere, we’ve rebranded these as Redgate Summits. Come join me at one of the following dates, if you are anywhere in the area:

I’m not sure if we’ll be doing Redgate Summits in AUS this year, but I’ll be in Brisbane, Sydney, and Melbourne in May.

The Atlanta schedule is packed, with especially for Grant and me, but we’ve got engineers, Friends of Redgate, and other experts coming. We’ve got some AI experts as well, and with three tracks, there will be plenty for you to learn. Ask us questions, get inspired, find out how you can better build and manage database software.

Hopefully I’ll see you are one of these events this year.

Now, back to holiday today for me, as I’m coaching the final day of Colorado Crossroads for my 13s team, as well as helping with an 18s team.

Posted in Blog | Tagged , , | Comments Off on Come to a Redgate Summit in 2024

Republish: Have You Deployed an Availability Group?

I’m taking a day off to coach at Colorado Crossroads today. It’s the last day of a 3 day volleyball tournament and I’ve got my 13s and I’m helping with 18s. Hopefully not at the same time.

You get to re-read: Have You Deployed an Availability Group?

Posted in Editorial | Tagged | Comments Off on Republish: Have You Deployed an Availability Group?

Friday Flyway Tips–Undoing Development Changes

I had a customer ask about undoing changes made by developers, similar to what SQL Source Control does. I had to do a little research to show how to do this, which is the tip this week.

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.

Making Changes in Development

I’ve got a few changes I want to make. You can see these in the image below, where I’ve added a column and then a couple of tables.

2024-02-29 11_30_19-Custom Selection

I test this (hopefully) and I come to Flyway Desktop, where I can see all my changes listed in the Schema Model tab.

2024-02-29 11_30_35-Custom Selection

At this point, I realize that I’ve done something I don’t want. I don’t want the column to be named something. Maybe I misspelled it, or maybe I modeled it wrong. I can easily fix this in Flyway Desktop.

At the top, you see there is a Save to Project and Apply to Database set of radio buttons.

2024-02-29 14_17_05-

This is a two way comparison, with the options reversing each other. The Save item will write database changes to the file system in the repo. The Apply will read the repo and make the changes in the database.

In this case, you can see below that when I select the Apply radio button, I get the notification that my column will be deleted.

2024-02-29 11_30_56-Highlight

Once I click “Apply to Database” (the big blue button), these changes are made.

If I check the database, I can see my column is removed, but my tables still exist, since I didn’t check their boxes on the left.

I’ve undone a change. Now I can commit these two tables, if that’s what I need, or I can also add back a better named column and refresh this if needed.

Try Flyway Enterprise 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:

Posted in Blog | Tagged , , , | Comments Off on Friday Flyway Tips–Undoing Development Changes

Is This a Good DBA Job Description?

I saw this on one of the syndicated SQL Server Central blogs: Job Description of a DBA. This is mostly a list of things, but it covers a lot of the general types of things that many of us expect a DBA to do. However, my question is whether you think this is a good description for a job opening. Would you ask someone to fill this list of things?

Maybe a better question is whether you could use this to evaluate candidates, and how would you go about asking questions or gauging a fit based on this. Perhaps you should ask yourself how you evaluate others and if there is a good way to rate them against a list of daily tasks.

To be fair, I know most job descriptions often include many “desires” along with “needs.” That can be maddening to many job seekers, as they don’t feel qualified. What I’ve found when building descriptions is that a wider variety of people provide input for what they would like in an employee than just the hiring manager. The hiring manager might weigh these items differently and accept someone who doesn’t know replication well, even though replication is used if the candidate is skilled at query tuning. I would say expert, but how do you judge that? Most of us would probably settle for someone who can improve queries even just a little bit.

When I interview people, I want to know a few things. One is can I get along with them, as well as the rest of the team. This isn’t to discount technical skills, but we need to be a team. If we can’t get along, and maybe more importantly, disagree civilly, it’s hard to work together. We do need to bond, though that doesn’t need to be over a drink or sporting event. However, we might need to share a meal, so I hope we can enjoy a conversation for an hour.

The other thing is that I need to see some effort and desire to succeed. I don’t need someone to be an expert, but I do need them to show an interest in helping our customers, whoever they are. Part of that is trying; part of that is getting to the end result. I see far too many people that don’t try to solve problems or care that there is someone waiting on a solution. I also see too many people unwilling to try and improve the environment, whether that’s a codebase or server configuration.  They might be good at their jobs, but I like to associate with people who want to make the world better. People who think forward, who ask questions, who under-promise and over-deliver.

I think the job description I linked above is a good one, fairly comprehensive in scope, but lacking in lots of details. The devil is often in the details, especially in how hard someone might work to complete these tasks, and if they would work to do so to meet their commitments, but also do so in a quality manner. And, of course, under pressure. Most of us know that things break, and when the thing is a database, a good DBA is invaluable in restoring service under pressure.

Steve Jones

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

Posted in Editorial | Tagged | 2 Comments