The SQLServerVideos.com BookShelf

Author(s): Robert Vieira

Rating: 5 / 5

Summary: A must-have overview of key SQL Server 2000 concepts and principles - along with handy reference material in a well-written and easy to understand book. A real winner.

Review: One of my first 'real' SQL Server Books was Robert Vieira's 'Professional SQL Server 7.0 Programming'. What I loved about it was how thorough it was given how comprehensive it's treatment of SQL was. With it I was able to learn all of the basics of authoring queries, and also gained great insights into properly writing sprocs and tackling more complex operations. Best of all, the author's presentation and tone were very approachable, and I found that the book struck a great balance between teaching concepts and principles while still managing to be a great reference book. (Pulling that off with a technical book is a rare feat.) With Professional SQL Server 2000 Programming, the author basically re-heats most of the material from his previous book, but adds in tons of additional content for new SQL Server 2000 features - matching his original quality, tone, and approachability - making this book a powerhouse. I highly recommend this book for beginner to intermediate audiences who are mostly focused on development (though the book does cover architecture and administration as well).

Learn why SQL Server Backups can be hard to understand and master. A must-see video for anyone who isn't familiar with SQL Server Backup functionality.

Covers: Backups, Recovery, Log Files, Transactions, and the SQL Server Storage Engine.

Skill Level: 000 - Overview

Video Length: 11:09

Release Date: 2008-01-03

Take an in-depth look at SQL Server's use of the transaction log and see how write-ahead logging benefits performance, reliability, and data recovery.

Covers: Log Files, Recovery, Backups, the SQL Server Storage Engine, and Transactions.

Skill Level: 000 - Overview

Video Length: 14:15

Release Date: 2008-07-09