macOS Tahoe breaks SQL Server on Docker containers on Apple silicon
The honeymoon is over, and macOS 26 Tahoe broke the Rosetta 2 emulation layer with SQL Server 2025 RC 1 running in a Docker container. I know it was...
2025-10-06
526 reads
Blog Posts
Monday Monitor Tips: The Jobs Report
A customer wanted a report they could email to their boss about jobs, something that showed failures. This isn’t hard to get in Redgate Monitor, though it is manual...
2025-10-06 (first published: 2025-09-22)
242 reads
Why Developers Shouldn’t Have sysadmin access in SQL Server
Why Developers Shouldn’t Have sysadmin access in SQL Server
7 reasons—and exactly what to do instead
It can feel “faster” to hand developers sysadmin. In reality, it’s like giving them the master...
2025-10-06
519 reads
A New Word: Ecstatic Shock
ecstatic shock – n. a surge of energy upon catching a glimpse from someone you like, which scrambles your ungrounded circuits and tempts you to chase after that feeling...
2025-10-03
25 reads
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved a mystery alone. Scooby and Shaggy could sniff out a clue between snacks, but it...
2025-10-03 (first published: 2025-09-10)
225 reads
Troubleshooting SQL Server – Starting with the Error Log
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?” What’s your first move? For me, it starts with the SQL Server Error log. I...
2025-10-03 (first published: 2025-09-11)
556 reads
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth, blocks covering-index usage, and makes code brittle when schemas change. Specify only the columns you...
2025-10-02
37 reads
The CDO’s Playbook for AI Driven Decision Making
The New Arena of Leadership The role of the Chief Data Officer is no longer about governance alone. It is about vision. It is about turning data into the...
2025-10-02
17 reads
AI Model Size, Parameters and Download
At SQL Saturday Boston 2025, I gave a presentation on local LLMs and there was a great question that I wasn’t sure about. Someone asked about the download size...
2025-10-01
39 reads
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing a Power BI report. It’s easy to forget the active page since it’s just set...
2025-10-01 (first published: 2025-09-09)
172 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