SQLServerPedia SQL Server Training (Apple iTunes Video)

Using Perfmon and Profiler

Brent Ozar — Tue, 09 Feb 2010 12:30:22 +0000

At the SQLBits conference in Great Britain last fall, Brent Ozar gave a presentation called “Using Perfmon and Profiler.” He covered:

Why Windows Task Manager is nothing more than a check-engine light
His performance tuning lifecycle
Why you need to capture baselines (and how to do it)
Several sample tuning scenarios

You can watch this 52-minute presentation free courtesy of SQLBits:

[See post to watch Flash video]

If you liked this presentation, you can watch any of the SQLBits presentations at their web site, including:

Subscribing or Downloading the Podcast

If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:

You can also download this video to watch it later:

SQL Server Performance Tuning, Formula 1 Style

Brent Ozar — Tue, 02 Feb 2010 12:45:47 +0000

At the SQLBits conference in Great Britain last fall, Brent Ozar gave a presentation called “T-SQL Tuning with Colin Chapman, Enzo Ferrari, and The Stig.” He covered:

Why Colin Chapman would check for indexes before adding new ones
The importance of well-tested safety gear to performance tuning
Why not monitoring your servers is like overdriving your headlights
Just like races are lost in the pits, uptime records are lost during maintenance windows

You can watch this 41-minute presentation free courtesy of SQLBits:

[See post to watch Flash video]

If you liked this presentation, you can watch any of the SQLBits presentations at their web site, including:

Subscribing or Downloading the Podcast

If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:

You can also download this video to watch it later:

SQL Server in the Cloud Podcast Part 2

Brent Ozar — Wed, 09 Dec 2009 12:30:44 +0000

At the PASS Summit in Seattle, SQL Server in the cloud got a lot of buzz. In this five-minute video, Brent Ozar gives you the answers you need when your developers and managers start asking questions.

[See post to watch Flash video]

For more information about SQL Server in the cloud, check out these links:

Subscribing or Downloading the Podcast

If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:

You can also download this video to watch it later:

Want to Guest Podcast at SQLServerPedia?

We’d love to host your guest podcasts! Email Editor-in-Chief Brent.Ozar@Quest.com and he’ll help you get started with recording your own presentation. We’ll host them at SQLServerPedia, and you can also host them on your own site. We don’t need exclusive rights to the podcast.

SQL Server in the Cloud Podcast

Brent Ozar — Wed, 02 Dec 2009 17:30:40 +0000

At the PASS Summit in Seattle, SQL Server in the cloud got a lot of buzz. In this five-minute video, Brent Ozar explains the two main options for SQL in the cloud – real SQL Server, and the instant coffee version.

[See post to watch Flash video]

For more information about SQL Server in the cloud, check out these links:

Subscribing or Downloading the Podcast

If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:

You can also download this video to watch it later:

Want to Guest Podcast at SQLServerPedia?

Tom LaRock on Monitoring

Brent Ozar — Mon, 07 Sep 2009 12:00:01 +0000

Tom LaRock (Blog – Twitter) is a man of many hats: he’s a SQLServerPedia Editor, a PASS Board of Directors member, a Microsoft SQL Server MVP, and much more.Brent Ozar interviewed him at Quest’s headquarters about monitoring – what people should focus on monitoring, and what he wishes he would have known when he got started as a DBA.

[See post to watch Flash video]

Subscribing or Downloading the Podcast

If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:

You can also download this video to watch it later:

Want to Guest Podcast at SQLServerPedia?

Tom LaRock on Blogging

Brent Ozar — Mon, 31 Aug 2009 12:00:47 +0000

Tom LaRock (Blog – Twitter) is a man of many hats: he’s a SQLServerPedia Editor, a PASS Board of Directors member, a Microsoft SQL Server MVP, and much more.Brent Ozar interviewed him at Quest’s headquarters about how he got started blogging and what he gets out of it.

[See post to watch Flash video]

Subscribing or Downloading the Podcast

If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:

You can also download this video to watch it later:

Want to Guest Podcast at SQLServerPedia?

SQL Server 2008 R2 Utility Demo

Brent Ozar — Mon, 17 Aug 2009 13:00:47 +0000

Microsoft SQL Server 2008 R2’s biggest new feature for production database administrators is the SQL Server Utility: a new way of managing databases as Data-Tier Applications (DACs). Brent Ozar shows how it works in today’s 20-minute video podcast.

[See post to watch Flash video]

For more information about SQL Server 2008 R2’s Utility features, check out these posts by Brent Ozar:

Subscribing or Downloading the Podcast

If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:

You can also download this video to watch it later:

Want to Guest Podcast at SQLServerPedia?

Tom LaRock on Meet the Experts

Brent Ozar — Tue, 11 Aug 2009 13:30:17 +0000

Tom LaRock (Blog – Twitter) is a man of many hats: he’s a SQLServerPedia Editor, a PASS Board of Directors member, a Microsoft SQL Server MVP, and much more. Christian Hasker interviewed him at Quest’s headquarters to find out more about the SQL Rockstar.

[See post to watch Flash video]

Subscribing or Downloading the Podcast

If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:

You can also download this video to watch it later:

Want to Guest Podcast at SQLServerPedia?

Guest Podcast: Auditing Your Database Server

Brent Ozar — Thu, 06 Aug 2009 17:11:38 +0000

Colin Stasiuk (Blog – Twitter) is our guest podcaster today, and he covers the options available to audit your database server. He starts by explaining the different auditing solutions we’ve had in the past, and then dives into SQL Server 2008’s new auditing functionality.

[See post to watch Flash video]

For more about auditing topics, check out these wiki articles:

Subscribing or Downloading the Podcast

If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:

You can also download this video to watch it later:

Want to Guest Podcast at SQLServerPedia?

Resource Governor Basics

Brent Ozar — Thu, 16 Jul 2009 14:30:31 +0000

In very large databases, ad-hoc user queries can easily run on for minutes or hours. Patient users often kick off long reporting queries and then walk off to get coffee while their queries run on endlessly. We call these queries zombies. Your weapon against the zombies is the Resource Governor, new in SQL 2008. Learn how to use the shovel in this video.

[See post to watch Flash video]

For more about the Resource Governor and other VLDB tips, check out our Very Large Databases wiki article.

Subscribing or Downloading the Podcast

If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:

You can also download this video to watch it later: