Sign in

Darling Data

@erikdarling.com
470 followers 80 following 755 posts

I will make your #SQLServer faster in exchange for money. linktr.ee/darlingdata

PostsRepliesMedia
Darling Data @erikdarling.com · 29/09/2026
Why did Microsoft turn RCSI on by default in Azure SQL Database? Because they had to run your workload themselves. Not a joke. It is my strongest argument. I brought others. Read Committed Is Cruel by Default, at #PASSDataSummit West. passdatacommunitysummit.com/west/
020
Darling Data @erikdarling.com · 29/09/2026
I asked an AI to tune my query. It added DISTINCT, apologized, and said the real index was the friends we made along the way. AI T-SQL gets a segment at my #PASSDataSummit West precon. Where it helps, where it lies. passdatacommunitysummit.com/west/
020
Darling Data @erikdarling.com · 28/09/2026
hell yeah
170
Darling Data @erikdarling.com · 24/09/2026
Knock knock. Who's there? A writer. A writer who? Doesn't matter. You're a reader under Read Committed, so you'll be waiting out here until the writer is done. Read Committed Is Cruel by Default: #PASSDataSummit West, Seattle. passdatacommunitysummit.com/west/
070
Darling Data @erikdarling.com · 24/09/2026
What's the difference between a table variable and a temp table? One of them has statistics. That's it. That's the joke. It's also why your batch job takes four hours. Full day of this at my #PASSDataSummit West precon: T-SQL That Doesn't Suck. passdatacommunitysummit.com/west/
010
Darling Data @erikdarling.com · 22/09/2026
I put NOLOCK on all the reports. Now they are fast and occasionally fiction. Row versioning gets you the fast part without the creative writing. Read Committed Is Cruel by Default: my session at #PASSDataSummit West. passdatacommunitysummit.com/west/
010
Darling Data @erikdarling.com · 22/09/2026
Knock knock. Who's there? An implicit conversion. An implicit conversion who? Doesn't matter. You're scanning the whole table now. T-SQL That Doesn't Suck, my #PASSDataSummit West precon. Bring your worst stored procedures. passdatacommunitysummit.com/west/
052
Darling Data @erikdarling.com · 20/09/2026
congratulations to visual studio code for reaching a cool version number: code.visualstudio.com/updates/v1_138
code.visualstudio.com
Visual Studio Code 1.138
Learn what is new in Visual Studio Code 1.138
110
Darling Data @erikdarling.com · 18/09/2026
PerformanceMonitor 3.8.0: build your own alert rules on any metric it collects, SQL Server or Postgres. High CPU pages name the backup that caused them. Long query alerts name the Agent job. Your 2am self deserves this. github.com/erikdarlingd...
052
Darling Data @erikdarling.com · 17/09/2026
Two sessions try to tell the same knock knock joke. Neither can say who's there until the other answers. SQL Server picks a victim. That is the real technical term. Deadlocks, blocking, and how to stop both: my #PASSDataSummit West session. passdatacommunitysummit.com/west/
010
Darling Data @erikdarling.com · 17/09/2026
A CTE walks into a bar. Then walks into the same bar. Then walks into the same bar. You referenced it three times. It is not materialized. It will keep walking into that bar. T-SQL That Doesn't Suck: my full day #PASSDataSummit West precon. passdatacommunitysummit.com/west/
051
Darling Data @erikdarling.com · 16/09/2026
Performance Studio 1.26 is out. The UI got a real pass. One icon set instead of emoji, advice as cards instead of a wall of monospace. Plus a stack of bugs I only found because I was in there looking. github.com/erikdarlingd...
000
Darling Data @erikdarling.com · 15/09/2026
Nobody picked Read Committed. Ever. It came with the box, like a free knife that only cuts you. My #PASSDataSummit West session: Read Committed Is Cruel by Default. Pick an isolation level on purpose, once, as a treat. passdatacommunitysummit.com/west/
050
Darling Data @erikdarling.com · 15/09/2026
Knock knock. Who's there? Your query from this morning. Your query from this morning who? Exactly. Still running. Nobody remembers who it is anymore. I fix this for a living. Full day precon at #PASSDataSummit West: T-SQL That Doesn't Suck. passdatacommunitysummit.com/west/
040
Darling Data @erikdarling.com · 10/09/2026
Free SQL Server and PostgreSQL performance monitoring. No agents, no per-core pricing. v3.7.0 is out with fleet-health, Azure SQL Database, and PostgreSQL fixes across the board. 5 servers or 500, same tool. erikdarling.com/free-sql-ser...
030
Darling Data @erikdarling.com · 03/09/2026
Performance Studio 1.24.0: crash-proof session restore, unsaved queries that survive a crash, full analysis of stored procedure and cursor bodies, and web plan sharing that no longer chokes on deep plans. github.com/erikdarlingd...
000
Darling Data @erikdarling.com · 01/09/2026
Heading home. Thanks for the month, Europe. Paris > Azores > Lisbon > Cascais > Faro
070
Darling Data @erikdarling.com · 31/08/2026
for all my f5 friends: Updates_20260901 is live. github.com/erikdarlingd...
github.com
Release Updates_20260901 - Permission to Come Aboard · erikdarlingdata/DarlingData
sp_LogHunter has been turning away people who could read the error log perfectly well. That stops here. sp_LogHunter stops asking the wrong question The permission check was IS_SRVROLEMEMBER(N'sysa...
020
Darling Data @erikdarling.com · 31/08/2026
Performance Studio 1.22.0 release! github.com/erikdarlingd...
github.com
Release v1.22.0 · erikdarlingdata/PerformanceStudio
What's Changed Descend into stored procedure bodies when analyzing a plan (#455) by @erikdarlingdata in #456 deps: Bump the patch-and-minor group with 1 update by @dependabot[bot] in #457 Give que...
010
Darling Data @erikdarling.com · 29/08/2026
Well that’s got to sting a bit. aconcan.io/blog/flyway-...
aconcan.io
aconcan
A single command to roll back applied migrations with Flyway Community Edition, no license, no undo command, no crying in the club.
210
Darling Data @erikdarling.com · 15/08/2026
Azores! I saw some cows. They didn’t speak much English but they seemed nice enough.
0100
Darling Data @erikdarling.com · 15/08/2026
when in orly.
040
Darling Data @erikdarling.com · 14/08/2026
Au revoir Paris, Vou ser português agora.
060
Darling Data @erikdarling.com · 12/08/2026
Well that was fun
040
Darling Data @erikdarling.com · 12/08/2026
brb gonna light a cigarette off this eclipse
040
Darling Data @erikdarling.com · 09/08/2026
Trying to make friends.
370
Darling Data @erikdarling.com · 08/08/2026
They named one after me.
250
Darling Data @erikdarling.com · 07/08/2026
Performance Monitor 3.4 is out! github.com/erikdarlingd... Better compression, new Linux support, many bug fixes and performance improvements! Vendredi je suis amoureux!
github.com
Release 3.4.0 · erikdarlingdata/PerformanceMonitor
Highlights Gzip plan-dimension storage (V54) — measured 14.4× on 885 GB of production plan XML (vs 8.9× lz4 TOAST), with the --recompress-plan-dim operator verb for existing stores: verified batch...
130
Darling Data @erikdarling.com · 03/08/2026
Woah. clickhouse.com/blog/andy-pa...
clickhouse.com
Andy Pavlo joins ClickHouse to establish ClickHouse Labs | ClickHouse
I am excited to announce that I am joining ClickHouse, Inc. to establish and lead a new research team at ClickHouse Labs.
040
Darling Data @erikdarling.com · 01/08/2026
allez hop!
020
Darling Data @erikdarling.com · 01/08/2026
Goodnight you sleepyheads.
020
Darling Data @erikdarling.com · 29/07/2026
Performance monitoring that doesn't suck. Free. Built by someone who has actually tuned a query. Solve problems, instead of clicking around dumb charts and graphs. PerformanceMonitor 3.3.0 is out now: github.com/erikdarlingd...
github.com
Release v3.3.0 — Nothing Held Back · erikdarlingdata/PerformanceMonitor
See CHANGELOG.md for details. Highlights: the retention rollups now serve the history they claim (coverage-aware read routing + the --backfill-rollups operator verb, ending the held-purge era with ...
131
Darling Data @erikdarling.com · 23/07/2026
14 wins hwg
120
Darling Data @erikdarling.com · 22/07/2026
v3.2.0 is out. Darling is the new headless SQL Server monitoring edition. One free service watches 5 servers or 500, and an AI agent can drive it over MCP. Built by someone who actually tunes queries. github.com/erikdarlingd...
131
Darling Data @erikdarling.com · 22/07/2026
Performance Studio 1.16.0 is out. Query Store search and filtering: find plans by query text, set execution and duration thresholds, include or ignore specific queries. Filters apply before the top N. It updates itself. github.com/erikdarlingd...
000
Darling Data @erikdarling.com · 21/07/2026
New album in stores tomorrow.
070
Darling Data @erikdarling.com · 20/07/2026
a great post by niko where he talks about something really useful you can do with hekaton: www.nikoport.com/2026/07/19/t...
nikoport.com
The Odyssey of Hekaton (SQL Server 2025)
Over the years, I have contributed with a reasonably big number of posts on the topic of In-Memory OLTP (aka Hekaton) and I did a couple of focused presentations on this wonderful feature as well. …
150
Darling Data @erikdarling.com · 16/07/2026
typical sql server code review.
130
Darling Data @erikdarling.com · 10/07/2026
built a claude code plugin that reads sql server execution plans and tells you what's wrong. /plugin marketplace add erikdarlingdata/claude-plugins /plugin install sqlserver-query-plans@erikdarling then run /reload-plugins and just point it at a .sqlplan file: github.com/erikdarlingd...
github.com
GitHub - erikdarlingdata/claude-plugins: Claude Code plugins from Erik Darling Data
Claude Code plugins from Erik Darling Data. Contribute to erikdarlingdata/claude-plugins development by creating an account on GitHub.
0104
Darling Data @erikdarling.com · 08/07/2026
Bing! www.windowslatest.com/2026/07/07/m...
windowslatest.com
Microsoft 365 Copilot adoption is under 4.5% after 3 years, only 1% use it weekly, yet prices went up
Fewer than 4.5% of Microsoft 365 customers pay for Copilot after three years, only 1% use it weekly, and Microsoft raised prices regardless.
010
Darling Data @erikdarling.com · 06/07/2026
this is very cool. databricks is doing some really amazing stuff, which is a pretty stark contrast to the utter lifelessness of fabric: www.databricks.com/blog/lakebas...
databricks.com
From monolith to Lakebase to LTAP: rethinking the database from storage up
When
220
Darling Data @erikdarling.com · 04/07/2026
Performance Studio 1.15.0 is out. The Query Store visualizations now use a validated colorblind-safe palette, so the charts stay readable no matter how you see color. Auto-updates if you already have it. github.com/erikdarlingd...
041
Darling Data @erikdarling.com · 04/07/2026
July DarlingData release: Declaration of Index-pendence. sp_HumanEventsBlockViewer decodes wait_resource to show the blocked object. sp_IndexCleanup writes filtered-index fix scripts. github.com/erikdarlingd...
010
Darling Data @erikdarling.com · 03/07/2026
This heat has got RIGHT OUT OF HAND!!!
420
Darling Data @erikdarling.com · 01/07/2026
@jorriss.bsky.social congratulations on beating the Padres.
200
Reposted by Darling Data
Brent Ozar @brento.bsky.social · 25/06/2026
Get Your Blog Posts Ready for T-SQL Tuesday #200. Here’s the Topic. Way back in December of 2009, Adam Machanic published a blog post (archive) in which he invited database bloggers to participate in a new monthly event he called T-SQL Tuesday. Each month, he (or a blogger he picked) proposed a…
brentozar.com
Get Your Blog Posts Ready for T-SQL Tuesday #200. Here’s the Topic.
Way back in December of 2009, Adam Machanic published a blog post (archive) in which he invited database bloggers to participate in a new monthly event he called T-SQL Tuesday. Each month, he (or a blogger he picked) proposed a topic, and on that date, we'd all publish our blog posts at the same time. It was a fun way to get a variety of opinions about a topic.
021
Darling Data @erikdarling.com · 21/06/2026
Happy Father’s Day etc.
231
Darling Data @erikdarling.com · 17/06/2026
🎉🥳 IT'S HERE 🥳🎉 PerformanceMonitor v3.0.0 has landed, and it's a big one! 🚀 No more UI freezes 🔍 Object + index-level collection 🧠 Rebuilt recommendations engine Free, open source, zero breaking changes. 🍾 github.com/erikdarlingd...
063
Darling Data @erikdarling.com · 16/06/2026
Pre-cons for PASS Summit West are official 🎉 I'm teaching a full day: "T-SQL That Doesn't Suck: Solving Performance and Concurrency Problems." #PASSDataSummit passdatacommunitysummit.com/west/pre-con...
151
Darling Data @erikdarling.com · 14/06/2026
ZAG > IST (time travel) > NYC
040