« July 2008 | Main | September 2008 »

New Video: Troubleshooting SQL Server 2005 and 2008 Maintenance Plans

Just a handful of additional videos to tackle in my series on backups, and then I'll move on to some other topics. But if you're interested in learning about how to turn on additional logging and reporting with your SQL Server 2005 and 2008 databases (using SQL Server 2008), then make sure to check out this video.

Watch

Video Length: 09:14
Video Summary: Learn about built-in logging and reporting options that will help make troubleshooting problems with SQL Server 2005 and 2008 Maintenance Plans much easier to deal with.



New Video: SQL Server Maintenance Plans with SSMS

Yeaaay - with this latest release, SQLServerVideos.com now has 2.5 hours of totally free video training and content. Most of the content is currently focused on backups, but once I create a few more videos in that series, I'll move on to a couple of other angles such as how to copy and move databases, what's new in SQL Server 2008, and possibly even 'basic T-SQL skills'.

Otherwise, check out this new video to learn how to create SQL Server 2005 and 2008 Maintenance plans using SQL Server Management Studio.

Watch

Video Length: 11:01
Video Summary: In this how-to video you'll learn about creating SQL Server Maintenance plans as part of creating a viable disaster recovery plan for SQL Server 2005 and 2008 databases. In addition, you'll also learn about commonly encountered problems and best practices when it comes to configuring maintenance plans for backup purposes.



New Video: Maintenance Plans with Enterprise Manager

I've just uploaded all of the files for a new video - which will show you how to to create SQL Server Maintenance plans using SQL Server Enterprise Manager. Next week I'll release a few more videos on backups (one for Maintenance Plans with SQL Server Management Studio, and a few on troubleshooting and restoring/recovery), then I'll probably start working on a new series as I keep working on completing the series on backups.

 

Watch

Video Length: 10:43
Video Summary: In this how-to video you'll learn about creating SQL Server Maintenance plans as part of creating a viable disaster recovery plan. In addition, you'll also learn about commonly encountered problems and best practices when it comes to configuring maintenance plans for backup purposes.



SQL Server 2008 Installation - it's the 'little' things...

There are lots of great things to be excited about when it comes to SQL Server 2008. (And shortly after completing my series on SQL Server Backups, I'll create a whole series detailing new features and benefits.)

But in terms of installation and configuration there are some really great, yet very minor, additions/changes that will largely go un-heralded in other blog posts and articles.

One of those changes is that the installer will remind you to punch appropriate holes in your firewall.

SS2008_Firewall

It's not like you won't remember to do that anyhow... but if you're like me (and do lots of SQL Server installations on virtual machines) you'll find that reminder up-front to be nice as you'll be able to go and toggle the firewall open while the installation is proceeding - instead of waiting until right-before you get ready to connect from an external machine.

The other, bigger, benefit? That horrible, horrible hack called the SQL Server Surface Area Configuration Manager is now GONE. (I always detested how managing security infrastructure and options for SQL Server required another, external (and not to mention insanely slow/sluggish) tool. Now, once you're done with a SQL Server 2008 installation, you're greeted with a much nicer conclusion that doesn't require you to jump through a bunch of hoops:

SS2008_completed



New Video: SQL Server Backup Best Practices

I'm happy to announce a new video on the site - that now brings the total content on SQLServerVideos.com up to just over 2 hours worth of tutorials and videos. And, as you can guess from the title of this video, it's all about SQL Server Backup best practices and the role of disaster recovery plans.

Watch

Video Length: 12:30
Video Summary: Creating a viable disaster recovery plan for your SQL Server databases can be tricky. In this SQL Server Video, we'll therefore look at core components that every disaster recovery plan needs, along with common mis-steps and best practices that will help ensure minimal data loss in the case of a crash or disaster.



Conceptual vs How-To Videos

I've been doing a bit of thinking.

And while I think that it's important to make a distinction between How-To videos and Conceptual Videos (so that people who understand the concepts won't have to be bogged down by learning the 'basics'), I'm starting to wonder if I don't have a FEW too many conceptual videos on the site.

Sure, they'll be great resources for anyone who's completely NEW to backups (for example), but I think that with videos, most people really just want to jump into the 'How-To' content.

So... with subsequent series, I'll skew the focus more towards How-To content and try to keep the conceptual content to a minimum.



New Release: Extra-Wide Covering Indexes

I'm happy to announce SSV's first 'guru' level video. In terms of Guru videos, I'm pretty sure that non-gurus will be able to watch these videos and learn from them, but the implication with them is that most of the nuances and some of the caveats that I would throw out or mention in 'lower level' videos are simply not there. As such, all that's left is a concise video covering advanced topics. And, in this case, this video is designed to teach viewers how to overcome the 900 byte limit for indexes in SQL Server.

Watch

Video Length: 08:11
Video Summary: SQL Server indexes are constrained to a maximum width of 900 bytes. In this video you'll learn how to get around that limit using T-SQL in order to create indexes that can be used for a wide variety of performance purposes - including 'extra wide' covering indexes.



New Release: Backups with SQL Server Management Studio

Sorry this one took so long to post as a new release, but I just got swamped with a few big issues today (despite the fact that the video was done and uploaded on to the site yesterday).

At any rate, this video helps you learn the ins and outs of manually executing backups for SQL Server 2005 and 2008 databases using SQL Server Management Studio.

Enjoy!

Watch

Video Length: 10:06
Video Summary: In this short how-to video, you'll learn how to manually backup SQL Server 2005 and 2008 databases using SQL Server Management Studio. You'll also learn about backup retention periods and learn how to use, initialize, protect, and overwrite SQL Server Media sets.



New Release: Backups with Enterprise Manager

Here's a new how-to video showing how to manually create backups using SQL Server Enterprise Manager. (A similar video for SQL Server Management Studio will be up on the site shortly...)

 

Watch

 

Video Length: 09:31   
Video Summary: In this short how-to video you'll learn the ins and outs of manually backing up databases using SQL Server Enterprise Manager. You'll also learn about backup retention periods and learn how to use, initialize, protect, and overwrite SQL Server Media sets.



New Video: Understanding Backup Options

Learn about backup types, execution options, storage locations, and other options in order to best address your backup and recovery needs.

Watch

Video Length: 13:02
Video Summary: Backups can become rather complex - when you start to account for all of the options. In this video you'll get a great overview of the backup types, tools, execution methods, storage locations, and other options that will help you understand SQL Server backup options.