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
22 reads
The Voice of the DBA
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
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
Back in the EU
I flew to Amsterdam last night and hopefully by the time this publishes I’ll be at my hotel, catching up on messages and prepping for another Simple Talk Podcast...
2025-09-29
17 reads
SQL Saturday Boston Slides and Code
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve got resources listed below Slides Here are the slides from my two sessions Running a...
2025-09-27
29 reads
Advice I Like: Fear and Imagination
Fear is fueled by a lack of imagination. The antidote to fear is not bravery; it looks more like imagination – from Excellent Advice for Living What a neat...
2025-09-26
21 reads
The Challenge of Implicit Transactions: #SQLNewBlogger
I saw an article recently about implicit transactions and coincidentally, I had a friend get caught by this. A quick post to show the impact of this setting. Another...
2025-10-17 (first published: 2025-09-24)
309 reads
Local LLM Models at SQL Saturday Boston 2025
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking, two sessions I think. At least one. I’m excited for this session as I’ve had...
2025-09-23
25 reads
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
The Book of Redgate: We Value Teams
This value is something that I still hear today: our best work is done in teams. On the facing page, there is a short description of what this means....
2025-10-10 (first published: 2025-09-19)
181 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