The PASS Data Community Summit On Guy in a Cube

I’ve known Adam and Patrick for a long time and I’m thrilled with the content they produce on their Guy in a Cube show. It’s a great resource for anything Power BI, and now, starting to cover Microsoft Fabric.

I’ve been on their show before, but we did a new episode recently, talking about the PASS Data Community Summit 2023. They are teaching a pre-con session on Fabric and I recommend going to this one if you have a need to do data warehousing in Azure.

Give the show a watch, and I hope to see you in November in Seattle. It’s a great trip for both you and your employer. You’ll get a lot of value from the event and I’m sure you will bring some knowledge back to your team.

Posted in Blog | Tagged , , , , | Comments Off on The PASS Data Community Summit On Guy in a Cube

Looking Forward to the PASS Data Community Summit 2023

I was lucky enough to attend the very first PASS Summit in 1999. It was a brand new event, and while not overly large, it was busy and crowded in the basement of a Chicago Loop hotel. I had the chance to meet Kalen Delaney there and ask her a question. That was the highlight of the trip, but I also learned a lot about SQL Server 6.5 and 7 there, spending all the time I could in sessions and hanging out after each one listening to the questions others asked the speakers.

Since then, I have been lucky enough to go to most of the Summits. The event has changed a bit, and I look forward to going to see friends each year and re-connect with them. I’ve also loved meeting new people, often those I’ve corresponded with online. Each event has been memorable and exhausting at the same time. It’s a busy week, and I can sometimes feel overwhelmed. However, it’s always felt like it was worth the trip.

I saw a video from Kendra Little where she talks about what she’s looking forward to this year. She has a few things on her mind: connecting with people, learning from the people who write the software, learning from those that use the software, broadening her horizons, and being a part of the data community.

My thoughts are similar. Last year I was looking forward to the event in person, but apprehensive with all the commitments I had for Redgate with speaking. This year I’m much less involved, working more on things before the Summit and I’m hoping I can enjoy the experience more with less work during the event.

For many years I was always excited about the SQL Server Central party. That was a highlight for me and I was sad when the referrals that funded it went away. Perhaps I’ll get find a way to get it back in the future. For now, I want to connect with more people. I want to do this casually in a few ways. From the #sqltrain on Sunday to a few quiet dinners with friends during the week to taking time at night to attend some of the events that various vendors will sponsor, that will be a great chance to bond with friends (new and old) in a social way.

I also want to connect more professionally with people, which I’ll do in the Community Zone, as Kendra suggests, but also around the convention center. I am planning on not having to rush to many things, which means I’ll have more time in hallways and after sessions to talk tech with speakers and attendees. I’m always amazed by the ways some of you use databases and software, and I find myself learning creative solutions that I might suggest to others in the future.

The last thing that I’m looking forward to is the chance to motivate a few more people to run SQL Saturday events in 2024. We’ve had some new events in 2023, a few more than 2022, but not nearly as many as we used to see each year. I’m hoping to connect with more community leaders and volunteers to try and get them to consider organizing an event in the future.

The Summit is a great investment in your career as a data professional, and it can be a good investment for your employer. Make a case, show them you want to learn and grow, and that what you learn there will help you in your job. It’s a park for those of you that bring value to your employer and the can help with retention. You’ll gain knowledge and make contacts that help you on a daily basis.

I hope to see you in Seattle this November.

Note: The price goes up Sept 20, so get registered before then.

Steve Jones

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

Posted in Editorial | Tagged , | Comments Off on Looking Forward to the PASS Data Community Summit 2023

Friday Flyway Tips: Visualizing Undo Scripts

One nice thing with Flyway Enterprise is that it will automatically generate the undo scripts for migration scripts. However, it used to be that finding these and seeing the script was hard. It’s easier after Flyway Desktop 6.5.2

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.

Undo Scripts

If you have Flyway Enterprise, you can have Flyway Desktop automatically generate scripts: both forward (versioned) and undo scripts.

The config option for this is in project options, which is in the upper right.

2023-08-10 15_53_53-Flyway Desktop

Clicking this

2023-08-10 15_53_57-Flyway Desktop

Once have this, if you add a new object, when you generate the migration script, Flyway Desktop will generate the undo script. In the older UI (pre 6.5) this was a script below the generated script, which meant you had to scroll down, or up and down to compare the forward and undo scripts.

The new UI is better. Now there is just a button. Let me show you how to do this.

First, I have a few changes in the schema model. I’ll select one.

2023-08-21 12_27_19-Flyway Desktop

Now I’ll generate the scripts. When I do that, I see the two scripts. The versioned (forward) script is first, and you can see the “Undo” at the bottom.

2023-08-21 12_28_05-Flyway Desktop

Below this, the rest of the undo script is visible if I scroll down.

2023-08-21 12_28_12-Flyway Desktop

It’s a bit of a pain to scroll up and down, so there is a small improvement in the migrations tab. If I go there, I can find my script at the bottom of the list and click it.

2023-08-21 12_30_33-Flyway Desktop

At the top of the script, in the bar, there is now a set of toggle buttons for version and undo.

2023-08-21 12_24_35-Flyway Desktop

I can click back and forth to easily see both scripts. The V script is above, and the undo is below.

2023-08-21 12_39_44-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: Visualizing Undo Scripts

A New Word: Merrenness

merrenness – n. the lulling isolation of driving late at night – floating through the void in an otherworldly hum, trailing red jewels in the darkness, your high beams seeming back and forth like a lighthouse.

This is certainly something I feel often. I don’t go out late a lot, but there are times I’m coming home and I feel merrenness. Not so much the side to side of high beams, but the up and down on the hilly country roads in Colorado. A bit of side to side as I get near the house.

This is especially something I feel in the Tesla, where there can be a hum and not much else. Watching the world go by, sometimes with music as a background, sometimes silence, reminds me of the wider world around me, both there and muted by the darkness.

From the Dictionary of Obscure Sorrows

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