Look Beyond What You See

One of the sales managers at Redgate Software posted an origin story about how he came to work at Redgate Software. It’s an interesting story, and while I don’t work in sales or have the same origin story, I don’t know that I could have seen the place I’m in now early in my career.

When I saw the video, it made me think of this movie scene, where Rafiki asks us to look beyond what we see. I think this is a hard thing for many of us, especially when many of us have been leaning on our skills in the past. What we know and what we are good at doing has led us to this place. Picking a new direction, or thinking in a new way might be hard.

For lots of us, we might be concerned about the cloud, and what we should learn or where this might lead us.  Azure or AWS? Some might be concerned about moving into management. Will I be good at it? Will it be a better career for me? Others can wonder about specific technologies. Power BI or Tableau?

I wouldn’t recommend a specific thing for anyone without knowing more about their situation, but I do advise people to be open to opportunities, investigate and ask questions, and embrace possibilities. Look for what might be slightly out of focus or uncomfortable for you. Look beyond what you see and consider what you haven’t seen before.

My origin story is getting an electrical engineering internship. Finding that the group needed help with Lotus 1-2-3 macros. Realizing I liked working with computers more than walking around a power plant and working with electricians to follow designs. I then realized that I didn’t love programming or network support, but I saw an opportunity in 1991 to work with SQL Server, and I took it. I looked far beyond what I had thought about as a teenager, as a college student, and even as a young person in my career. I embraced an opportunity to write an article and that led me to SQL Server Central and now Redgate Software.

Think about the directions you could take in any situation and open your eyes to the possibilities. You might find an opportunity that changes your life.

Steve Jones

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

Posted in Editorial | Tagged | Comments Off on Look Beyond What You See

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.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 8 Aug 2022

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.

Posted in Blog | Tagged , | 2 Comments

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.

Posted in Editorial | Tagged , | 1 Comment