The Data Model Matters
Is a data model important in modern software? Steve thinks it is and gives a few reasons why we might want to spend a little time on ensuring we have good models as we build software.
2026-06-05
74 reads
Editorials
2026-06-03
59 reads
Fixing Impostor Syndrome
Lessons on impostor syndrome from a marketer apply to technologists as well.
2026-06-01 (first published: 2022-09-09)
381 reads
Celebrating 30 years of PostgreSQL, A Thank you message
A Thank You message to the original founds of the PostgreSQL project and members of the community that have been working so hard for 30 years.
2026-05-30
223 reads
Bean Counting to Burnout
Do meetings and paperwork take a toll on administrators? Steve draws a comparison to some of the changes in the US healthcare system.
2026-05-29 (first published: 2020-10-14)
222 reads
Coping with a working life as an imposter
It is not existing knowledge but the skill of acquiring new knowledge rapidly that will help you overcome imposter syndrome.
2026-05-27 (first published: 2020-09-19)
483 reads
Everything I Needed to Know Used to be Found in One Book
Books used to be the source of knowledge, but times have changed.
2026-05-25
149 reads
Even When You Know What You're Doing, You Can Screw Up
There I was, walking around Amsterdam, radio in hand (OMG! He's talking about radios again!), automatically transmitting Active Packet Report System (APRS) signals every 90 seconds. Same radio I had used in Chicago a couple of weeks ago and in Poland last week. I was on the correct frequency and, as I say, I had […]
2026-05-23
129 reads
The New Software Team
Software teams are changing with AI and this might be an exciting time for developers if they take advantage of the capabilities available.
2026-05-22
91 reads
Limit the Blast Radius
AI can go off the rails, as we see in a recent story about an LLM deleting a production database.
2026-05-20
89 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers