>_
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
Common Entity Framework Problems: N + 1
read the post →: Common Entity Framework Problems: N + 1I 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…
-
PasteThePlan October 2017 Update
We’re back at it again. We took a bit of time out of our busy schedule to put in a few enhancements into PasteThePlan.com. Here’s some of the highlights: Updated to the latest version of HTML Query Plan. In order to create a graphical query plan we use Justin Pealing’s awesome HTML Query Plan. Recently,…
// about
All developer, all data, all Jorriss
I’m Richie Rump — 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.