Worthwhile SQL Server Blogs

Not sure what my deal is, but I subscribe to tons of SQL Server blogs, yet actually read very few. Actually, probably part of why I don't blog too much on my own is that it seems like so much about SQL Server is already covered. And, sadly, many blog posts out there are commonly just a re-hash of things that have already been covered (to some degree or another). Obviously, there are some big exceptions, and so on.

But over the past few months I've really noticed that I've enjoyed two blogs on a very consistent basis, so I thought I'd send out links to them as well.

The Rambling DBA
Haven't quite figured out why, but Jonathan's blog posts at The Rambling DBA almost always get my full attention. He's usually writing about great topics that seem to be aligned with things I'm frequently working on or with. So make sure to check out his blog (though he's apparently been called up to active duty – so get him before his… hiatus kicks in).

Brian Egler's SQL Server Strategies
I've been keeping an eye on Brian's posts at his SQL Server Strategies blog for quite a while now. He occasionally hits… drier spells where there isn't as much coming from his spoutlet, but whenever something comes out, it's almost always awesome. That, and he's really been on a kick lately – with a definite up-tick in the amount posts of late.

My Blog?
And.. for those of you wondering what's up with my blog here? I'll let you know when I get it figured out. ;)

Largely (i.e., my excuse), I've just been swamped with a couple of big projects, some well-earned vacation this summer, and preparing for 3 hours of kick-ass content for my upcoming Power-Up with SQL Server presentations. So… my goal is to start blogging a bit more here and there over the next few weeks, and then by mid September I'm also hoping to get started on a couple new serieseseses (wish there was a clean way to pluralize the word series) of videos.

Site Updates

About a week ago I made some minor changes to the site – in terms of video playback. Specifically, I changed playback to include a new set of controls that should make it much easier to pause/resume videos, as well as fast-forward and rewind on-demand.

I'll be adding a few other minor changes over the next week or so, and then I'm planning on going silent for a week or two as I create a handful of new videos.

So stay tuned…

Site Update

It’s been a while since I’ve done anything with the site. (And that’s a long story, but I plan on rectifying that here in a while.)

But Today I stepped things up a tiny bit and deployed a new version of the site that should make management and extensibility much easier in the future.

Watch for new videos in a week or two. (This time for realz.)

Check out the site/changes by clicking here.

Comments Busted on SSV

UPDATE: Looks like comments weren't busted. Or, at least, they only appear to be busted for idiot spammers.

So... I figured it was just that no one had anything to say. But it turns out that comments on SSV are busted - worksMyMachine2 at least from updates.sqlservervideos.com over to www.sqlservervideos.com. Which is too bad - as I spent a lot of time making that spiffy and functional.

Even worse, I've tested it numerous times, and had a couple buddies test it as well. But after wondering about why NO one was posting (including attempts by spammers), I threw some instrumentation up against my comment posting logic, and every once in a while I'm strangely logging 404s when people are trying to post. And, happily (for my ego) that's been occurring with increased frequency of late.

So... if you're one of the people that's tried to comment recently, sorry for the hassle, and I'll try looking into troubleshooting what's up shortly.

For those that care: Part of the problem is that the updates/blog part of SSV is hosted at type-pad, and rather than use their comment engine for posts about new releases/videos, I'm actually posting comments from those entries to ssv.com in order to keep all comments about each video in a central location. Apparently something went wrong with that. (Though, posts like this one, which aren't related to a video, are just handled by TypePad and are working fine.)

Upcoming Videos

With my series on Backups mostly complete, here's a sneak peak at the videos that I plan on producing next, in roughly the order that I plan to work on them:

Copying and Moving SQL Server Databases (a new series)

  • Overview of Copying and Moving Databases
  • Moving Databases by Detaching and Attaching
  • Moving Databases by Backing-up and Restoring
  • Handling Login/Security Concerns after Moving Databases

What's New in SQL Server 2008 (another new series)

  • Introduction to SQL Server 2008
  • Changes to SQL Server Management Studio 2008
  • Depricated and Obsolete
  • Upgrading to SQL Server 2008
  • Expanded Data Types (datetime2, etc.)
  • Spatial Data Types
  • Hierarchical Data Types
  • T-SQL Improvements
  • FILESTREAM operations
  • etc.

SQL Server Backups (some additions to the existing backup series)

  • Backing up databases with T-SQL
  • Recovering databases with T-SQL
  • Third Party Backup Solutions
  • Speeding up Backup and Restore Operations


Creating these should keep me busy for a while, but I've already got a good start on the new Copying and Moving databases series. (I'm probably going to release them probably as a group as the first video will be very short, and won't be much good without the other videos.)

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.