No Autopilot in the Tesla

Recently I was driving home and I couldn’t engage Autopilot. I kept seeing the availability icon come and go, and found this interesting, but also a sign of why Level 4 or 5 is likely hard to solve in a general way.

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

Denver Sun

When I first moved to Denver, I was driving down I-25 early one morning. There was a stretch that turned East and was blinded. It felt like the sun was directly in front of me on the horizon. This is something that I’ve gotten used to a few times a year, as the sun seems to be at a lower angle than I see anywhere else in the world.

My Tesla Model Y, Long Range (MYLR) apparently had the same problem this week. I was out early to town and ended up coming home around 8am. Driving East, the sun was low and seemed to be coming directly into the car. Fortunately it was slightly to the right, so I could see straight ahead. This is a section of road that I often engage autopilot as it’s got some ups and downs, is fairly quiet with a median, and I like letting the car control the drive.

However, when I engaged Autopilot (AP) I got the alert that it wasn’t available. I glanced down and saw the icon, which indicates AP is available, so I assumed maybe I’d done it at a place where there weren’t lines. The icon disappears in intersections or other places where the car doesn’t see lines immediately.

I tried again and the same thing happened. As I glanced down a few times, I’d see the icon come and then go. I looked out and realized that I could barely see the lines in the center of the road because of the glare.

This continued for a few minutes until the road turned left further and a large hill shaded the road. I engaged AP and it handled the rest of the drive out to the road that turns toward my house. Once engaged, it seemed to do well, even on a few hills where the glare was strong, though not as strong as it was leaving town.

Radar and Lidar

There are a number of situations and places where I think that lack of radar or lidar would help. This isn’t one of them. Unless radar is painting the painted lines in the middle of the road, it wouldn’t solve this problem.

Conclusion

In a city, or even suburb, where the roads are well mapped, this might not be a problem. In a neighborhood, or place where cars might park on the street, then perhaps radar could help, but vision is vision, and it’s not something that a computer can necessarily do better. Humans make mistakes with glare and blinding light, and cars that depend on vision can do the same thing.

Actually, I think the recognition of visual artifacts ( shadows, glare, etc.) is slower and more difficult for computers than humans. Humans will also make mistakes, but like many, I think I have less tolerance for computers making the same mistakes. Not sure that’s rational, but I do feel that way.

This is a reason that I think L4 or L5 isn’t easy, or likely, outside of highly mapped and geo-fenced areas.

Posted in Blog | Tagged , | Comments Off on No Autopilot in the Tesla

Assembling Your Own Toolbox

Last month Brent Ozar posted that September was community tools month. He had a number of posts that highlighted tools and a number of other people (Francesco, Erik, VladDBA ) did as well. I didn’t do any blogging because, well, it was a busy month for me. I was gone from home for 21 days, so a bit harried in life.

As a part of this effort, I saw Ken Fisher write about being a Script Magpie, which is an interesting analogy. A magpie is a bird that collects various shiny objects. Ken collects scripts in the same way. Things that catch his eye are added to his repo of scripts that he keeps handy.

I used to do something similar. I didn’t have a repo back then, though I should have. However, all VCSes in the past lacked some of the ubiquity of Git. Instead I had a folder that I kept synched on various flash drives that I carried from job to job. I’ve also usually had a share inside companies where a team of developers or DBAs could share SQL scripts.

I’d hope that most technology professionals would share scripts, especially when they can be tokenized or added as SQL Prompt snippets. Reusing work is a big part of working with computers and why many people have embraced tools and utilities that they didn’t write themselves. I certainly think having a toolbox is important, especially tools that integrate well with an existing environment.

I don’t think it’s worth rewriting many tools inside a company. I work for a software vendor, and I’ve seen the effort put into building tools. Both free and paid tools can save you a lot of time and effort inside your job, not the least of which is maintaining the tools over time as versions and editions change.

What are the contents of your toolbox? Which things are those that you’d bring to a new position if you moved organizations or groups? Let us know today.

Steve Jones

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

Posted in Editorial | Tagged , | Comments Off on Assembling Your Own Toolbox

Daily Coping 7 Oct 2022

Today’s coping tip is to be willing to share how you feel and ask for help when needed.

This has been something that I never did well. My parents and others I respected as a child taught me to suck it up, work through issues, be strong and independent. All good qualities, but as with anything, you can take this too far. I think far too many people of my age and older did a poor job of sharing their feelings with others. We also struggle unnecessarily by not asking for help.

I’ve learned that sharing feelings isn’t bad. I’m not less capable, nor am I less of a professional, coach, husband, father, etc. I can still be accountable for whatever and not like it or not feel good about something. I can also ask for help when needed.

I’m getting better about providing feedback to others in my life without griping or complaining, at least, I think I am. Recently I’ve pinged a few people to let them know that I do need help prepping for some work things because I’m busy, and because I need help in ensuring I have my schedule correct. With all the things I do, it’s easy to lose track of sessions, deadlines, and more.

The pandemic has taught me to better let people know how I’m doing, and if I’m overwhelmed, ask for help.

I started to add a daily coping tip to the SQL Server Central 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.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 7 Oct 2022

T-SQL Tuesday #155 –The Dynamic Code Invitation

tsqltuesdayApologies for the late invitation. A minor snafu has me hosting again.

This is the monthly blog party where someone hosts and you all write a response. I’d like to think this is one where lots of you have a story or a situation that worked out. Write a post on 11 Oct and post a comment here.

The Invitation

I saw a post recently where someone noted they used Excel to help build dynamic SQL for their job. I thought that was a) creative, and b) similar to something I’ve done. In fact, that will be my post for this month.

However, while many of the experts decry dynamic SQL as a poor way of solving problems, it is not going away. In fact, it works really well for many situations and problems, albeit not necessarily a high volumes of data. There also are security concerns.

My invitation this month is to write about producing SQL dynamically in some way. Let us know about any of these things:

  • a problem you solved
  • a creative use of technology to build SQL
  • security concerns
  • a place where dynamic SQL failed you
  • a way to convert dynamic SQL to something cleaner
  • anything else that relates to code producing code

The Rules

Only a few rules.

  • publish on 11 Oct 2022 sometime.
  • use the logo above and link back to this post
  • leave a comment or trackback/pingback here
  • Use the #tsql2sday hashtag to tag your post on Twitter, LinkedIn, etc.
  • Encourage others to blog

That’s it. Have fun and I look forward to reading your responses.

If you want to host, ping me on twitter (@way0utwest) or LinkedIn or email or anything really.

Posted in Blog | Tagged , | 29 Comments