Daily Coping 2 Jan 2023

Today’s coping tip is to start the new year off with something new – listen, watch, read something completely different.

I started listening to more country music last year. It’s an interesting genre, especially from the guitar standpoint. I’ve learned a few songs and want to work on a few more.

I’m starting today out with a few playlists that are outside of the normal things I listen to. No work (maybe), but I’ll put in the top songs from

  • Kelsea Ballerini
  • Luke Combs
  • Thomas Rhett

It will be an interesting day.

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 2 Jan 2023

How Would Level 5 Self Driving Work?

We had an incredibly cold front move through Denver last week. It was 46F one early afternoon, which dropped to 0F by the evening and down to around –15F overnight. Crazy cold, with snow.

Driving the Tesla was interesting.

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

Driving to Town

I went to the gym the next day, and saw this as I headed out of the neighborhood:

20221222_164301

It’s not a great photo, but what I noticed was that the 43mph had the D above it, for Drive, but not steering wheel for Autopilot. I use it on this road at times when traffic is light. You can somewhat see the road is a bit visible, and you can see some of the yellow through the snow in the middle, but no right line.

The cameras can’t tell where the road is, so they won’t let the car drive. I’m not sure LIDAR or RADAR, or anything would work here.

Here’s another shot in town:

20221222_164902

If you look past the steering wheel, you can see the road looks better. Not great, but better. There are curbs here, so radar/lidar might work. Certainly humans can see them, but the car again doesn’t have the steering wheel showing Autopilot is available.

Update 1:

One other interesting note, a few days later, I was driving this same road, but more snow had fallen against the center curb. In essence, the middle lane was narrower because of snow piled up on the left side (in the image above).

I got repeated “lane departure” warnings, well 2-3 in a 1/2 mile, as the car thought I was crossing the lane boundary on the left. Strange, and disconcerting.

Update 2:

The next day as snow was melting, but the roads were very dirty, the car struggled to find the middle dividing line. I could see it as a human, but it was dim and barely visible. The car swerved a few times as it couldn’t always see where there was a turn lane on either side (L or R).

Can Level 5 Work?

This is a great example, to me, of why Level 5 is not likely to occur for cars. Maybe Level 4 within certain conditions and in well mapped/known locations. Or perhaps with sensors in roads that cars read. However, a little snow (this was 2-3 inches) has blinded the car.

Humans drive on these roads all the time in snow. To be fair, many drive poorly, and often they don’t know where the lines are. However, we negotiate. We slide our car slightly left or right when there is other traffic. We aren’t perfectly in the lanes, and depending on the plows, we might end up “losing” a lane and just working with one path that isn’t really in either lane.

Can computing learn to do this? Maybe, but it’s feels like an even more complex problem, especially when you now are asking the computer to react to how other drivers are moving on the road. Negotiating a route with them. Can a computer see another driver wave them on or ask them to stop?

Tesla isn’t Level 5 or anywhere close. It’s Level 2, and perhaps Level 3 with the beta self-driving software (which I haven’t seen). I don’t know that I think anyone is closer, though I’ve heard the Google/Waymo taxis in Phoenix are pretty good. I’d like to try one and see, but those aren’t Level 5.

I’m not sure I would trust Level 5 if someone claimed it, at least not unless every other vehicle was also a L5 controlled car.

I do enjoy Autopilot and it was worked well for me. The FSD version was OK, but not enough better for me to subscribe to it. I look forward to cars becoming better and safer, but I’m not expecting to be able to go to sleep in the car and have it take me to my destination anywhere, anytime. I just don’t think L5 is anywhere within reach.

Posted in Blog | Tagged , | 1 Comment

Looking Back at 2022

This is the last workday of 2022. Next week starts a new year, and as I’ve often done, I wanted to look back at the year. This time I decided to look back month by month, at some of the headlines and memorable data-related topics. I’m tackling things month-by-month.

In January there was a set of “tech experts” who shared their thoughts on the best database management systems. This one is worth a read for the humor involved. I wouldn’t really consider many of these to be DBMSes. I thought about including this one as an April 1 joke, but it was a real story. I get asked for my opinion at times by writers researching a topic they don’t understand. I hope I don’t come across like a few of these people.

February was another sad data breach story. In this case, from the state of Washington where many tech people live and have startups. It wasn’t clear initially what happened, but later articles noted this was from a stolen device. To me, this was a great reminder why dev machines (and databases) should NOT have PII. Mask/obfuscate/anonymize that data please. Or at least delete my name from your dev systems.

