The Return to the Office Debate

At the end of last year, I ran into a friend I hadn’t seen in a long time. We were chatting and this person mentioned that they were looking for a new job. They had been laid off and needed something. This is someone with a lot of experience and skill, so I wasn’t worried for their career or future. At the time, they mentioned they had gotten an introduction and interest from Amazon, but they weren’t interested in a position because of the return-to-the-office (RTO) mandate that Amazon was implementing.

I was recently chatting with another friend at a different company. This person manages a tech team, and was looking to hire another data engineer, but was told they could only hire in a certain city (City A)  in the US. In this case, it was the city with their main office. They have offices in a few cities, and a large one in City B, but the organization has been thinking of their own RTO plans and has limited hiring. My friend is now wondering if they need to consider moving to City A (not likely) or find a new job. They don’t want to have to go to the office every day in City B.

Over the last five years, we went through a pandemic where many people moved to remote work. As we’ve come out of that ordeal, lots of organizations have questioned how to structure their workforce moving forward. Some want to have their staff in the office, some want to remain remote, and there are lots of reasons behind each approach. There is evidence that people can be productive remotely, and there is evidence that groups can be productive when they are co-located together. Inside most companies, there are wide-ranging opinions and desires on office work, from both management and workers, and there is no consensus on what works best.

Tech professionals certainly can work remotely. They can also see benefits from being in the same office. The efficiency of their work habits can vary depending on the day and situation, so it’s not easy to decide how remote or how in-person someone should be, even week to week. It might depend on the job and tasks. I enjoy my commute down the stairs each day, but I also find the office invigorating. I like going to the office, and I think I’d go every day if my job required it. I’d get less done for the company each week, but I’d do it.

How do you feel about remote work vs in office work vs hybrid? Do you have mandates? Would you look for another job? These are questions I see many people asking themselves these days as executives start to make new rules about their workforce. I don’t know there’s any good answer, but I am curious what many of you think. Leave a comment in the discussion below.

Steve Jones

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

Note, podcasts are only available for a limited time online.

Posted in Editorial | Tagged , | 4 Comments

Monday Monitor Tips: Finding the Hostname for Queries

I was chatting with a customer recently and they wanted to know which host was sending in queries that were causing problems in real time. This post looks at where you can find the hostname for running queries, which is in two places.

This is part of a series of posts on Redgate Monitor. Click to see the other posts.

The Server Overview

There are two places where you can see the host name. From the server overview, you can go to the current activity, or the new Query Executions tab in preview.

Current Activity

In the server overview, there is a lot of data, but most people scroll down to see the list of queries, such as this list from the ssc-db-n3 instance.

2025-04_0089

There is the database and lots of data, but no hostname. The reason is that these are aggregates. Each of these queries has run many times, possibly from different hosts. This is a historical view.

The better way to look for details on certain problem queries now is to look for current activity. I’ve zoomed in and highlighted this item below.

2025-04_0090

If I click that, I get an sp_who, or sp_whoisActive view of the server, and I can see the logins listed here. That’s helpful.

2025-04_0091

Still no hostname, but if I pick a query from a login, and see the details, I see this view.

2025-04_0092

In the lower left corner, I get the hostname. I’ve zoomed in below.

2025-04_0093

We could add that in the main box, but we’re trying to surface the most important info, and for most of our customers, that isn’t the hostname. However, we have added it in the detail.

If you’re like it in the main box, or would like to choose which fields are there (maybe host and not program?), send us a note to your rep or to sales@red-gate.com.

Query Executions

For some of our servers, we have a new Query Executions tab that uses Extended Events to get some data. The Workload02 system has this enabled. You can see the tab at the top, and then the view of this below.

Query Execution tabs

If I zoom in to the lower right, you can see the hostname as part of the details for query executions, along with other data. As you are examining the details of those queries which have run for over 5 seconds, you can get the metadata about the host, application, and more.

Zoom in to hostname details

Summary

Hostnames are available, you just need to learn where to look. Hence this post. Hopefully this gives you a quick tip on how to find them.

Redgate Monitor is a world class monitoring solution for your database estate. Download a trial today and see how it can help you manage your estate more efficiently.

Posted in Blog | Tagged , , | Comments Off on Monday Monitor Tips: Finding the Hostname for Queries

Staying Employed

The revolution with GenAI has been quite the ride since 2023 and quite a few people have been concerned that their employment status might be in jeopardy. I can certainly understand that, especially in light of the tight budgets, widespread layoffs, and executive views on AI technologies.

There was an article recently talking about AI taking over some jobs with a few tips on how to stay employed. While tech workers weren’t mentioned as being vulnerable, repetitive data-heavy jobs, such as data entry clerks, telemarketers, and cashiers were. That last one is interesting. Lots of companies have tried to use automated checkout stations, but this hasn’t necessarily eliminated cashiers. Maybe there are fewer, but lots of companies in the US have rolled back some of these efforts as fraud, mistakes, and slower checkouts have been an issue.

The data-heavy group might include ETL developers for sure. I suspect this is an area AI is well suited to help build flows, map data, and handle updates more easily. This won’t eliminate the need for an ETL developer, but it might reduce the number needed and certainly reduce the skill level required to code data movement scripts.

There are lots of jobs that might not be vulnerable, including tech people who work on AI, cybersecurity people, and others. I think DBAs aren’t likely to go, though perhaps we will need fewer DBAs and developers over time as AI models become more capable of repeating work.

The tips for navigating this new world aren’t anything different than my advice for years. Improve your skills, both technical and soft. Learn new technologies, but more importantly, show that you add business value with your work. Don’t depend on someone else to tell you what to do. Learn what things are important to your boss and organization and tackle those things early and often. Work to be an effective and efficient worker wherever you can and learn about your business. Those skills and that knowledge make you more valuable than most AI models.

Steve Jones

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

Note, podcasts are only available for a limited time online.

Posted in Editorial | Tagged | Comments Off on Staying Employed

Republish: Upgrading Your OS

Two Fridays in a row. Last week I was in Dallas at a volleyball tournament. Today I’m flying all day, returning from the UK. It’s the Easter holiday there, and some of you might be taking off today as well.

Hopefully it’s a smooth journey for me, but you get to re-read Upgrading Your OS, which is an interesting one for me to look back on. I’m still on W10 on my desktop, but Microsoft is again pushing an upgrade, this time to Windows 11.

I didn’t love the upgrade on my previous laptop, but the new one I got late last year seems OK. Some weird things with W11 have me hesitating to upgrade the desktop, but I’m torn. I certainly don’t want to get away from security updates.

How do you feel? Leave a comment in the editorial.

Posted in Editorial | Tagged | 2 Comments