Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SSIS Training Videos · SQL Programming Tutorials
     
SQL Server Training Videos             * SSIS Training Videos
* SQL Programming Tutorials
* More Videobooks...
Email
Password
Register
LearnSqlServer.com Subscriber Videos
SQL Server DBA Videos By Category Home  Subscriber Videos  
Architecture: System Databases, System Tables, and SQL Server Internals - Video Category (all video categories)
Video Image The more you know about how things work in SQL Server, the better prepared you are to make intelligent design and management choices. Watch this video category for information on how the internals of Microsoft SQL Server 2000 influence your design making. You'll learn the details about the master database, the msdb database, how the resource database is used by SQL Server, and how to take advantage of the model database for fun and profit.

This video includes detailed walk throughs of the objects in each database complete with descriptions and suggestions for use for many of the most commonly used objects (system tables, system views, system procs and more).

Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008
Videos in this Category: orange = video series 
blue = individual video 
Click "Download" to download the video or click the video title for more information
TitleSkillView / DownloadLength
Series (3 videos) - A Deeper Look at Pages and Extents Using SQL Internals Viewe...   500 (Click for Videos) 31 mins.
Series (5 videos) - Understanding SQL Server Page Structure: How Page Splits Aff...   500 (Click for Videos) 43 mins.
How SQL Server 2005 Uses the Registry and Changes to the Registry   400 Download 14 mins.
How SQL Server Logs Errors - The SQL Server Error Log and Configuration   300 Download 11 mins.
How to Change the Master Database's File Locations   500 Download 6 mins.
Model Database - An Overview of How to Use It and When to Use It (SQL Server 200...   300 Download 10 mins.
TempDb Database - An Overview of How it Works and When to Use It   300 Download 12 mins.
Over 2 hours of SQL Server tutorials in this category
< Return to list of all videos
Miscellaneous Bits & Pieces:
Security Tip: Protect your backups! Many DBAs often do not realize that anyone that can get to your SQL Server database backups can also restore those backups on their own SQL Server. One additional layer of file-based security that you can add in is to put a password on your backup file. This can only be done with Transact-SQL but it cannot be bypassed during the restore
Security Tip: Run the Microsoft Baseline Security Analyzer (MBSA) on your SQL Server to ensure that you are well protected
Performance Tip: Try to keep your transactions as short as possible. This reduces wait time and locks held which increases concurrency
Video search
Company News
Visual Studio 2005 C# Training
     
Home | About Us | Advertising | Become an Author | Contact Us | Privacy | System Req's | Terms | Testimonials | Work for Us! | Blogs | Site Map Refer a Friend and Get a Free Subscription!
© 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.
7/25/2008 10:56:54 AM