« October 2008 | Main | January 2009 »

New Video: SQL Server Management Studio 2008

I'm happy to announce SSV's 26th "SQL Server Video" which focuses on SQL Server Management Studio 2008. It's a bit of a fast-paced walkthrough that covers about 95% of all of the new additions and features added in SQL Server Management Studio 2008.

In future videos I'll look at tackling the new date/time data types, and issues and concerns surrounding upgrading to SQL Server 2008 along with ways to determine what kind of impact obsolete and depricated features from previous versions will have on your environment. Until then, make sure to watch this latest video to learn about new additions and features of SQL Server Management Studio 2008.

Watch

Video Length: 10:59
Video Summary: In this video you'll learn about new connection management features, the Object Explorer Details Window, IntelliSense, Debugging options, and ways to change and modify new SQL Server Management Studio 2008 options and preferences.



New Video: Introducing SQL Server 2008

I'm very excited to release a new video in SSV's fourth and latest Series: What's New in SQL Server 2008. And, while this first release is mostly fluff (well, it's GOOD stuff if you've been living under a rock and have no idea what's new in SQL Server 2008 - but it's all slides and no hands-on content), I've got a couple of follow-up videos planned.

Likewise, the goal of this, and all other, SQLServerVideos is to try and condense as much useful stuff into a small amount of time as makes sense. So this video works as a bit of a whirlwind that will provide a high-level overview of what's new in SQL Server 2008 for developers, dbas, analysts, and anyone using SQL Server 2008.

Watch

Video Length: 10:02
Video Summary: Curious about what SQL Server 2008 offers? Is there anything for you? Well, SQL Server 2008 provides tons of new features, functionality, and benefits and by watching this video you'll get an idea of some of the major new changes and improvements that will apply to you as well as get a feel for how the other videos in this series will play out.



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.)



New Video: Copying and Moving SQL Server Logins

One of the things that makes copying and moving SQL Server databases a bit hard to handle is the fact that moving them typically also requires that you move logins from one server to another - and make sure that they're remapped as needed.

In this vidoe, you'll learn how to transfer and re-map SQL Server Logins from one server to another, and see how to enumerate and troubleshoot logins against assigned users and roles within SQL Server databases.

Watch

Video Length: 10:12
Video Summary: The final step in moving and copying SQL Server Databases is to make sure that your Logins are successfully mapped to database users and roles. In this video you'll therefore see what makes this requirement necessary and watch a step-by-step walkthrough of exactly what you need to do to ensure proper mappings between SQL Server Logins and database users and roles.



New Video: Copying and Moving SQL Server Databases

If you're looking for an easy way to copy and move SQL Server databases, then it doesn't get much better than using backups - even though that may sound a bit counter-intuitive if you're not very familiar with SQL Server.

So check out this video to learn how to easily copy and move your SQL Server 2005 and 2008 databases using backups - which is much easier than you might think.

Watch

Video Length: 10:22
Video Summary: Copying and moving SQL Server databases with backups may sound a bit intimidating if you're not familiar with SQL Server. But in this video you'll learn how backups provide one of the easiest ways to move or copy your databases by watching a step-by-step tutorial that shows you exactly what you need to do.



New Video: Attaching and Detaching SQL Server Databases

Learn the exact steps you'll need to take to successfully detach and attach SQL Server 2005 and 2008 databases in order to move or copy them.

Watch

Video Length: 10:49
Video Summary: Attaching and Detaching SQL Server Databases represents a viable way to copy and move SQL Server databases when they're offline. Therefore, in this video you'll learn about the exact steps you need to take, and see a step-by-step tutorial that shows you exactly what you need to do to copy and move your SQL Server 2005 and 2008 databases.



New Video/Series: Copying and Moving SQL Server Databases

One of the very first topics that I wanted to address when I initially had the idea to do SSV was the notion of copying and moving databases. Part of the reasoning behind that is due to the fact that there are so many questions about how to do this on newsgroups, lists, and so on. But another reason is due to the fact that there are really a number of different ways of doing it - and they all come with pros and cons. So, while this video ended up being a bit longer than I would have liked (I really only wanted it to be 3 or 4 minutes long), it should give anyone needing to copy and move databases a good overview of which options and possibilities are available.

Better yet, four new videos in this series went up on to the site on Friday and looking at some early info on downloads, it looks like the copy/move series is already doing well (with videos from the series making it into the top 5 with the few hundred downloads already made in November).

Learn about technical considerations for moving and copying SQL Server databases, and learn about the videos and options available for copying and moving your own databases.

At any rate, enjoy the first video in this series: Options for Copying and Moving SQL Server Databases, and I'll go ahead and 'announce' other videos in this series over the next day or so.

Watch

Video Length: 06:01
Video Summary: Moving SQL Server databases is a bit harder than just moving simple file-system files. In this video, you'll learn why that is and what you need to account for when moving and copying your own databases. Furthermore, this video outlines the different options available to you for moving and copying databases - and shows you exactly which videos in this series you'll want to watch to move and copy your databases using the option that best matches your needs.