Deep dive into YugabyteDB's PostgreSQL compatibility and its design, my FOSDEM talk recording is online:
Reusing the PostgreSQL codebase in a Distributed SQL Architecture
#executionplan #callstack #flamegraph #opensourcecode #internaltracing
fosdem.org/2025/schedul...
Reusing the PostgreSQL codebase in a Distributed SQL Architecture
#executionplan #callstack #flamegraph #opensourcecode #internaltracing
fosdem.org/2025/schedul...
FOSDEM 2025 - Reusing PostgreSQL codebase in a Distributed SQL Architecture (YugabyteDB)
fosdem.org
February 8, 2025 at 4:24 PM
Deep dive into YugabyteDB's PostgreSQL compatibility and its design, my FOSDEM talk recording is online:
Reusing the PostgreSQL codebase in a Distributed SQL Architecture
#executionplan #callstack #flamegraph #opensourcecode #internaltracing
fosdem.org/2025/schedul...
Reusing the PostgreSQL codebase in a Distributed SQL Architecture
#executionplan #callstack #flamegraph #opensourcecode #internaltracing
fosdem.org/2025/schedul...
Stop fighting the operator.
Start finding the root cause.
www.tiktok.com/@kimberlyeme...
#SQLServer #BackendDevelopment #DatabaseEngineering #Programming #TechTok #QueryPerformance
Start finding the root cause.
www.tiktok.com/@kimberlyeme...
#SQLServer #BackendDevelopment #DatabaseEngineering #Programming #TechTok #QueryPerformance
Hash Match is not the villain. #sql #executionplan #hashmatch
TikTok video by Kimberly Emerson | Developer
www.tiktok.com
May 8, 2026 at 12:44 AM
Stop fighting the operator.
Start finding the root cause.
www.tiktok.com/@kimberlyeme...
#SQLServer #BackendDevelopment #DatabaseEngineering #Programming #TechTok #QueryPerformance
Start finding the root cause.
www.tiktok.com/@kimberlyeme...
#SQLServer #BackendDevelopment #DatabaseEngineering #Programming #TechTok #QueryPerformance
Effect 3.16 has been released!
‣ New ExecutionPlan module, for building fallback scenarios when dealing with flaky services
‣ Effect.Service parameter support
‣ Access Schedule information for more fine-grained retry logic
And more!
effect.website/blog/release...
‣ New ExecutionPlan module, for building fallback scenarios when dealing with flaky services
‣ Effect.Service parameter support
‣ Access Schedule information for more fine-grained retry logic
And more!
effect.website/blog/release...
Effect 3.16 (Release)
effect.website
May 28, 2025 at 11:28 AM
Effect 3.16 has been released!
‣ New ExecutionPlan module, for building fallback scenarios when dealing with flaky services
‣ Effect.Service parameter support
‣ Access Schedule information for more fine-grained retry logic
And more!
effect.website/blog/release...
‣ New ExecutionPlan module, for building fallback scenarios when dealing with flaky services
‣ Effect.Service parameter support
‣ Access Schedule information for more fine-grained retry logic
And more!
effect.website/blog/release...
New blog/video alert!
It's Part 2 of Where Did You Get that Query Plan From (And Why It Matters). Join me as we talk about Actual Execution plans
#sqlserver #queryplan #executionplan #performancetuning #actualexecutionplans
It's Part 2 of Where Did You Get that Query Plan From (And Why It Matters). Join me as we talk about Actual Execution plans
#sqlserver #queryplan #executionplan #performancetuning #actualexecutionplans
Where Did You Get That Query Plan From? (And Why It Matters) – Part 2 (video)
This is the second part of the series. Hopefully you are all caught up on Part 1. If not, you can see that here. Part 2 is about Actual Execution Plans. I have the (slightly edited for garbled words) transcript below for those who prefer to read, with references to places in the video. Otherwise, watch the video and let me know what you think.
debthedba.wordpress.com
July 20, 2026 at 2:31 PM
New blog/video alert!
It's Part 2 of Where Did You Get that Query Plan From (And Why It Matters). Join me as we talk about Actual Execution plans
#sqlserver #queryplan #executionplan #performancetuning #actualexecutionplans
It's Part 2 of Where Did You Get that Query Plan From (And Why It Matters). Join me as we talk about Actual Execution plans
#sqlserver #queryplan #executionplan #performancetuning #actualexecutionplans
New video/blog series alert:
Let's talk about "Where Did You Get that Query Plan From (and Why It Matters)?" This will be Part 1 of 3, starting with Estimated Execution Plans.
#sqlserver #queryplan #executionplan #performancetuning #ssms #estimatedexecutionplan
Let's talk about "Where Did You Get that Query Plan From (and Why It Matters)?" This will be Part 1 of 3, starting with Estimated Execution Plans.
#sqlserver #queryplan #executionplan #performancetuning #ssms #estimatedexecutionplan
Where Did You Get That Query Plan From? (And Why It Matters) – Part 1 (video)
I'm very excited for this because I've wanted to put something together about this topic for a long time. What inspired me is that I've really come to appreciate that there's different pieces of information collected with the execution plan itself depending on where I get the plan from. Understanding what's collected, where, and why can help make a difference when trying to troubleshoot and performance tune.
debthedba.wordpress.com
July 13, 2026 at 2:30 PM
New video/blog series alert:
Let's talk about "Where Did You Get that Query Plan From (and Why It Matters)?" This will be Part 1 of 3, starting with Estimated Execution Plans.
#sqlserver #queryplan #executionplan #performancetuning #ssms #estimatedexecutionplan
Let's talk about "Where Did You Get that Query Plan From (and Why It Matters)?" This will be Part 1 of 3, starting with Estimated Execution Plans.
#sqlserver #queryplan #executionplan #performancetuning #ssms #estimatedexecutionplan
New blog/video alert!
It's time for the 3rd and final video in the Where Did You Get That Query Plan From? (And Why It Matters) series. We'll finish by talking about DMVs and Query Store and then bring everything together.
#sqlserver #queryplan #executionplan #performancetuning #querystore #dmvs
It's time for the 3rd and final video in the Where Did You Get That Query Plan From? (And Why It Matters) series. We'll finish by talking about DMVs and Query Store and then bring everything together.
#sqlserver #queryplan #executionplan #performancetuning #querystore #dmvs
Where Did You Get That Query Plan From? (And Why It Matters) – Part 3 (video)
It's the final video of the 3 part series. Hopefully you have watched (or read) Parts 1 & 2. This third video is about DMVs and Query Store. We'll bring everything back together at the end. The (slightly edited for garbled words) transcript is at the end for those who prefer to read, with references to where in the video you can find the demos I'm talking about.
debthedba.wordpress.com
July 27, 2026 at 2:41 PM
New blog/video alert!
It's time for the 3rd and final video in the Where Did You Get That Query Plan From? (And Why It Matters) series. We'll finish by talking about DMVs and Query Store and then bring everything together.
#sqlserver #queryplan #executionplan #performancetuning #querystore #dmvs
It's time for the 3rd and final video in the Where Did You Get That Query Plan From? (And Why It Matters) series. We'll finish by talking about DMVs and Query Store and then bring everything together.
#sqlserver #queryplan #executionplan #performancetuning #querystore #dmvs
SQL Server execution planning explained with a simple architect analogy. See how Parsing, Compilation and Optimization work. Great for anyone wanting clear SQL Server internals.
youtu.be/bKhPq_Z5GdQ
#SQLServer, #ExecutionPlan, #SQLChallenges
youtu.be/bKhPq_Z5GdQ
#SQLServer, #ExecutionPlan, #SQLChallenges
SQL Server Execution Planning
YouTube video by Uwe Ricken
youtu.be
August 25, 2026 at 6:36 AM
SQL Server execution planning explained with a simple architect analogy. See how Parsing, Compilation and Optimization work. Great for anyone wanting clear SQL Server internals.
youtu.be/bKhPq_Z5GdQ
#SQLServer, #ExecutionPlan, #SQLChallenges
youtu.be/bKhPq_Z5GdQ
#SQLServer, #ExecutionPlan, #SQLChallenges
You don't need an operations consultant for small business forever. You need 90 focused days to install the system, then hand it off. Here's what a real 90 day execution plan builds, week by week: https://minis.page/exec-90day
#90DayPlan #ExecutionPlan #FractionalCOO #KamyarShah #WCG #VWCG
#90DayPlan #ExecutionPlan #FractionalCOO #KamyarShah #WCG #VWCG
August 2, 2026 at 4:03 PM
You don't need an operations consultant for small business forever. You need 90 focused days to install the system, then hand it off. Here's what a real 90 day execution plan builds, week by week: https://minis.page/exec-90day
#90DayPlan #ExecutionPlan #FractionalCOO #KamyarShah #WCG #VWCG
#90DayPlan #ExecutionPlan #FractionalCOO #KamyarShah #WCG #VWCG
“Why SQLite Uses Bytecode”, D. Richard Hipp (sqlite.org/draft/whybyt...).
On HN: news.ycombinator.com/item?id=4020...
On Lobsters: lobste.rs/s/g2tl3w/why...
#SQLite #Databases #Compiler #AST #Bytecode #VirtualMachine #Parsing #QueryOptimization #ExecutionPlan #SQL
On HN: news.ycombinator.com/item?id=4020...
On Lobsters: lobste.rs/s/g2tl3w/why...
#SQLite #Databases #Compiler #AST #Bytecode #VirtualMachine #Parsing #QueryOptimization #ExecutionPlan #SQL
Why SQLite Uses Bytecode
8 comments
lobste.rs
May 1, 2024 at 1:32 PM
“Why SQLite Uses Bytecode”, D. Richard Hipp (sqlite.org/draft/whybyt...).
On HN: news.ycombinator.com/item?id=4020...
On Lobsters: lobste.rs/s/g2tl3w/why...
#SQLite #Databases #Compiler #AST #Bytecode #VirtualMachine #Parsing #QueryOptimization #ExecutionPlan #SQL
On HN: news.ycombinator.com/item?id=4020...
On Lobsters: lobste.rs/s/g2tl3w/why...
#SQLite #Databases #Compiler #AST #Bytecode #VirtualMachine #Parsing #QueryOptimization #ExecutionPlan #SQL
Feed: "Effect Documentation | Blog"
Published on Wednesday, May 28, 2025
Published on Wednesday, May 28, 2025
Effect 3.16 (Release)
New Effect release featuring the new ExecutionPlan module, Effect.Service & LayerMap improvements, and more!
effect.website
May 28, 2025 at 5:24 AM
Feed: "Effect Documentation | Blog"
Published on Wednesday, May 28, 2025
Published on Wednesday, May 28, 2025
Strategise
#StrategyGoals #PlanningAhead #BusinessStrategies #MarketingTactics #StrategizeSuccess #GrowthStrategy #RevenueGeneration #ExecutionPlan #CompetitiveAdvantage #EffectivePlanning #MarketAnalysis #StrategicThinking #InnovationStrategy #BusinessDevelopment #GoalSetting
#StrategyGoals #PlanningAhead #BusinessStrategies #MarketingTactics #StrategizeSuccess #GrowthStrategy #RevenueGeneration #ExecutionPlan #CompetitiveAdvantage #EffectivePlanning #MarketAnalysis #StrategicThinking #InnovationStrategy #BusinessDevelopment #GoalSetting
May 29, 2026 at 12:01 PM
The abort is asynchronous. So the streams and plans would have dropped cleanly, but the tasks may continue running until they yield and then until their drop completes. So there’s a delay in “query cancelled” (ExecutionPlan dropped) vs “all memory held by the query is freed”.
May 18, 2026 at 12:00 PM
The abort is asynchronous. So the streams and plans would have dropped cleanly, but the tasks may continue running until they yield and then until their drop completes. So there’s a delay in “query cancelled” (ExecutionPlan dropped) vs “all memory held by the query is freed”.