The first in my live meeting series was on SQL Server Basics - Part 1 : An introduction to the SQL Server toolset.
The recording is available here:
http://sqlserverfaq.com/livemeetings/sqlfaq_20090528_tonyrogerson_sqlserverbasics_tools.zip
I pretty much covered the following:
>> Common tools you need to use in deploying, using and managing SQL Server (Configuration Tools, Management Studio, Profiler and Perfmon)
>> Simple querying
SQL Server Installation Center
Configuration Manager
Manage Services
Network - 32 v 64.
SQL Server Management Studio
Connecting to SQL Server
Object Explorer
Table Designer
Tools...Options
Prevent saving changes
Create Schema Script
Import / Export Data
Export (to csv, with column headers - use a query, save as SSIS)
Import back into a table
SQL Server Agent
Properties - what can we do? (Database Mail, WMI etc...)
Schedule the ssis package
Maintanence Plans
Registered Servers
Groups
Central Management Servers
Profiler