Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server Training Videos · SSIS Video Tutorials
     
DTS Training Videos             * SQL Server Training Videos
* SSIS Video Tutorials
* More Videobooks...
Email
Password
Register
LearnDTS.com Subscriber Videos
SQL Server DTS Videos By Category Home  Subscriber Videos  
Introduction to Data Transformation Services - Video Category (all video categories)
Video Image Data Transformation Services in SQL Server 2000 not only changed the way that many businesses moved data around the office, it actually created new companies who existed/started just by migrating data from Source to Destination. DTS is now so common that it has become, like SQL Server itself, a fundamental component in today's offices. This category helps you understand the basics of DTS, it's place in the workplace, and why DTS is so great.

Versions/Editions Covered: SQL Server 2000
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
A Walk-Through of the Various Tabs, Screens and Choices in the DTS Designer   100 Download 14 mins.
A Walk-Through of Using Enterprise Manager and DTS   100 Download 6 mins.
Creating a Custom MMC to Manage Your SQL Server and DTS Packages   200 Download 6 mins.
Data Warehousing and DTS - Common Terms and Patterns Used Within DTS   200 Download 10 mins.
Importing Text Files Into a SQL Server Table Using the Import/Export Wizard   100 Download 11 mins.
What is the Import/Export Wizard and Using the Import/Export Wizard in Common Da...   100 Download 8 mins.
Who Uses DTS? What Are the Goals of DTS? An Overview of DTS as an ETL Tool   100 Download 16 mins.
< 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
Most SQL Server adminstrators prefer to change the port of a default instance from 1433 to something unused. This prevents hackers and malicious software from connecting to port 1433 and locating a SQL Server. Bottom line: everyone knows that the default SQL Server port is 1433 so, to create a secure server, change the port number
Want to see something cool? Run DBCC SHOWCONTIG WITH TABLERESULTS or, for more information, DBCC SHOWCONTIG with all_indexes, TABLERESULTS, all_levels
Video search
Company News
Exchange 2007/2003 Training Videos
     
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/23/2008 6:48:09 PM