Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SSIS Training Videos · SQL Programming Tutorials
   
SQL Server Training Videos
SQL Server DBA Videos By Chapter Home  Subscriber Videos  

Chapter: An Introduction to SQL Server Tutorials - (all chapters)

Video Image This chapter is a great introduction to SQL Server. Whether you are a complete 'no-nothing' for SQL Server or you've had extensive experience with other RDBMS' and just want to learn about SQL Server, this is a great place to start.
Videos in this Chapter: orange = video series 
blue = individual video 
Click "Download" to download the video or click the video title for more information
TitleSkillView / DownloadLength
Series (6 videos) - A Technical Overview of SQL Server: What It Is, What It Does...   New! 100 (Click for Videos) 73 mins.
Miscellaneous Bits & Pieces:
"Collation" is one of the most misunderstood terms in SQL Server. In a nutshell collation defines (a) the characters that are allowed in a column, (b) the way those characters will be sorted in the ORDER BY, and (c) how those characters will be compared (using the WHERE clause, for example)
Security Tip: Protect your "sa" account by using a very strong password. Hackers can issue dictionary attacks against your SQL Server and attempt to guess your "sa" password with brute force. By providing a password that (a) cannot be found in any dictionary, and (b) contains letters, numbers, and special characters, you give yourself maximum password protection
Performance Tip: Try to keep your transactions as short as possible. This reduces wait time and locks held which increases concurrency

   
 
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 10:51:54 PM