Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SSIS Training Videos · SQL Programming Tutorials
   
SQL Server
                        Training Videos

A Technical Overview of SQL Server: What It Is, What It Does, Who Uses It and More (Video Series)

Video Image Video Category: An Introduction to SQL Server

Skill Level: 100 (Beginner)

Versions/Editions Covered: SQL Server - All Versions , SQL Server 2000 , SQL Server 2005 , SQL Server 2008
If you have little to no prior knowledge about database servers and are looking to learn about SQL Server then you've found the right video series! In this series your instructor, Scott Whigham, will introduce you to the concepts behind Microsoft SQL Server. You will learn the first of three basic W's of SQL Server: what is it, who uses it, what it does.  This video series is great for those of you who are looking for a great intro technical overview of SQL Server.

Videos in this Series:


Miscellaneous Bits & Pieces:
Want to see something cool? Run SELECT cacheobjtype, objtype, pagesused, sql FROM master.dbo.syscacheobjects ORDER BY pagesused DESC
Performance Tip: If your stored procedures use temporary tables or table variables create these as the first line(s) of code in your stored procedure. This helps minimize/prevent recompiles which allows SQL Server to cache the procedure's execution plan for maximum reuse
Did you know that the fixed server role "Database Creators (dbcreator)" can drop any database on the server? Ouch!

Other Websites We Offer
LearnReportingServices.com
Don't Forget!
100% Money Back Guarantee
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
1/6/2009 9:04:30 PM