// the blog
Notes from the query planner
-
Common Entity Framework Problems: N + 1
Continue reading →: 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
Continue reading →: Updating Paste The Plan to use the Serverless FrameworkI 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
Continue reading →: Paste The Plan…Now With CommentsYou 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
Continue reading →: PasteThePlan October 2017 UpdateWe’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,…
-
The Case of Entity Framework Core’s Odd SQL
Continue reading →: The Case of Entity Framework Core’s Odd SQLRecently, Julie Lerman contacted me about some strange SQL that Entity Framework Core (EF Core) was generating. Now, EF Core is fairly new and works with Microsoft’s newest framework .NET Core. I haven’t had a chance to get my hands on EF Core yet so I was excited to see what it was doing. And of course…
-
Serverless in a Conference?
Continue reading →: Serverless in a Conference?I just spent the last few days in Austin for a conference on Serverless computing. If you don’t know, Serverless is the horrific marketing term for Functions as a Service. It’s basically a way to run code in the cloud where the server and runtime is managed for you’re only charged for the time the…
-
Lessons Learned From Working in the Clouds
Continue reading →: Lessons Learned From Working in the CloudsRecently, we released PasteThePlan.com, which runs on top of Amazon Web Services. PasteThePlan.com allows you to share SQL Server query plans with others. Behind the scenes, we’re using DynamoDB (a NoSQL database) for record data and S3 (a file storage service) to store text data. Since we’re a bunch of data freaks, we wanted to make sure…
-
How to Select Specific Columns in an Entity Framework Query
Continue reading →: How to Select Specific Columns in an Entity Framework QueryOne 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…
-
The Open Source Tools of Paste The Plan
Continue reading →: The Open Source Tools of Paste The PlanIf 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…
-
How We Architected Paste The Plan
Continue reading →: How We Architected Paste The PlanIf you’ve ever heard the Away From the Keyboard, a podcast that I co-host with Cecil Phillip, you’ll quickly discover that I love hearing stories about how products are created. Now I get to tell you the story of how Paste The Plan became real and the architecture around it. In a world… Here at Brent Ozar…
