AH.. a dba against hackers..
Just keep alert an act on real trend anomalies.
Is automating Microsoft Fabric easy?
Is Fabric easy? I don’t know, because I didn’t do the exams.Is automating Fabric easy? Let’s find out. The scenario A common situation: some data sits in a local, on-premises SQL Server, other data in an Azure SQL Database. You…
A junior dev dropped a table. Now the junior DBA has to fix it.
A free Windows app that turns the best community restore procedure into three things a junior DBA can do under pressure: restore a full chain, stop at an exact time, and keep a copy in sync with log shipping.
Fabric demo: Azure SQL and local SQL into one warehouse table
Fabric_Test1 · PowerShell demo A customer from Azure SQL (1, Jansen, A) and a customer from the local Win10 SQL Server (1, Pietersen, B) are loaded into a Fabric warehouse, enriched with T-SQL, and published as dwh.Customers. Every step is…
Log shipping to Fabric?
But Ronald, is that even possible? Yes — and it’s easier than you’d think, now that we have SQL Server 2025 CES (see: [dbaronald.nl/just-say-yes-to-sql-server-2025-ces]()). With this app you get close: export a big table to Parquet, land it in Fabric,…
Datamodel Diagrams
Who votes for removing the “Create Diagram” feature in SSMS?Back in the day we used PowerDesigner, then SSMS diagrams came along—everyone was happier, and it was free.Now we just ask Claude to generate diagrams, and honestly it does a better…
Running a local AI model for DBA work
Cloud AI assistants are great, but as a DBA I am always a bit careful with what leaves my machine. Query text, table names, error logs: it adds up. So I wanted to find out: can I run a decent coding…
LEFT JOIN: why your filter returns too many rows — or too few
One query, three versions, and the one rule that explains all of them. The question sounds simple: “Show me all bookings that have not been invoiced yet — so no invoice that is already Exported or Printed.” A first attempt at this query…
Execution Plan: Adaptive Joins
How they work… “I have a transactions table (~10M rows) and a card_banlist table (~1M rows).I want every transaction that happened on a banned card after that card’s ban date.” Setup some objects. The query we are using. The Execution…
SQL Server 2025 Backup/Restore Compression: A Benchmark Tool
SQL Server 2025 ships three backup compression algorithms — MS_XPRESS, QAT_DEFLATE, and ZSTD — and none of them is universally best. I built a small Windows tool that runs all of them against a real database side by side, so…