Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
 
The Voice of the DBA
 

A Worse Computer; A Better Car

A few weeks ago, my wife and I purchased a Lucid Gravity for our second EV. We've owned a Tesla for almost five years, and it has been an amazing car. However, we decided that we spend a lot of time driving, and we wanted something a little more luxurious. The Tesla has a bit of a stiff ride, and it's not quite as lush a car as some others EVs that have come out since we bought our Model Y. After trying a few different brands, we were excited by the Lucid and decided to get one.

Like the Tesla Model Y, this is really a computer on wheels. A lot of software and screens drive the vehicle, though it's not quite as minimalist as a Tesla vehicle. There are physical buttons and controls in various places, and more than one screen. Some things work better, and I like that.

However, some things are worse. While researching online to learn about the car, we saw someone post this: The Lucid is a better car, but a worse computer. The Tesla is a better computer but worse car.

I agree with that. One thing I've learned in owning two and other modern computerized vehicles is that software is hard. Even something as basic as Bluetooth can be a hassle and operate inconsistently in different vehicles. I've also learned that product managers and engineers don't always think deeply about the end-user experience. Perhaps the Lucid developers are under pressure to get features out, but it seems that I've encountered more than a few things that could (should?) have been built differently. Or would have if a little more thought were given to the end-user experience, especially given how easily software can be configured with toggles and switches. I'm always amazed when more things aren't switchable in software.

Yes, I know software takes time, and it is hard. My tenure at Redgate has given me appreciation for the challenges of deciding what to build, test, and release. I'll write about some of the Lucid decisions on my blog, as there are a few things from the software development perspective that make me scratch my head. It's not just me, as I've known people who have had Fords, Cadillacs, and Volvos who complained to no end about their teething pains with the software.  A few were ready to abandon the cars. I don't feel that way, and I know I'm an early adopter. I have some tolerance and patience for the things I think aren't built well.

Overall, the car is amazing, very comfortable, and brings a smile to my face, but there are a few software conveniences I got used to in the Tesla that are missing in the Lucid. It's definitely a worse computer.

But a much, much nicer car. And, as the delivery guy noted, this is the worst version of the car I bought. It will only get better over time.

If you think about a Lucid, use my referral link. We'll both get some credit.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
 
 Featured Contents
SQLServerCentral Article

The Hidden Danger of Wildcard Operators In Join Operations

sabyda from SQLServerCentral

This article looks at one of the killers of performance at scale, SELECT *.

Technical Article

How to get clean, usable data out of SQL Server into Python

Additional Articles from SQLServerCentral

Build scalable data pipelines by pushing transformations into SQL and keeping Python focused on analysis.

Blog Post

From the SQL Server Central Blogs - Monday Monitor Tips: The MCP Server

Steve Jones - SSC Editor from The Voice of the DBA

I have been experimenting with MCP servers in a few ways, and pressing on our Redgate Monitor team to add one to their system. They did, started adding tools,...

Blog Post

From the SQL Server Central Blogs - How to Provision an Azure SQL Database

MarlonRibunal from Marlon Ribunal - SQL, Code, Coffee, etc.

Aside from spinning up a SQL Server instance container, the free Azure SQL Database is another great tool for learning SQL. You can even use it for low-traffic or...

SQL Server 2022 Query Performance Tuning

Grant Fritchey from SQLServerCentral

Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expanded information on using extended events, automatic execution plan correction, and other advanced features now available in SQL Server.

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

The SQL Server MCP Server

How do I get an MCP server for my SQL Server 2025 database from Microsoft?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

The Range of Customers

I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):

orderid orderdate               customerid complete
3       2025-05-10 00:00:00.0002          1
21      2024-01-10 00:00:00.0003          1
15      2023-10-28 00:00:00.0004   1
13      2025-03-08 00:00:00.0006          1
11      2024-04-02 00:00:00.0007          1

If I run this query, how many rows are returned?

SELECT *
 from dbo.OrderHeader
 where customerid between 3 and '6'

Answer: 3

Explanation: This returns 3 rows. Between is equivalent to >= beginning range and <= ending range. Ref: BETWEEN - https://learn.microsoft.com/en-us/sql/t-sql/language-elements/between-transact-sql?view=sql-server-ver17

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


SQL Server 2016 - Administration
Removing production permissions when restoring database to non-prod - Hello experts, An application team has asked us to modify a SQL Agent job. The job currently restores a backup of the production database to their test SQL Server. We do have provisions for masking the non-prod data. However, for years I have used a script to preserve the test db permissions and then replace […]
Editorials
Are You Working More Hours? - Comments posted to this topic are about the item Are You Working More Hours?
Finding Bad Queries - Comments posted to this topic are about the item Finding Bad Queries
VACATION! - Comments posted to this topic are about the item VACATION!
Fixing P1 Queries - Comments posted to this topic are about the item Fixing P1 Queries
SQLServerCentral.com Test Forum
Test topic for spam filtering - A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Article Discussions by Author
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time - Comments posted to this topic are about the item Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
A Limited Startup - Comments posted to this topic are about the item A Limited Startup
T-SQL in SQL Server 2025: REGEXP_LIKE - Comments posted to this topic are about the item T-SQL in SQL Server 2025: REGEXP_LIKE
Advanced T-SQL: Replacing Slow Cursors with Window Functions - Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors with Window Functions
The Service Name - Comments posted to this topic are about the item The Service Name
Why SQL Server Database Attach fails and how to repair it - Comments posted to this topic are about the item Why SQL Server Database Attach fails and how to repair it
BIT_COUNT() IV - Comments posted to this topic are about the item BIT_COUNT() IV
Symmetric Key Encryption - Comments posted to this topic are about the item Symmetric Key Encryption
SQL Server 2022 - Development
iso source of scripts. - While doing some housekeeping I came across a folder containing some scripts that appear to be for a transaction log alert system. Now all scripts except one obviously were generated by SSMS which indicates I didn't save the original scripts or I did this project from a video and wanted to save everything before I […]
 

 

RSS FeedTwitter

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -