Geoffrey Grosenbach sits down with Pinal Dave to see what a SQL Server Admin does in the real world. This Play-by-Play will focus on SQL Server performance tuning. Pinal goes over optimizing queries and fine-tuning the server.
Introduction [Autogenerated] I'm Jeffrey Gerson Buck and its play by Play It Plural site. Every year we gather our authors in Salt Lake City for annual author Summit Panel. Davey flew all the way from India, where he's not only a popular developer but also runs one of the most traffic blog's of any kind in India. This play by play project was slightly different for most. And to be honest, I was a bit skeptical at the beginning, since I haven't used sequel server in a decade, panel brought a project of his own to start with. Fortunately, it ended up being a perfect fit because it went in a few unexpected directions and gave been all a chance to think through several ways to optimize queries and fine tune the server. And he even tries to stump me a few times, watch to see how well he succeeds. The play by play Siri's is one where we give you a rare view into the work flows and thought processes of top ad mons developers and designers. Have you ever wished you could watch one of your tech heroes work on a project on their own time, using their own tools at their natural speed, not a rehearsed presentation or prepared course, but planning and problem solving. As it happens in the real world every day, that's what we do in this series. We give talented add mons developers and designers a test to work on live and unrehearsed for about two hours. We talk through architecture decisions and fix unexpected problems. This isn't a tutorial. We won't pause to explain or stopped to tell you how to set up server infrastructure or a development environment, but you will see how professionals use tools in their everyday environments.