A Prompt AI Experiment
Prompt AI released recently and I decided to try a few things with the tool that might help me in database work. I’ve had to do this task, but...
2025-09-17
104 reads
The Voice of the DBA
In Memory of Andrew Clarke, AKA Phil Factor
One of the parts of getting older that really sucks is I seem to attend more funerals than weddings. It’s a sad fact of file, and this was one...
2025-09-15
573 reads
A New Word: Anderance
anderance – n. the awareness that your partner perceives the relationship from a totally different angle than you – spending years looking at a different face across the table,...
2025-09-12
507 reads
T-SQL Tuesday #190–Mastering a New Technical Skill
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great invitation that is near and dear to my heart: mastering a new or existing technical...
2025-09-09
77 reads
Getting Started with the MSSQL AI Agent in VS Code
Recently I was working in VS Code and I saw a walkthrough for the new Copilot chat features. I decided to give those a try in trying to get...
2025-09-08
503 reads
Advice I Like: Praise
Don’t reserve your kindest praise for a person until their eulogy. Tell them while they are alive when it makes a difference to them. Write it in a letter...
2025-09-05
862 reads
Using Customer Docker Compose File Names
As I use containers more and more to run various things, I decided I not only wanted to set up docker compose files, I wanted to name them something...
2025-09-26 (first published: 2025-09-03)
355 reads
The Book of Redgate: Meetings
I think we might have forgotten this a bit, but on one of the pages, we have this title: A Meeting without an Objective is a Chat. You can...
2025-08-29
57 reads
A New Word: Rivener
rivener – n. a chilling hint of distance that creeps slowly into a relationship – beginning to notice them laugh a little less, look away a little more, explain...
2025-08-22
18 reads
Adding SQL Server 2025 to my Laptop
I wanted to do some testing of SQL Server 2025 on my laptop. I have written before how I avoided installing SQL Server on the laptop and use containers...
2025-09-10 (first published: 2025-08-20)
725 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