Author: way0utwest

  • More Linux than Windows

    Not for me. I definitely have more Windows running than Linux. Well, at least if you count minutes. If we’re counting instances of kernels, there might be times I have more running with Linux kernels in containers. However, on most days I have 1 or 2 Linux systems running and 3-4 Windows ones.
    That’s not the case in Azure, where the majority of instances are on Linux, not Windows. Microsoft announced this recently, noting that the use of Linux is growing for them. If you follow their work in the development area, this isn’t surprising. They are doing more and more OSS integration with their products or with other work. We have VS Code and Azure Data Studio, as well as .NET Core, running on Linux.
    We’ve had PowerShell on the Windows platform for over a decade. In that time, it has improved and grown, and become a default way for many people to manage their systems at scale, or certainly, in a consistent way. I’ve been surprised with how pervasive PowerShell has become. That’s why I’ve been surprised in the last year at //build/ and other conferences when I see Microsoft employees promoting bash as the new thing.
    I have nothing against bash, though I was more a korn shell person in University. I do like working in it at times, and I find myself doing that more and more. What I don’t like is a push away from PowerShell, especially as I’ve just started to get comfortable with -eq and -gt. I hope that as Microsoft moves towards more Linux versions of tools that they continue to keep PoSh as a first class citizen, on all platforms.
    Linux lost the desktop war. I’m pretty sure that’s the case, as I haven’t seen a Linux laptop or desktop in years. I see lots of MacOS, but more Windows, especially with the amazing hardware advances manufacturers have made in the last 4 years with the 2-in-1 format. However, I start to wonder if Linux will win the server war, or at least, become a much larger percentage of the back ends in the next ten years. I think it might, handling .NET and SQL Server loads in many cases.
    Steve Jones
  • Summer Break

    This feels like a strange day in the summer, with a holiday yesterday (Fourth of July) and the weekend starting tonight. This is similar to the Friday after the US Thanksgiving holiday, which is usually a day when very little gets accomplished in most offices. I’ll be a little more productive at home than I would be in an office, but I’ll still have a bit of a holiday lull from yesterday and a weekend coming up. Actually, maybe I’ll get plenty done since I’m sure my body is tired after working on driveway maintenance and (hopefully) rebuilding a trailer hub. (If you haven’t guessed, I’m writing this before the break)

    It’s the start of the second half of the year and a time when many people take holidays. Schools are usually on break, so families often look to travel somewhere. Some of us might take a staycation, catching up on projects at home. I know I’ll be doing that a bit this summer as a busy first half of the year has me way behind on a number of maintenance items and projects.

    We all need a break, so this week I’m asking you what things you might do this summer with friends and family that provide a welcome distraction from work. I’m assuming you’ll have some time off, even if it’s just a weekend, so share a fun event or activity you’re looking forward to enjoying.

    With my kids getting older, we rarely get together. Even on some of the smaller holidays, my son won’t come home from university. If we do get together, it’s often just a meal, though we did have a fun afternoon of bocce after my daughter’s graduation from high school. Maybe we’ll get out this weekend and do that again.

    My wife, kids, and I love music. Some of us play instruments, some of us sing, but we enjoy hearing music all the time. We also enjoy movies, and last year my family when to see Bohemian Rhapsody, which was amazing. The music is great and I recommend this entertaining and enjoyable film. We also saw Rocketman recently, a good, but sad film for me to watch. Perhaps we’ll all go see Yesterday this weekend since we enjoy the music of The Beatles. We’ve been Marvel fans, so I’m sure Spider-Man is on our agenda. This particular reboot is my favorite so far, so that’s a possibility as well. We might have a bit of a debate on which to go see or just go see both.

    I’ve gotten away from most sporting events and live concerts at event centers due to the time commitments (and cost). These days my wife and I may go see a local musician or a comedy act, but more often than not a movie (at home or out) is a way we escape from some of the pressures of life.

    Hopefully you have something you’re looking forward to, so let us know today how you’ll brighten up your summer months.

    Steve Jones

    Listen to the podcast at Libsyn

  • Taxing Travels

    It was a long weekend of travel for me not too long ago, starting at 4:30am on Friday and ending at 7:30pm Sunday night. This was for SQL Saturday #884 in Pensacola, an event I’ve attended 4 or 5 times, a few with my daughter. It’s always enjoyable, and this year was no different.

    However, the travel was surprisingly hard. I need to write a bit more about this, but I was surprised by both the issues that cropped up and how well the flights actually went. I’ll also mention that I had the 3 of nicest flight attendants I’ve ever interacted with on the three different flights. Thanks, @United staff.

    Flight 1

    This started when I hope at 430am Friday. I showered, and checked my phone, seeing a message that my flight was delayed. That’s pretty cool that two hours before flight time they can let me know of issues. I was thinking since this was such an early flight that the plane would be in Denver overnight, but I wasn’t thinking. There are early flights East of here and they can fly to arrive at Denver in time.

    Or not. In this case, weather in the Chicago region delayed the plane, which is why I try to avoid Chicago. In a big deal, but about an hour delay. With a 2 hour layover, I wasn’t too concerned, and headed to the airport. I arrived, got a cup of coffee and went through email/Slack at the gate. Travel doesn’t necessarily stop me from needing to deal with other work, so I made use of the time.

    Our plane arrived, people got off, I was ready to get on. Unfortunately, we were missing a flight attendant. One would think that scheduling staff is easy. It’s not, especially across time zones, locations, and potential limits on working hours. I don’t know if an employee had an issue in Denver or was on another flight or what. In any case, I know people that are in the airline industry and on call. They try to get  to the airport quickly when called, but things happened. In this case, we added about 15 minutes to our delay over just over an hour.

    Flight 2

    One of the really neat things in the United mobile app is that I get information on gates and times, updated during the flight. Almost all United planes have wifi for entertainment, and you can purchase Internet access, but you get access to United data for free, like where your plane is flying.  You can look at a map that gives you an idea of how close you are.

    In this case, I was watching because we kept banking slightly. The generic flight map looks like this:

    den-ord

    Mine looked more like this (I should have taken a screenshot):

    p2-us-map

    To avoid weather, we kept turning. We actually came into Chicago from the North, after circling around the East. I got a side view out of the plane of the downtown area as we came in.

    20190628_101503

    We were late, and I had about 35 minutes before the other flight left, which means 25 minutes to get there. One thing I’ve learned is that the major airports have gate maps in the airline magazine. In this case I was going from one end of C concourse in O’Hare to the other end of F concourse. Not an easy journey. I jogged, and got there with about 10 minutes to spare. If I hadn’t been able to jog, life would have been rough.

    Normally I get a text on delays, but I think the stack of flights was delaying messaging because as I walked up to the gate, I could see the delay message. As I talked to an agent, my phone vibrated with the delay alert. This is one place I think United could do a better job of data sharing, but in any case, this was another scheduling issue.

    My plane was at the gate, workers were outside, so no lightning delays. However, our flight attendants and a pilot were in Milwaukee, which isn’t that far a drive from Chicago. They couldn’t take off because of weather, so we were delayed, even as other planes were coming and going.

    About 2 hours here, but again, a great flight attendant that was very pleasant when we did get going. I took the time to eat some lunch and do a little writing. I’d started some things on the plane that I finished on the ground.

    Flight 3

    After the event, I was at the airport a little early. I sat at a restaurant, writing up some notes from the weekend for changing a presentation as well as reporting for Redgate. The plane arrived on time and we started boarding. I fly enough to be part of the pre-boarding group, so after those with disabilities and families, I scanned my pass and started down the jetway. There I found a line of 6 or 7 people, with a few already on the plane. Since someone had gone with a wheelchair first, I assumed that this was the delay.

    Then I heard someone on the plane tell us to drop people from coming down the jetway. A few minutes later an agent came down and had us all walk back up the jetway and back into the terminal.

    Apparently there was a ground stop in Denver that the pilot had heard, so I can forgive the app not updating me. A 45 minute delay, under mostly sunny skies in Pensacola, though clouds in the distance. This was more concerning, and a little stressful. No work getting done now as I was worn out and annoyed.

    Almost an hour later, we start boarding and get on. The pilot will try to hurry and we take off. I have a couple drinks, thinking this is the end of a long weekend. It’s not.

    As we get close to Denver, we get good news and bad news.

    Good news: Denver is landing planes, albeit slowly.

    Bad news: we need to circle a bit and have an hour of fuel. If we don’t get landing clearance in an hour, we’ll go land somewhere else. Fortunately we have a little plane, so lots of choices.

    30 minutes later we get clearance and land. About two hours later than planned, but still, I’m home.

    Lots of Challenges

    I wrote this because I was thinking about all the challenges in flight operations and trying to coordinate many moving parts. It’s quite a logistical challenge, and while computers can help, I’m sure many humans need to be involved in some decisions along the way.

    These were really minor hassles in my life, and I’m not complaining. More, I’m in awe of the amount of data that must be managed and used to make decisions and direct humans. I didn’t check bags, but I have, and I’m always amazed how well my bags get from point A to point B, especially when I’m running to make connections.

    Nothing went as planned in my flights, but it all worked out well for me. Not for some others, but weather can be a big factor in traveling. I think the main thing I’ve learned is avoid Chicago and Chicago based planes whenever I can.

  • Fines for Data Access

    Most of us know about the principle of least privilege. After I wrote about network segmentation recently, I’d hope that most of us know that limiting access to production data from all workstations might also be a good idea. Many of us also know that unusual patterns of access might indicate an issue. I wonder how many of us have a system in place to look for unusual access, especially this is something that might help us prevent, or at least detect, potential hacking activities.

    I wonder if we’ll get to the point where we need to do more and not only implement better auditing of system, but also data access. Will we need to actually monitor what data is accessed and ensure there is a valid need to do so? That was probably needed in this case, where various employees accessed a woman’s DMV data for who knows what purposes. This is a creepy story, and I’d hope that it’s the rare man that actually does this in any company, for any kind of data.

    As a general recommendation: please don’t spy on someone that you want to date. It’s very much an invasion of privacy and no way to develop a relationship with anyone.

    There were logs of access in this case, which isn’t the case in some states, but there should be more logging of access. The default “black box” trace in SQL Server doesn’t give us much information, though if you have a monitoring system in place, you likely do get more data. The logs of who and what are important, and they are something I’d like to see built into SQL Server by default, an easy way to log activity, with some archival/management of the data.

    Too many of us don’t log anything, and maybe it’s not important for some applications, but in the cases where sensitive data is stored, I think logging ought to be required, and I’m hoping GDPR 2.0 or other laws mandate this, perhaps with some retention of a year. I know I’d certainly like to see this built into more applications.

    The way we handle personal information has been poor for most of the digital age, and I would like to see that changed in a number of ways. I think requiring compliance against a standard might be the best way, though without specifying an implementation. This way we accept the responsibility of safeguarding data that we already should feel.

    Steve Jones

    Listen to the podcast at Libsyn