ITidiots Episode 35: SQL Server Basics

Posted in Databases, Operating Systems, Podcasts on July 16, 2008


ITidiots Episode 35: SQL Server Basics

This weeks training video screencast: SQL is everywhere nowadays. Sharepoint, Systems Management Server, Microsoft Operations Manager, and Windows Server Update Services all require a SQL server database. In this episode we have a look at the installation of Microsoft SQL 2000 and cover basic database recovery. Okay, SQL 2005 is out now, but you will find that most organisations are still making heavy use of SQL 2000. Also, the points covered in this podcast will also largely apply to any version of SQL, including mySQL. Watch us install SQL, then backup and restore a database using Transact-SQL statements, it is really good fun, well it is if you don’t have much of a life like us.

Watch Video Watch Video Watch Video

Tags: Databases, OS, Windows, MSSQL, SQL, ITidiots, Windows Server, Microsoft SQL Server 2000, T-SQL