March had another humorous story (to me): Oracle is going to lure people away from AWS and SAP with their new offering. I could believe the latter, but not the former. Oracle hasn’t ever been good about pricing and it seems more people are leaving Oracle than coming to it.

April is the month of April Fools, but this isn’t a joke. Another data breach, again from a dev system. This one from Fox News, which included information of not only employees, but guests and celebrities. The claim that this was a dev system and not production doesn’t matter if the data is real. Please people, keep prod PII out of dev.

May had a funny post from Hacker News. Someone put their whole life in a database. The comment that caught my eye on HackerNews: “Men will literally devote hundreds of hours to building a bespoke database tracking every moment of their lives instead of going to therapy.”

I worked a lot on my weight and diet in 2022. June had me finding a public database to help me choose better food. A public database on processed foods. Great idea, but everyone has an agenda. I hope this has some crowdsourcing and reasoning and isn’t just one person’s opinion.

In July, another data breach. This time in China with information for 1 billion people. Wow. I dislike large databases for this reason. It’s also a good reminder why you ought to remove information from your databases over time, at least the PII part. Again, delete my name, if nothing else.

There are so many types of database platforms. Have you heard of a vector database? Apparently, it’s for managing vector embeddings, whatever those are. An August article on the strange growth of the database market.

September started this crazy AI art craze. There was a call to remove living artists from the database of works that an AI uses. Makes sense to me. I think artists deserve support and while I like AI doing new things, maybe wait until the artist isn’t producing work.

October showed a good reason why we need ongoing patches or open-sourcing of code for retired systems. There was a 22-year-old vulnerability reported in SQLite.

In November, what other news could there be than Lego Steve? It was a tiring week.

December is just ending, but I’m ending on a reason why databases without auditing are a problem. Men behaving badly in this one. Gathering public information (or even semi-public) at scale can be problematic, and the information gets abused. Better controls, but also more auditing and triggering of some actions to prevent this (and other) sort of abuse.

Let me know if you remember these events, or perhaps if there’s a favorite memory of the 2022 data world that you wish I’d included.

Steve Jones

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

Posted in Editorial | Tagged | Comments Off on Looking Back at 2022

Goal Progress for Dec 2022

I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022.

December is usually quiet, though this year I spent the first 12 days of the month out of town. That meant that I wasn’t getting much done, either at work, in my life, or on my goals. I did a little reading, but mostly it was work and holiday.

I’m going to do the grade for the month and then look at how I feel about the year.

Grades:

  • December – B+
  • 2022 overall –  B

I made some good progress in December and managed to get a bunch done on my report, finished a book, and started on my demos again. Not amazing, but really good.

For the year, I think I’ll give myself a B as I managed to read all the books, do some demo work, and get my Power BI skills growing. I also did a bunch of community stuff, though not quite as I saw it happening at the beginning of the year. Still, a good year overall.

Here are the goals and updates for the month.

Work

Mostly reading this month, as I was traveling. I did reset my environment for a DevOps demo and got projects set up for SQL Server and PostgreSQL in the same repo.

Personal

Sent my dashboard to a few others to use. Not the entire team, but I got 4/10 using it to see what they think, which is a good start. With my assistant, we’re at 50%

  • Link Google Sheets to Power BI – 100%
  • Create Report – 75%
  • Create Dashboard – 60% – Added a main page
  • Get people using it – 50%
  • Coaching Certification – 100%

Community

  • Support the Colorado groups by speaking twice and helping getting two events set up
    – 66%
    • CO Springs event set up and executed
    • Denver SQL Server SQL Saturday executed
  • Speak at 3 other community events (was user groups) outside of Colorado – 100%
    • Spoke at DBA Fundamentals group
    • Spoke at Toronto SSUG
    • Spoke at SQL Saturdays in Jacksonville, New Jersey, LA, Denver
      • Boston, Toronto in Oct
  • Support SQL Saturdays – Help get 10 events run in 2022 – 100%
    • We have had 15 run this year and 3 more scheduled
    • In Nov, we had 5 events complete – Sao Paulo, Oregon, Bangladesh
    • Seven events scheduled for 2023
  • Volunteer 4 days with Habitat – 0 days
    • Not happy about this still. I had hoped to go Sept 15, but they cancelled the build that day. Need to find another day, but it’s hard. They aren’t doing every Wed/Thur/fri, and travel is getting in the way.
Posted in Blog | Tagged , , | Comments Off on Goal Progress for Dec 2022