Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Programming Training Videos · SQL Server DBA Tutorials
   
SQL Server 2005 Database Administration Training Videos
SQL Server 2005 Videos in Series Home  Subscriber Videos  

An Introduction to Bulk Operations, Flat Files, and Tools in SQL Server (Video Series)

Video Image Video Category: Miscellaneous - Topics That Do Not Fit Anywhere Else!

Skill Level: 500 (Advanced)

Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008
This series - a twelve part series mind you - is a comprehensive survey of the various tools available to you when you want to import text files (a.k.a. flat files) into your SQL Server. This series covers scenarios such as loading empty tables with no indexes (i.e., a heap), empty tables with clustered indexes, and appending to tables. You'll learn the details about bcp, BULK INSERT, OPENROWSET, and using SSIS (SQL Server Integration Services) to do your batch loads.

Videos in this Series:

TitleSkillLengthDownload
Pt. 1 - An Introduction to Bulk Operations in SQL Server   400 11 mins. Download
Pt. 10 - SQL Server Intergration Services BULK INSERT Task   500 10 mins. Download
Pt. 11 - Loading Flat Files Using the SQL Server Integration Services Data Flow ...   500 8 mins. Download
Pt. 12 - Understanding the FastParse Option   500 9 mins. Download
Pt. 2 - An Overview of the Various Scenarios and Tools Available for Bulk Loads   400 9 mins. Download
Pt. 3 - Finishing Our Overview of Bulk Load Tools and DROPCLEANBUFFERS   400 13 mins. Download
Pt. 4 - An Overview of the BCP Utility and Our Testing Scenarios   400 14 mins. Download
Pt. 5 - Format Files and BCP: Creating a Format File To Load Your Flat File   400 9 mins. Download
Pt. 6 - More on Format Files, .fmt Files, and the New XML Format Files   400 7 mins. Download
Pt. 7 - How to Manage Triggers and Check Constraints During Bulk Operations   500 9 mins. Download
Pt. 8 - Loading an Empty Table With No Indexes vs. Empty Table With Indexes   500 8 mins. Download
Pt. 9 - BULK INSERT and the OPENROWSET Functions as Alternatives to BCP   500 11 mins. Download

Miscellaneous Bits & Pieces:
Tips and Tricks: Microsoft's Baseline Security Analyzer (MBSA) is a great free tool for determining the attack surface area of your server
You can store your own custom error messages in your SQL Server's master database
Keyboard Shortcut for SQL Server Management Studio: F4 displays the properties window

Other Websites We Offer
LearnWindows2003.com
Don't Forget!
Become a Guru
 
   
 
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 1:54:03 AM