SQLServerPedia SQL Server Training (MP3 Audio Only)

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:

Data Mining Basics with Tom LaRock

Brent Ozar — Mon, 29 Jun 2009 15:45:34 +0000

We’ve talked about data mining the StackOverflow database dump before, but today we’re going to start from the very beginning. In this half-hour video, Tom LaRock and Brent Ozar talk about what data mining is, and show some examples using the StackOverflow database.

[See post to watch Flash video]

For more about importing the StackOverflow database export and working with it, check out our articles on data mining the StackOverflow database dump.

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 Management Studio Express

Brent Ozar — Fri, 29 May 2009 20:07:57 +0000

Get started managing your SQL Server Express Edition and developing T-SQL with Microsoft’s free SQL Server Management Studio Express Edition. Learn how from Brent Ozar and Jeremiah Peschka.

[See post to watch Flash video]

For more about this topic, check out:

The SQL Server Express Edition wiki article
Jeremiah Peschka’s article on Row-Based Security
Jeremiah Peschka’s blog at Facility9 – where he blogs about SQL Server from a developer’s point of view
Microsoft SQL Server Express Edition – the product page at Microsoft.

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 Express Edition

Brent Ozar — Wed, 27 May 2009 14:42:42 +0000

SQL Server is free! The Express Edition, that is. In today’s webcast, Brent Ozar and Jeremiah Peschka explain the pros and cons of this free SQL Server edition.

[See post to watch Flash video]

For more about this topic, check out:

The SQL Server Express Edition wiki article
Jeremiah Peschka’s article on Row-Based Security
Jeremiah Peschka’s blog at Facility9 – where he blogs about SQL Server from a developer’s point of view
Microsoft SQL Server Express Edition – the product page at Microsoft.

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:

CMDB Part 2 – The SQL Server 2008 CMS

Brent Ozar — Mon, 04 May 2009 17:30:36 +0000

Rather than building a full-blown CMDB from scratch, Brent explains how you can get started with SQL 2008’s Central Management Server to get a mini-CMDB going.

[See post to watch Flash video]

For more about building a CMDB, check out the CMDB tutorial wiki article. We’ve got sample scripts you can use, and instructions on how to get the result data into a database for easier reporting. In the podcast, we also talk about our hour-long free CMDB tutorial webcast, which you can register for and watch the replay.

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:

CMDB Part 1 – What It Is

Brent Ozar — Thu, 30 Apr 2009 17:30:13 +0000

Configuration Management Databases are an enterprise-quality way of gathering a lot of IT and business information in one place – but how much do DBAs really need?

[See post to watch Flash video]

For more about building a CMDB, check out the CMDB tutorial wiki article. We’ve got sample scripts you can use, and instructions on how to get the result data into a database for easier reporting.

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: