The 2022 Preview

This was a strange week for me. Traveling in Brussels with my wife and prepping for a few presentations. Then Techorama, an even more 2019-era conference in Belgium where I spoke around a few customer calls sprinkled in during the week. I have a new SQL Saturday I was trying to get scheduled, while coordinating with my doctor for a surgery Friday, and keeping up with some travel plans for the next month.

In the middle of all that, Microsoft Build took place this week. Needless to say I didn’t see any presentations from the event, but I did see quite a few blog posts and entries this week from various MVPs and others. I took a few minutes to watch Data Exposed, and I read a few posts. I liked the thoughts from Paul Andrew on the Intelligent Data Platform. He is more of a BI person, and I think a lot of the evolution of the platform is moving to add more BI and get more intelligence from the database for customers.

I’ve been playing with the CTP lightly for a few months. Many of the MVPs have as well, and while most things work the same, there are some new things that might be useful in your workload. You can get the CTP of SQL Server 2022 at https://aka.ms/getsqlserver2022, and see what’s changed, test your current apps, and in general get excited about the future of SQL Server.

If you want some ideas and demos to follow around, check out Bob Ward’s demos at https://aka.ms/bobsqldemos. He’s put his various scripts and notebooks for the platform, where you can reproduce and examine some of the features. Bob has been showing off some of these things at various conferences for awhile, and now you can get his code to do some testing. Aaron Bertrand also has a number of posts on SQL 2022.

As always, if you find issues, send in feedback. MS does read this stuff, and while they don’t always agree with you or I, they do consider things. The more you put the reason you want a change in business terms, the better off things are. Rather than saying “an empty CATCH clause hides an error”, you might say that “the empty catch clause was unexpected and caused clients to resubmit a form 22 times before customer service could track down a bug.” Be specific and show a relation to a tangible business problem for all your errors.
In many ways SQL Server is a very mature product for me. The core engine meets most of the needs I have for SQL Server Central as well as those of many of my customers. However, there are lots of organizations that might benefit from one or more of these features. Whether on premises or in the cloud, we want the platform to grow and improve.

Plus, it can be exciting to reproduce one of Bob’s demos and learn something. As we move towards a new version of SQL Server, take a little time to get excited about technology and see what changes are coming in SQL Server and the Data Platform.

Steve Jones

Posted in Editorial | Tagged , | Comments Off on The 2022 Preview

Techorama 2022 Slides

I had a great time at Techorama. I’ll do a writeup on the event, but for now, here are my slides.

There’s no code, but if you have questions, please feel free to reach out to me.

Posted in Blog | Tagged , | Comments Off on Techorama 2022 Slides

Level 5 Driving and Tesla FSD

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

I saw this bet appear on Twitter between John Carmack and Jeff Atwood:

2022-05-03 12_39_40-(6) John Carmack on Twitter_ _I have another long-term bet_ I bet @codinghorror

It’s quite a statement, and it leaves just over 7 years for this to come true. I do wonder if they’ve defined this well, as I don’t know if many people really think about what Level 5 means.

I ran across an article recently from someone who’s owned a model 3, titled: Tesla Full Self Driving Beta: How Close To Level 5 Autonomy? As I read it, I felt that a lot of the items it listed were things I see wrong with either the AutoPilot I have, or things I’ve seen from other users that are using the Full Self Driving (FSD). There is also an SAE infographic.

Disclosure: I haven’t tried the FSD, but I am interested in subscribing for a month at some point and seeing what I think.

What is Level 5?

Level 5 driving is full automation, with no need for a human. To me, this means I could put my infant in the car and it would make it to a hospital without me being in the car in any weather. I’m not sure how many people would want to go through that test, but that’s what it says.

It also says “They will be free from geofencing”, which would mean go anywhere. In terms of the bet above, I am guessing this means they can go anywhere in the city on any day of the year?

My Thoughts

I do think the self-driving is more possible in cities, where the mapping and understanding of the structures and roads is well known. Cities are generally well marked with regards to traffic indicators, lines, lights, etc., but not always.

I have always believed that self-driving needs to happen in a well-mapped, well drawn city. I don’t know that New York fits the bill. London has the congestion zone, which may or may not work, but really, I think a city like Chicago with relatively wide lanes, things well marked, etc., is a good choice. I wouldn’t pick Chicago because of the potholes and repairs in parts of the city, but maybe somewhere like Singapore or Melbourne would work well.

The key here is well marked and known. There will be weather, like snow or heavy rain, that will cause problems with vision based systems. It can also cause issues with radar as well. It already does with human drivers, but we are used to that. I don’t know we’d have the same tolerance for mistakes and accidents from self-driving cars.

I think it’s much more likely we get Level 4, which is mostly autonomous, but with some restrictions on when the self-driving works. For example, perhaps not in a blizzard.

I also think that outside of cities, it’s unlikely we’ll see self-driving anytime in the next decade. I think about my rural roads, some of which have no paint markers. Or mountain roads where the road disappears in the winter. I think about the West Ireland roads, driving from Cork to Baltimore, where the road literally isn’t wide enough for two cars and passing requires a little swerve into the bushes that are overgrown at the edge of the road.

I really don’t know that we can adequately model all these situations to make them self-driving level 5.

Personally, however, I’d be happy if we set some self-driving lanes, like half the highway where the car takes over for you and handles merging into the self-driving lane and out of it, after which a human takes over. Or perhaps some geo-fencing where most cars are self-driving (cities).

I’m not sure the tech is good enough to be unbounded, nor do I think most people would find this acceptable when there are mistakes.

A Good Bet?

Is this a good bet? Probably. There are already self-driving taxis in a few cities, including Beijing where there is no human at the wheel.

Plus, we humans have a history of letting technology loose before it’s really developed.

Posted in Blog | Tagged , | Comments Off on Level 5 Driving and Tesla FSD

Republish: The Learning Choice

I’m back home in the US, but getting my ankle fixed today. While I recuperate, you get The Learning Choice to (re)read.

Posted in Editorial | Tagged | Comments Off on Republish: The Learning Choice