A sequential scan is not always a problem — PostgreSQL's planner often chooses one correctly for small tables or queries that return most of a table's rows. The dangerous...
2026-05-25
680 reads
I’ve been thinking a lot lately about what it actually takes to make an AI agent genuinely useful for database work, both for administration and for application access to...
2026-06-12 (first published: 2026-05-24)
402 reads
Redgate is a for-profit company. We look to make money by building and selling tools that help you. If we do a good job, we make money. If we...
2026-05-22
48 reads
I’ve uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my DataGrillen session Building the €100 data warehouse with the Azure Data Platform to Github. If...
2026-05-22
19 reads
If you've ever loaded a 2 GB CSV into pandas just to run a few aggregations — and watched your machine struggle — there's a better tool for the...
2026-06-10 (first published: 2026-05-21)
474 reads
What problem is Fabric Ontology trying to solve? For years, most data conversations have started with tables. We ask where the data lives, what columns are available, how the...
2026-06-10 (first published: 2026-05-20)
332 reads
Recently I ran across some code that used a lot of QUOTENAME() calls. A colleague was having some trouble with the code, but what struck me was that I...
2026-06-08 (first published: 2026-05-20)
438 reads
There are some telltale signs that your growing business has outgrown Excel for your reporting needs. Excel is probably the most adopted piece of software out there, and I...
2026-06-08 (first published: 2026-05-20)
373 reads
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the invitation post, I intentionally kept the prompt broad because change detection looks different depending on...
2026-06-05 (first published: 2026-05-19)
561 reads
Efficient query performance in Amazon Redshift often comes down to how well you manage workload concurrency. Redshift's Workload Management (WLM) queues enable you to control how queries share resources,...
2026-06-05 (first published: 2026-05-18)
147 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...
Comments posted to this topic are about the item A Quick Second Opinion
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Comments posted to this topic are about the item 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