One of the first things I review when I inherit a new SQL Server environment is the SQL Agent jobs. I can learn a tremendous amount about an organization...
2026-07-01 (first published: 2026-06-16)
457 reads
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You open the terminal and go to work. This post is about what happens next —...
2026-06-16
162 reads
I’ve had a Dropbox account for years. Like a lot of people, I started using it when it was one of the easiest ways to sync files across machines...
2026-06-16 (first published: 2026-06-15)
66 reads
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic, an IP lookup table, and KQL's anomaly detection to find who did it.
2026-06-29 (first published: 2026-06-15)
143 reads
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced! We’re kicking off at 1pm UTC on August 20th…here’s the schedule: – N.B. – If...
2026-06-26 (first published: 2026-06-15)
109 reads
You paste a slow Redshift query plan into PlanTrace and one of the tuning insights reads "SORTKEY optimization candidate", pointing at an explicit sort step that's adding cost you...
2026-06-15
10 reads
As part of my running the SQL Saturday charitable foundation, I get sponsorship money from vendors. Primarily Microsoft and AMD, but I hope to change that in the future....
2026-06-15
19 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break into data engineering or AI, nothing on your resume carries more weight than a GitHub...
2026-06-29 (first published: 2026-06-12)
405 reads
We work hard at Redgate, though with a good work-life balance. One interesting observation for me (as an American) is how well most of the company in the UK...
2026-06-12
53 reads
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A read-only advisory system does exactly two things: it observes and it recommends. It never acts....
2026-06-11
32 reads
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
WhatsApp:08218200205 Jl. Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat,...
WA:08218154393 Jl. Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat,...
Wa:0817819444 Jl. Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat,...
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