I need to quickly ramp up on SQL Server 2005, but I don't have a big training budget. Are any useful—and free—online resources available?
Can you say Google? I'd need every page in the magazine to do justice to the vast amount of SQL Server 2005 content that's already available online from multiple sources. Microsoft has done a great job of getting learning materials into the hands of users in advance of the product's release to manufacturing (RTM)—much better than with any other SQL Server release. This list isn't all-inclusive by any stretch of the imagination, but the following are a few resources (all from the Microsoft site, in the interest in brevity) that I think you'll find useful.
The Microsoft SQL Server home page contains a lot of useful information, but that's too easy. The Microsoft SQL Server TechCenter site is one of the best jumping off points I've stumbled across. Book-mark the site, and visit it often. Microsoft presents new material there on a regular basis.
I thought about including a screen shot to give you a feel for the site's content, but it contains so much material that the main page scrolls two to three times. I won't try to recap everything the site includes, but some of my favorite tidbits, especially for people who are hungry for SQL Server 2005 knowledge, include:
That last item is one of my favorites. Microsoft is currently offering the classes for free download (at least at the time I wrote this), although the company lists a retail price of $99 and has indicated that it will begin charging for the classes sometime soon. So you'll want to download them all as soon as possible, even if you don't plan to complete each class immediately.
The three DBA classes include the following:
The three development classes include the following:
The three BI classes include the following:
Learning SQL Server 2005 might seem like a Herculean task because of all its new features, but many of the resources I discussed are bite sized enough to let you begin making real progress on your SQL Server 2005 education without being overwhelmed. Take a look at the other resources that Microsoft's SQL Server Web site offers. You'll find plenty of information to keep you busy for some time to come.