Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion architecture declaratively, but once you have a pipeline of MLVs in production, you need visibility...
2026-05-13 (first published: 2026-04-30)
142 reads
If you’ve been here before, you know this blog is usually about SQL Server, PowerShell, and the day-to-day work of being a DBA. Execution plans, availability groups, dbatools scripts...
2026-05-13 (first published: 2026-04-28)
447 reads
In the previous post we saw that even though we had done an exchange partition mid-flights through a query execution, the query kept on running to successful completion. The...
2026-05-13
2 reads
Some times I’m blown away by how the database will try very hard to save you from yourself :-). Consider the following example: I’ve got a table called T....
2026-05-12
2 reads
This month we have a new host, Meagan Longoria, who graciously agreed to help me this month. I’ve known Meagan for a number of years and she’s been a...
2026-05-12
25 reads
I’ve been doing storage load tests for SQL Server for a long time, both as a consultant and now in my work at Everpure, and I see the same...
2026-05-11 (first published: 2026-04-27)
215 reads
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding which queries consume the most DTU (Database Transaction Unit) helps prioritize tuning efforts and improve...
2026-05-11
55 reads
I’m at the UK Redgate office today, meeting with senior leaders in all areas of the business. I was honored to be awarded a spot in our President’s Club....
2026-05-11
24 reads
I don’t have SQL Server installed on my laptop. In an effort to keep things clean and smooth in case I need to rebuild things, I’ve gone with containers....
2026-05-11 (first published: 2026-04-29)
314 reads
the kinder surprise – . the point in your early adolescence when you realize that your parents are muddling through their lives the same as you; that many respectable...
2026-05-08
39 reads
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...
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
WA:08218154393 Kawasan Industri Modern Cikande, Komp. Ruko, Jl. Raya Jkt No.Km. 68 Blok C-6,...
WA:08218154393 Jl. Jend. Sudirman No.38, Sumurpecung, Kec. Serang, Kota Serang, Banten 42118
Wa:0821-4447-7715 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa Timur...
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