T-SQL Tuesday #191: Invitation–Your Favorite String Parsing
It’s that time of the month, and I’m late. My apologies. I had a mix-up with a host and was on vacation all last week, so no invite. I’m...
2025-10-12
37 reads
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
For decades, enterprises have approached data management with the same mindset as someone stuffing everything into a single attic. The attic was called the data warehouse, and while it...
2025-10-29 (first published: 2025-10-09)
356 reads
Truncate Table Pitfalls
Truncate Table Pitfalls
Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly. If you want the speed without the face-palm moments, here’s a practical, interview-ready guide to...
2025-10-29 (first published: 2025-10-08)
976 reads
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that was presented at the dataMinds Connect 2025 conference at GitHub.
The post dataMinds Connect 2025 –...
2025-10-08
50 reads
“SQL Server Is Slow” Part 4 of 4
Parts 1, 2 and 3 got you to the (SQL) engine room. Now we use community-trusted tools to find what’s going on, fix it safely, and hopefully keep it...
2025-10-07
218 reads
How to Install DBeaver and Connect to a PostgreSQL Instance
Whether you’re a seasoned DBA or just exploring database tools, DBeaver offers a powerful, cross-platform GUI for interacting with PostgreSQL and many other databases. As a continuation of the...
2025-10-07
285 reads
DBAs should never run SSMS under their everyday Windows account
DBAs should never run SSMS under their everyday Windows account
If you open SSMS under the same Windows identity you use for email, browsing, and chat, you bring all that...
2025-10-22 (first published: 2025-10-07)
1,652 reads
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
639 reads
From Firefighting to Future‑Building: SQL Server 2025 and the New DataOps Mindset
There are moments in technology when the ground shifts beneath our feet. Moments when the tools we once thought of as reliable utilities suddenly become engines of transformation. SQL...
2025-10-06
181 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
566 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers