Member of the
LearnItFirst.com Video Training Network
Related Video Training Sites:
·
SQL Server DBA Tutorials
·
Integration Services Training
Create a free account
·
Sign In
Transact SQL Videos in Series
Home
Subscriber Videos
An Introduction to Schemas in SQL Server 2005 and SQL Server 2008 (Video Series)
Video Category:
The Transact-SQL Language - An Introduction to Common Terms, Tools, and Techniques in TSQL
Skill Level:
300 (Intermediate)
Versions/Editions Covered:
SQL Server 2005
,
SQL Server 2000
,
SQL Server 2008
Schemas are not complicated but, for whatever reason, people often get confused when working with them. This series tries to help you understand what schemas are and when/where to use them. This is a great series for both newbies, people coming from Oracle or other systems, and is definitely great for someone moving from SQL Server 2000.
Videos in this Series:
Title
Skill
Length
Download
Pt. 1 - An Intro to Schemas In SQL Server 2005 and SQL Server 2008
300
14 mins.
Download
Pt. 2 - Default Schemas and How SQL Server Performs Naming Resolution
400
9 mins.
Download
Pt. 3 - Best Practices for Using Schemas and How to Transfer Objects to New Sche...
400
11 mins.
Download
Miscellaneous Bits & Pieces:
Helpful Keyboard Shortcuts: "CTRL" + "Page Up" navigates forward between panes/worksheets/tabs in an application (use "Page Down" to navigate backwards)
Security: Most DBAs prefer to remove the SQL Server login "BUILTIN\Administrators" either from the SQL Server or from the fixed server role "sysadmins" for security reasons
Security Tip: Run the Microsoft Baseline Security Analyzer (MBSA) on your SQL Server to ensure that you are well protected
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
·
SQL Server DBA Tutorials
·
Integration Services Training
·
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/8/2009 2:59:47 PM