SQLServerPedia SQL Server Training (MP3 Audio Only)

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?

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.

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:

SQL Server VLDB Partitioning Tutorial

Brent Ozar — Tue, 14 Jul 2009 14:30:56 +0000

Tables with hundreds of millions of rows or billions of rows need a way to manage that data easier. SQL Server 2005 introduced partitioning, and it’s been improved ever since. Learn about how to implement it in this ten-minute training video.

[See post to watch Flash video]

For more about SQL Server table partitioning 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:

VLDBs and Instant File Initialization

Brent Ozar — Thu, 09 Jul 2009 14:30:02 +0000

Very Large Databases (VLDBs) come with their own unique set of management challenges. In this podcast, Brent Ozar talks about a simple problem: managing file growth when your files are hundreds of gigabytes or larger.

[See post to watch Flash video]

For more about Instant File Initialization 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:

Kevin Kline Tutorial on SQL Server Query Tuning

Brent Ozar — Thu, 02 Jul 2009 14:00:13 +0000

Kevin Kline gave an hour-long presentation to the Nashville PASS Chapter on Query Performance Tuning. He covered tips like NOCOUNT, SHOWPLAN, STATISTICS, and low-hanging fruit to make queries faster.

[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:

Google Reader Tutorial Video

Brent Ozar — Tue, 30 Jun 2009 14:21:49 +0000

Google Reader is an RSS reader tool that helps you stay in touch with more web sites in less time. It consolidates new articles from sites all over the web in one single, easy-to-use interface, and helps you share your favorite articles with your friends. Brent Ozar explains Google Reader this four minute video tutorial.

[See post to watch Flash video]

In the videos, Brent talks about these sites:

Google Reader – the online RSS reader tool.
Brent’s Shared Google Reader items – if you want to get notified of his favorite SQL Server blog posts.
AideRSS PostRank – the best/great/good filtering plugin for Reader that helps you catch up with the most popular blog entries quickly.
URLFan – find out when other people mention your blog or link to it.
Search.Twitter.com – find out when anyone mentions your name or your site’s name on Twitter.

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: