Member of the
LearnItFirst.com Video Training Network
Related Video Training Sites:
·
SQL DTS Training Videos
·
SQL Programming Videos
SQL Server 2000 Training Videos
*
SQL DTS Training Videos
*
SQL Programming Videos
*
More Videobooks...
Search
My Account
More Videobooks
Sign in
Home
FREE Video Tutorials
Subscriber Video Tutorials
Subscriptions
FAQs
Our Other Sites
About Us
Home
Free Videos
Subscriber Videos
Buy Now (Subscriptions)
More Video Websites
Search for Videos
Tag Cloud
Subscriptions
Subscribe!
Testimonials
List of Videobooks
Quick Links
About the Author
Login
FAQs
Site Map
An Overview of the Fixed Server Roles for SQL Server 2000
Creating SQL Server Authentication Logins in the Enterprise Manag...
Creating Windows Authentication Logins in the Enterprise Manager
How to Increase a Database's Size - Multiple Techniques for Incre...
How to Increase a Database's Size Using the SQL Server Enterprise...
SQL Server 2000 Videos By Category
Home
Subscriber Videos
Working with SQL Server Databases: Creation, Management and Best Practices
- Video Category
(
all video categories
)
This category of videos discusses the various ways to create databases, how to manage your database files by expanding or shrinking SQL Server's database files, how filegroups work, and Best Practices for SQL Server databases
Versions/Editions Covered:
SQL Server 2000
,
SQL Server 2005
,
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
Title
Skill
View / Download
Length
An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) ...
200
Download
5 mins.
Creating Databases with the SQL Server Enterprise Manager
200
Download
17 mins.
Creating Our First Database - Three Techniques
100
Download
12 mins.
Database Compatibility Levels and sp_dbcmptlevel
300
Download
11 mins.
Enterprise Manager - Put Table On Filegroup
400
Download
15 mins.
How to Increase a Database's Size - Multiple Techniques for Increasing Data File...
300
Download
11 mins.
How to Increase a Database's Size Using the SQL Server Enterprise Manager
200
Download
9 mins.
Setting Database Options Using the Enterprise Manager - Setting the Database Sta...
300
Download
15 mins.
Shrinking Database Files and Removing Space from Your SQL Server Database (Using...
300
Download
15 mins.
<
Return to list of all videos
Related Links:
Microsoft SQL Server 2000 Bible
- Paul Nielsen is a SQL guru - there's no question. This book is a huge tome of great SQL info and comes highly recommended for newbies and intermediate-level DBAs and developers
Professional SQL Server 2000 Programming
- Recommended by Scott Whigham (author of LearnSqlServer.com) as best book for newbies and beginners to SQL Server 2000
Database Design for Mere Mortals
- Another Michael Hernandez gem and, of course, it's an industry standard. Be aware that this book is about SQL, not a particular implementation of SQL
Miscellaneous Bits & Pieces:
Helpful Tools for your SQL Server: If you need to move an Oracle instance into your SQL Server, check out Microsoft's "SQL Server Migration Assistant for Oracle"
Performance Tip: Don't apply the "Auto Shrink" database option for a production database. Auto Shrink is very expensive and can negatively impact the performance of your live system
Book You Should Probably Own: Ken Henderson's "The Guru's Guide to SQL Server Architecture And Internals"
Company News
»
We're also sponsoring the St Louis SQL Server User Group July 9
»
We're sponsoring the Billings, Montana .NET User Group July 8
»
We're sponsoring the San Antonio, TX Alamo Coders User Group June 10th
»
Scott had a baby!
Home
|
About Us
|
Advertising
|
Become an Author
|
Contact Us
|
Privacy
|
System Req's
|
Terms
|
Testimonials
|
Work for Us!
|
|
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.
7/3/2008 6:30:38 PM