Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one of my favorite rabbit holes is revisiting Paul Randal’s series on file header pages. If...
2026-04-18
43 reads
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
Thanks to everyone who joined the blog party this month. I noticed three themes in the responses. Every response had one or more of these themes woven into their...
2026-04-17
15 reads
OpenClaw- Agentic Engineering
This week has training on AI – Cyber security experts – Omar Santos and Aamir Lakhani- with great knowledge . during the session learned about OpenClaw and more. I...
2026-04-29 (first published: 2026-04-17)
354 reads
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to delve into visualisation of vector embeddings that were generated from the restaurant data pulled from...
2026-04-29 (first published: 2026-04-17)
254 reads
The Intersection Between DevOps and FinOps
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster, deploy faster. But while we accelerate delivery, why not shorten the expense lifecycle as well?...
2026-04-17
16 reads
GROUP BY ALL – Is it ALL you ever need?
You have probably seen a couple of cool GROUP BY features that came with Oracle Database 26ai. You can check out the short video below but since you’re on...
2026-04-17
3 reads
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB as the source) that I’ve managed to run into, twice. I’ve set up mirroring by...
2026-04-27 (first published: 2026-04-15)
229 reads
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an example of why it can behave weirdly. This post looks at something you might not...
2026-04-27 (first published: 2026-04-15)
201 reads
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards or optimisation scripts. Tools can highlight waste, but culture determines whether anyone acts on it....
2026-04-24 (first published: 2026-04-15)
170 reads
The Rise of “Post Regret”: Why More Teams Are Regretting Their SQL Server to Postgres Migration
As a data nerd who’s spent the last 25+ years helping organizations keep their databases running smoothly, I’ve had this conversation more times than I can count: “We’re moving...
2026-04-14
7 reads
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
Alamat Kantor BCA KCP Dakota Telp:0817866887
WA:0817-866-887 Jl. Dakota No.Raya 42, H dan 46, Sukaraja, Kec. Cicendo, Kota Bandung, Jawa...
ALAMAT BCA KCU DAAN MOGOT WA {08218154393}
WA:08218154393 Jl. Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat,...
ALAMAT BCA KCU SURYOPRANOTO WA,?{08218154393}
WA:08218154393 Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus...
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers