In this single video, Rob Sullivan is tasked with perf-tuning an ASP.NET MVC 3 web application (using EF) so it can handle a StackOverflow data dump. Over 4 million rows of data in the Posts table alone! The application is one that any web developer might build - with holes in it that any developer might fall into. The site is timing out, we're down - we need some help from an amazing DBA!
Rob is a bona fide Alpha Nerd. He is the Senior Data Magistrate for the government in the Prism division where he specializes in data collection and data profiling.
When he isn’t lording over AppDevs and Architects, he can be found truncating vast amounts of pizza, ETLing burritos and breaking down the execution plans of video games.
Introduction [Autogenerated] I'm Rob Connery and welcome to play by play here at Portal site. Our play by Play productions put you in a chair right next to an expert in the field so you can see how they get their work done when confronted with a singular problem or task. These productions air free form an uncut, and we try not to spend much time on explanations. We go full throttle to get the problem solved. The goal of these courses is for you to see how experienced coders solve problems, tools they use and how they think about software development. This differs from a typical, more structured course of coral site, but we think you'll enjoy the less structured, more informal setting. This material can be relatively advanced at times, and we may not slow down to explain ourselves. So I encourage you to stop and re watch the video. If you find yourself getting lost in this our first full throttle episode, I sit down with Rob Sullivan with Crack D B A. Who has a rather tough problem to solve. We've given him a day to drop from the Stack overflow database and prepared a typical starter site using SP dot net MVC and Entity Framework Code first from Microsoft. The code, as written is pretty much what you would find in any SP dot net, NBC website. But we have a problem. Our site has grown so quickly have millions and millions and millions of rows of data in our database. Our queries air started to choke. We're getting time outs everywhere we need to perfect in our database and our website So he wouldn't hired ourselves a d b a for the day. And that's Rob. Let's see what he can do with this mountain of data being choked through Entity Framework using sequel server and ESPN on at NBC three.