Play by Play: SQL Server Administration with Pinal Dave

Pinal Dave discusses real-world SQL Server performance tuning and query optimization.
Course info
Rating
(239)
Level
Advanced
Updated
Jun 20, 2014
Duration
1h 43m
Table of contents
Description
Course info
Rating
(239)
Level
Advanced
Updated
Jun 20, 2014
Duration
1h 43m
Description

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.

About the author
About the author

Pinal Dave is a Pluralsight Developer Evangelist.

More from the author
More courses by Pinal Dave
About the author

Geoffrey founded PeepCode and has created numerous courses on Ruby, JavaScript and Shell.

More from the author
Play by Play: React and Falcor with Brian Holt
Intermediate
1h 51m
Oct 15, 2015
More courses by Geoffrey Grosenbach
Section Introduction Transcripts
Section Introduction Transcripts

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.