Live classes start in 4d 13h 52m — Save your seat

Author: Richie Rump

I'm the resident code monkey at Brent Ozar Unlimited. I create tools that help identify issues in both applications and in databases. I often describe myself as a dataveloper, comfortable working with code and databases. When I’m off the clock I lead the dotNet Miami user group, co-host the Away From The Keyboard podcast, speak at various technical conferences around the country, assemble large Lego sets, and play copious amounts of board games.
T-SQL & Development

Common Entity Framework Problems: N + 1

July 30, 2018

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 in that paragraph, so let's break it down.

Read more about Common Entity Framework Problems: N + 1 23 comments — Join the discussion

Updating Paste The Plan to use the Serverless Framework

June 18, 2018

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:

Read more about Updating Paste The Plan to use the Serverless Framework 4 comments — Join the discussion

How to Select Specific Columns in an Entity Framework Query

September 21, 2016

One of the most frequent complaints that I hear when presenting to DBAs about Entity Framework is that it's "slow" and that "developers should be endlessly tortured for using it". Ok, the second part I just made up but the sentiment exists. DBAs just don't like developers using Entity Framework and with good reason. Entity Framework can make…

Read more about How to Select Specific Columns in an Entity Framework Query 42 comments — Join the discussion

The Open Source Tools of Paste The Plan

September 15, 2016

If you couldn't tell, we're big fans of open source software. We like it so much that we recently released our First Responder Kit, including sp_Blitz, under the MIT license. So when we were building Paste The Plan, our free tool to share SQL Server execution plans, there was no question that we were going to use a bunch of open source software. Here's the rundown of which open source tools we used and why we chose it.

Read more about The Open Source Tools of Paste The Plan 8 comments — Join the discussion