2020-08-15
71 reads
Data Privacy and Protection
2020-07-21
93 reads
The Social Impact of Data
Let the data drive your decisions. This has been something of a mantra for many technical people, and even many business people, across the last twenty or so years. The allure of business intelligence is harnessing lots of data to make decisions that are rooted in some rational analysis of what has happened. Many companies […]
2020-06-06
89 reads
2020-04-16
137 reads
2020-03-31
69 reads
A Data Controversy
A request to rapidly gather data caused some friction recently. Is that something that organizations ought to be prepared to handle?
2020-03-26
152 reads
Automatic Redaction of PII
Amazon is providing automatic redaction of PII data in there transcription service.
2020-02-29
284 reads
Database Security, People and Processes
Protecting data is not easy, but it is critical. In this article, David Poole discusses database security and the behaviors needed to build secure systems.
2020-01-22
Learn to Change
This week Grant talks about the need for change and growth to adapt to the changing world.
2019-12-21
186 reads
Is Data the Future of the Vibrant Web?
There is a lot of data collected from web browsing. Steve doesn't think we need all that data, unlike Google.
2019-09-24
183 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