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
Blog Posts
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
The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail of clues. With SQL Server 2025 now reaching its first Release Candidate (RC0), it feels...
2025-10-10 (first published: 2025-09-17)
380 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
32 reads
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly efficient, OLTP systems were the workhorses of enterprise data. They handled the daily grind: purchases,...
2025-10-08 (first published: 2025-09-11)
306 reads
SQL Server Is Slow (part 1 of 4)
How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at you that SQL Server is slow? Stop. Don’t Open SSMS Yet. You’ve heard it...
2025-10-08 (first published: 2025-09-17)
419 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
191 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
229 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
161 reads
Installing Old Versions of PowerShell Modules with Their Dependencies
I don’t recall where this came up (probably in SQLSlack), but I had a need to install an older version of dbatools to test something related to loading the...
2025-10-06 (first published: 2025-09-16)
154 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
BCA KCU WISMA ASIA | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu Sel., Kec....
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...
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