Author: way0utwest

  • Daily Coping 8 Aug 2022

    I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag.

    Today’s tip is to set an intention to be kind to others and yourself this week.

    This week I’m traveling to Redmond and Los Angeles. I will encounter service people in restaurants, drivers for taxis, airport workers, and many attendees at events. My wife is also going to LA with me to enjoy a weekend together after SQL Saturday Los Angeles 2022.

    I am making a conscious effort today to be kind to others, let small things go, be empathetic and understanding. I’m also going to remember that this will be extra time and stress out of my week and I need to ensure I eat well, find some time to exercise, and relax when I can.

  • Driving Costs With a Tesla Compared to Gas

    This is part of a series that covers my experience with a Tesla Model Y.

    I wrote recently about the costs for me to charge at a Supercharger. The USD$0.43 was higher than I expected, but lower than the USD$0.58 I’ve seen some CA people post about.

    With the intricate linkages of the World Wide Web, I’ve seen a few articles lately about charging. First, there was a debunking of a meme at Jalopnik, which I thought was crazy. Especially since I own a horse trailer. Then there was a user posting at Reddit that ended up poorly shared on Autoevolution. For the record, I find that site have poor journalism standards.

    I also caught a post on Facebook about new public electric chargers coming to Colorado and was amused by all the comments about the grid failing and not being able to handle things and how expensive and poor for the environment electric cars are.

    A lot of hype and silliness, or FUD, from lots of non electric positive people. However, I wanted to check on the real costs for me. So I got some of my data.

    Comparing Costs

    I still have a 2012 BMW X5. I was thinking to replace it with something similar when we got the Tesla. So purchase costs are out for me, but I did decide to compare the cost of operating that car with the Tesla. I also decided to add a Prius in. Now, our old Prius would get around 47-48 in the summer, 43-44 in the winter. This car was rated at 50mpg. A newer one, like the Prime, is rated at 54, so I’ll use these values for my MPG:

    • BMW – 22
    • Prius 50

    I also compared the cost of home charging v Supercharging. My experience recently is these costs:

    • Home – $0.14
    • Supercharging $0.43

    I have solar, but since I just use power, if I spend it charging the car, I pull more from the grid, so I’ll leave that cost the same.

    Trips

    I run Teslamate, which logs all my drives. I can see the distances and power usage for each trip. As you see below, there is a lot of data.

    2022-07-27 10_25_50-Drives - Grafana — Mozilla Firefox

    I grabbed a sampling of trips, long and short, around town and into the mountains. The gas cars do worse in the mountains, as does the Tesla, but rather than try to make things complex, I left the same MPG for the gas cars.

    Methodology

    • For a particular trip, I get the mileage and kWh used. I can multiple kWh by cost and get a simple cost for electricity in two ways: home and Supercharging. This isn’t my actual cost, but hypothetical if all my charging were in one of these two places. As an example, for a 20.2mi trip, I get:
    • home cost –  $0.56
    • Supercharger cost – $1.72

    For the gas cars, I divide the miles by mpg. This gives me gallons used. For that 20mi trip is just under a gallon for the BMW and under half a gallon for the Prius. I then multply by the gas cost. I set that at $4.30 for now. It’s been higher lately, but I paid that last week on a trip to the airport (I took the BMW).

    I put a set of 11 random trips in a spreadsheet and compared things. This is what I see:

    2022-07-27 10_30_21-Book1 - Excel

    For my 2o mile trip, I see these costs:

    • Home: $0.56
    • Supercharging: $1.72
    • BMW: $3.95
    • Prius: $1.74

    For a longer trip in the mountains, 55mi, I see:

      • Home: $2.03
      • Supercharging: $6.24
      • BMW: $10.81
      • Prius: $4.76

    The aggregates for 418.8 miles (this sample) are:

    • Home: $15.76
    • Supercharging: $48.42
    • BMW: $81.86
    • Prius: $36.02

    Clearly the Tesla is a lot cheaper if I charge at home. My power costs are mostly fixed, though the Supercharger can be cheaper than $0.43. It could be more expensive, but I haven’t seen that. Gas certainly goes up and down and even at $4, home charging is cheapest.

    The Prius looks good in a bunch of places compared to Supercharging. I had 4 of those 55mi trips in the mountains, all on Supercharger charging, but I also know the Prius would not be getting 50mpg there. Probably more in the 25-ish range. Mountains are steep.

    My Experiences

    I’ve owned lots of cars. My experiences in the last year, in looking at data and comparing to the Prius, BMW, RAM 3500, and other cars, is that the Tesla is a lot less expensive to operate. My back of the napkin thoughts before this were the Tesla is about 1/2 of the Prius cost and 20-25% of the BMW to operate.

    You can make all sorts of comparisons on ROI and costs, and you should. For your situation. For me, given my life and choices, this was a great purchase. I’d have spent $45-50k anyway on a car, so the purchase wasn’t something I calculated in. I also carry 5 adults at times and that wasn’t very comfortable in the Prius. The BMW worked fine, as does the Tesla.

    Charging isn’t simple, and while I got a wall charger + installation for US$760, I would not be surprised if a lot of people paid closer to $1500. However, it’s not a crazy cost, and it’s essentially adding another circuit for your clothes dryer. A good portion of us can do this, and then we have a “full tank of fuel” every morning. That alone is a very neat experience.

    I think Tesla is great. If we needed another car, we’d look at Polestar, Hyundai, Rivian, and a few others. I’m sold on them as an every day car that is relatively cheap to operate. We’ll always have the diesel pickup for towing and trips if we need it, but having owned different types of cars, the electric paradigm makes a lot of sense.

    And if we really wanted a car for a trip and worried about charging, like through Montana, we’d just rent a car. We’ve done that in the past to save wear and tear, and it’s hard enough to find fuel in Montana and Wyoming at times. A rental would be an easy choice, so range anxiety isn’t a problem. If I have it, I get rid of it for that trip. Not for the rest of my life.

  • What Do We Want to See in SQL Server?

    I like the feedback system that Microsoft built for SQL Server. This used to be the Connect system, but all the bug reports and feature requests are now at feedback.azure.com. That’s the place where you can send notes to Microsoft or vote on those that others have submitted.

    In case you are wondering if this makes a difference, it does. Years ago, there pushback for Service Packs from Microsoft, and after a lot of lobbying from myself and others, and a number of votes, Microsoft released more Service Packs for a few versions. They’ve also made a few other changes in the product, or fixed bugs when enough people vote. Not always, but it does happen at times.

    When this system was first released, I wondered if Microsoft would email a digest or some list of items that they had triaged of how the various items were rated. I could see this as a way customers might learn what others think is important, as well as what Microsoft sees as feasible. Maybe where would be some repeat voting that could influence the products’ direction.

    Recently I saw Brent Ozar posted the top 10 items by votes with a few comments. Of the items on this list, I found some interesting ones. I know STRING_SPLIT gets an ordinal in Azure and SQL Server 2022, so that’s one item that MS responded to. I see a few SSMS ones, which are always interesting to me. I’d hope that MS would include a dark theme and the (maybe) the debugger back in as many people request those features. I’m not sold on the debugger, and it wasn’t always stable for me, so I wouldn’t use it, but lots of people like the idea of a debugger. Maybe if it were limited to the dev edition?

    Microsoft looks at the feedback, but the feedback isn’t a vote in their mind. It’s a metric that helps them triage and decides when things are important enough to work on, assuming the effort isn’t extremely high. Working in a software company gives me a better appreciation for the decisions made on which features to include or not, especially given the long-term support effort for any features.

    It can feel hopeless when you vote for something and Microsoft doesn’t build it, but when enough people, especially big customers, want something, it gets built. If you look through the top items, a few have been added to SQL Server 2022. Personally, I want a FOR CSV along with a BULK EXPORT command. I appreciate some difficulties here and possible permission/security issues, but this would be very handy.

    What changes do you want today? Is the dark theme or the debugger at the top of your list or is there something else?

    Steve Jones

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

  • Daily Coping 5 Aug 2022

    I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag.

    Today’s tip is to be a realistic optimist. Focus on what could go right.

    I find a lot of people think ahead and get concerned about the downsides. What could go wrong? They find reasons to not do something.

    Of course, there are others that a few that leap first and worry about issues later.

    I tend to be in the first group, though I’ve learned to recognize when I’m not being optimistic, when I am letting fear drive me. That has helped me to have confidence in most things going right.

    Which they do. Most of the time things work out fairly well.

    I’m trying to do this with SQL Saturday. I’m hopeful for the future and events, and understanding when people are hesitant. However, I am confident that more organizers will run events and more people will want to come to live in-person events.

    I’m being optimistic, knowing that this doesn’t apply to everyone and I have empathy for the reality.