Friday Flyway Tips – Adding the Type of Database Project

There was an update to Flyway Desktop which lets you see the type of database your project is associated with, and this post shows how to get this in your list of projects.

As an example, you can see below my first project is a “SQL Server” project.

2023-11-07 09_27_18-Flyway Desktop

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.

Two Simple Steps

The first step to seeing the type of database project is to upgrade Flyway Desktop. The team is releasing basically every week. My version, upgraded before this post, is 6.9.3, so anything after this should have this capability.

The second step is you need to open your project. If I open the “DBCode” project above, it starts the comparison.

2023-11-07 09_28_51-Flyway Desktop

I don’t have to wait for the comparison, I can just close the project. Once I do, the type of project appears on the right side.

2023-11-07 09_29_57-Flyway Desktop

If you’ve been working with Flyway Desktop for awhile, you might have noticed an “Upgrade project” in the upper right. This is to upgrade the project from a JSON format to a TOML format, which doesn’t matter for you, but it does make the management of the internals of Flyway and Flyway Desktop easier for the developers.

In any case, you don’t need to upgrade the project. If I open and close a PostgreSQL project, I see this:

2023-11-07 09_30_22-Flyway Desktop

If I reopen the FWPoC_PostgreSQL project (named before this feature appeared), I see the upgrade is still there.

2023-11-07 09_34_50-Flyway Desktop

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:

 

Posted in Blog | Tagged , , , | Comments Off on Friday Flyway Tips – Adding the Type of Database Project

30 Years of SQL Server on Windows

I’ve spent over 30 years working with SQL Server. I saw a post recently from Bob Ward who is celebrating 30 years at Microsoft, noting this is also the 30th anniversary of SQL Server on Windows. It’s been an honor for me to get to know Bob, learn from him, and spend time socially at various events around the world. He’s truly been a force in improving the SQL Server platform through the years.

While SQL Server has been on Windows for 30 years, I’ve got a bit more than 30 years working with the platform as I actually started managing a SQL Server instance on OS/2. With the addition of Linux, I’ve now run SQL Server on three different server OS hosts: OS/2, Windows, and Linux. That’s somewhat amazing to me, especially as one of my April Fools jokes came true. This was one of the most-read articles on SQL Server Central for a long time, and perhaps it influenced enough people at Microsoft to build and release a Linux version.

Over three decades, the growth of the platform has been amazing. We’ve had the core engine lose tables in memory and then get them back with In-Memory objects. We have seen the heavyweight trace evolve into Extended Events and SQL Audit. The language has grown with many new ANSI features that help us write better code. We’ve deprecated a number of objects and added the ability to create our own with the CLR. We’ve added new data types, not all of which are named well, but we still have the ability to process more types of data natively. We’ve even added new services, with SSIS, SSRS, and SSAS packaged into the platform.

Not a lot has been removed, but a few things are gone, like Notification Services. Replication doesn’t seem to have changed a lot in 30 years, which is a bit disappointing to me, but there have been a lot of improvements in HADR capabilities. We even have other companies (Amazon and Google) selling their own version of SQL Server as a platform, where you don’t have to manage the instance.

In many ways, I’ve found SQL Server to be easier to use, but also much harder to learn about because the breadth of what’s in the product is so wide now. I can’t imagine anyone actually knows the entire product at a very deep level. I’ve also found myself more disappointed with the experiments Microsoft makes when adding features and not continuing to invest and evolve them (or even fix all the bugs).

There certainly have been plenty of bugs, security issues, and maddening moments in working with SQL Server, but it’s been a great 30 years of a career working on the Windows version. I likely won’t do that for another 30 years, but I hope those of you making a living working with the platform enjoy it as much as I do.

Steve Jones

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

Posted in Editorial | Tagged , , | Comments Off on 30 Years of SQL Server on Windows

A New Word: Heartspur

heartspur – n.  an unexpected surge of emotion in response to a seemingly innocuous trigger – the distinctive squeal of a rusty fence, a key change in an old pop song, the hint of a certain perfume – which feels all the more intense because you can’t quite pin it down

I certainly feel heartspur at times. I can be emotional, and I find that there are lots of things that trigger memories. Often I know why or when the memory occurred, but not always. Especially as I get older.

Recently I heard Waterfalls on a playlist. I remember listening to this with my wife in the car, and it’s a great song. But I know that I heard this before I met her, and evoked a strong emotion of sadness. I can’t quite remember why, and still don’t.

If only I’d had a smartphone in 1994 and had taken a lot of pictures. Maybe I’d know why this one trigger something.

From the Dictionary of Obscure Sorrows

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

Advice for 2023 PASS Data Community Summit Attendees

Edwin Sarmiento has a great First Timer Guide for the PASS Data Community Summit, which is updated for 2023. He’s been compiling this since 2016, and it’s worth reading.

I (along with Grant and Ryan) got asked to record some video tips, which we did. I had fun one afternoon while handling some ranch chores. Hopefully you smile when you watch mine in this playlist.

I decided to put a few things down in a post, to help those getting ready, based on my past experiences. Seattle has changed a lot, but it can be a fun place to visit. I’ve added a few sections below for:

