The Power of Data and Privacy
Steve discusses privacy and data that is publicly available on the Internet.
2026-02-11
98 reads
Data Privacy and Protection
Concerns over AI Chat Privacy
Many of the GenAI services are using the free model of the past, where they use your data in ways you might not expect. Now, a court is ensuring OpenAI keeps your chat data around.
2025-09-03
113 reads
2024-09-16
101 reads
A Lack of Privacy in Smart Cars
With new vehicles becoming more and more computerized and controlled, is data privacy an issue?
2023-11-29
211 reads
The Chief Data Officer
The idea of a Chief Data Officer is growing in many companies. Steve thinks this is a good thing.
2022-03-16
160 reads
Location Data Is Not Anonymous
The world of public data is scary for Steve, even when the data is aggregated. It appears that keeping information private is becoming harder, and perhaps, impossible.
2021-10-04
162 reads
Tracking, Privacy, and Lots of Data
Apple has implemented some privacy controls for customers, which some advertisers don't like, but Steve agrees with.
2021-06-16
143 reads
Agree or Lose Features
Forcing users to agree to a new EULA or removing features seems like a bad idea to Steve.
2021-05-26
177 reads
Differential Privacy
Steve looks at a technique that some think will allow more data to be used in research and training.
2021-05-24
122 reads
Finding Legal Data
Using data scraped from the web might be convenient, but is it legal. Perhaps more importantly, is it moral? Steve has a few thoughts.
2021-04-19
193 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
Question of the Day
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 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers