Member of the
LearnItFirst.com Video Training Network
Related Video Training Sites:
·
SSIS Training Videos
·
SQL Programming Tutorials
Create a free account
·
Sign In
SQL Server DBA Videos in Series
Home
Subscriber Videos
A Technical Overview of SQL Server: What It Is, What It Does, Who Uses It and More (Video Series)
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:
Title
Skill
Length
Download
Part 1 - A Technical Overview of SQL Server: What Is SQL Server?
100
12 mins.
Download
Part 2 - What Can I Do With SQL Server, Analysis Services, Reporting Services, a...
100
12 mins.
Download
Part 3 - Who Uses SQL Server, Analysis Services, Reporting Services and Integrat...
100
9 mins.
Download
Part 4 - Versions, Editions, Licensing, and Pricing
100
22 mins.
Download
Part 5 - A Look at the Hardware Requirements: CPU, Memory and Hard Drives
100
13 mins.
Download
Part 6 - Operating Systems and Other Software Requirements
100
7 mins.
Download
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!
About Us
·
Corporate Philosophy
·
Become an Author
·
Contact Us
Video Playback
·
System Requirements
·
TSCC Codec
(to play videos)
·
Troubleshooting/Problems
Subscriptions
·
Pricing/Buy Now
·
Testimonials
·
Privacy
·
Terms of Service
More Video Training
·
SSIS Training Videos
·
SQL Programming Tutorials
·
All of Our Websites
More
·
FAQs
·
Search for videos
·
Site Map
© 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.
1/6/2009 9:04:30 PM