Travel

I assume most of you can make your own travel arrangements, and Edwin has good advice in his PDF. I’ll just say that traffic in the area can be really, really bad. The train isn’t too bad, but from SEA –> downtown, it can be slow. Quite a few stops. It’s cheap, and the time is consistent. It lets you out below the Nordstrom’s, a few blocks from the convention center, but in the middle of lots of hotels.

An Uber/Lyft works well, but can be pricey. I’ve seen surge pricing more than double the cost. I think I’ve paid $25 and I’ve had $70, so I would suggest that you try to share rides with others. Lots of people coming into town, so reach out to friends, colleagues, anyone on socials with your arrival time and maybe go in a group.

Plus, the ride is a good time to network.

DO NOT RENT A CAR. Parking it cra-say-zy expensive at Seattle hotels. Plus, this is a walkable city. You’ll be able to walk easily to the Space Needle or waterfront if you want.

Seattle could have mild weather or it could be cold and rainy. It’s November, so plan for rain and 40F/8C. It it’s nicer, then great.

Food

I am not a big foodie, so take this with a grain of salt. Quite a few places have closed with the pandemic, but there are still some places I’ve enjoyed.

Hotel food is pricey. If you’re on a budget or per diem, watch out. The Cheesecake Factory is generic American chain, but it’s good and it’s across the street from the convention center. It’s been a place I’ve sometimes had a quick meal, and they don’t seem to get too crazy busy.

If you want to spend too much money on Whiskey, the Hyatt has a whiskey bar. It is $$$$, but friends who like whiskey like it.

Purple Cafe is cool. A wine bar with some interesting food, but it gets busy. Best bet is go off hours or pray for a bar seat.

Lowell’s in the Pike Market is nice for a diner type place and I’ve had a nice meal with a view. There are some nice little coffee/bakery places in the market. I also had a great Filipino breakfast at Ludi’s. I know a lot of people enjoy Top Pot Doughnuts or Biscuit Bitch.

Keep in mind that there will be a lot of people downtown between Ignite and the Summit, so go early to places or don’t be in a hurry. Or go with just 1-2 people. Groups that are bigger get harder to seat.

Conference Tips

Power will be hard to come by, so charge when you can, carry a battery, and watch your cell usage. You might go airplane mode during the day and use wifi for notifications from work.

The Community Zone is a great place where many speakers, SQL Saturday organizers (and other events), and others (esp Microsoft people) hang out. It’s worth stopping by there periodically and meeting people. Listen in on conversations, introduce yourself and say hi. Take pictures, and learn to get more involved in the data community (and #sqlfamily). Even if you’re introverted, it’s a good place to practice your networking.

The expo hall is good. The vendors certainly want to sell you services or software, they give away prizes and swag. That’s a part of conferences, so enjoy it. Take something home to a coworker or family member, ask questions of vendors. They might have a solution that helps you, but many of them are tech people as well and might suggest a solution. I’ll be at the Redgate booth at random times, and I certainly am happy to solve problems not related to Redgate tools.

Take advantage of Microsoft people at the event. Either in sessions or in the expo hall. Ask about issues, complain about problems, learn from what others ask. You never know when you’ll learn something.

If a session is interesting, or you have a question, ask. If you’re shy, hang out after and ask the speaker at the end by the stage. Or listen to what others ask. I’ve often just lurked near the speaker of a good session to see what others ask and if there is something I haven’t thought of.

Take care of yourself. These are long days. Drink water, don’t over eat, and don’t over drink. As Edwin notes, RND (RSVP for stuff, network, and drink in moderation). Enjoy the week, and expect long days.

Don’t carry too much stuff. If you don’t need a laptop, get by with paper and pencil. I think it helps you remember more, and I don’t need to charge a notebook. This year most stuff is in the main convention center, but still, it’s a lot of walking.

Tourist Things

The Space Needle is an icon. If you haven’t been in that area, it’s neat. The Music Experience Project and Sci Fi Museum are there as well, and I’ve been multiple times. In fact, I was at the MEP in July with my family and loved it.

The Underground Tour is neat. I’ve done these in a few cities, but Seattle is one of the best. The late night one is the best (I’ve done the early and late ones).

I took my kids to the Museum of Flight, but I loved it as well. There is a great Children’s museum as well. The Boeing factory tour in Everett is far, but I loved it. I did go pre-pandemic and saw 5 or 6 747s in one building. That was incredible.

The Pike Market is an icon. On the weekends, if you’re there, lots of people are selling wares in small market shops. Watching them throw fish is cool. At least for 5 minutes. The waterfront has a few nice museums and it’s a nice place to hang out. The original Starbucks is there. Lots of people line up to go in and take pictures, but I wouldn’t stand in line. Nothing amazing about it.

There is a Game Night on Wednesday night, but there are some Game bars in Seattle. It’s a vibrant, albeit expensive, town, so take advantage of that. Make friends, go out and enjoy yourself.

Posted in Blog | Tagged , , | Comments Off on Advice for 2023 PASS Data Community Summit Attendees