>_
databases · code · the space between
Richie Rump
is a dataveloper.
Wedged happily between application code and the database, building tools that shine a light into the dark corners of your data.
SELECT * FROM Jorriss;
— currently building toolingStatisticsParser.comPasteThePlan.comStatistics Parser SSMS Extensionsp_DataProfile
// latest writing
Notes from the query planner.
-
★ FEATURED
Outwit, Outplay, Outlast: GUIDs as Primary Keys in 2026
read the post →: Outwit, Outplay, Outlast: GUIDs as Primary Keys in 2026I’ve had the unique opportunity recently to talk with a few different companies about their technical challenges. During one of those conversations, GUIDs as primary keys came up. I wasn’t really prepared to speak at length about it at the moment but I think I mentioned that the primary key defaults to the clustered key…
-
Common Entity Framework Problems: N + 1
I wanna dance with common problems One of the most common issues that I’ve seen with Entity Framework isn’t technically an Entity Framework problem at all. The N + 1 problem is an anti-pattern that is a problem with ORMs in general, which most often occurs with lazy loading. There was a lot going on…
-
Updating Paste The Plan to use the Serverless Framework
I just updated PasteThePlan, and the change you’ll notice first is that we’re using the latest version of Justin Pealing’s html-query-plan. It adds missing index hints, yellow bangs for warnings like implicit conversions and no join predicate, and more. Check out this example plan: Plus variable line widths for different amounts of data: One of…
-
Paste The Plan…Now With Comments
You didn’t ask but we listened: we have added comments to Paste The Plan. We’re always looking for way we can improve the tools that we provide to the community. One of the things we always thought that would be nifty was to add comments to the plans. So while we were finishing up the…
// about
All developer, all data, all Jorriss
I’m Richie Rump, though most of the internet knows me as Jorriss. I’ve spent my career in that weird, wonderful seam where application code meets the data layer, building tools, tuning queries, and untangling the systems everyone else is a little afraid to touch.
This is where I write it all down: the war stories, the sharp edges, and the occasional 2 a.m. epiphany.