Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Programming Training Videos · SQL Server DBA Tutorials
     
SQL Server 2005 Training Videos             * SQL Programming Training Videos
* SQL Server DBA Tutorials
* More Videobooks...
Email
Password
Register
LearnSqlServer2005.com Subscriber Videos
SQL Server 2005 Videos By Category Home  Subscriber Videos  
SQL Server 2005 Administration: Tools, Utilities and Common Tasks - Video Category (all video categories)
Video Image This is an essential set of videos for all administrators. In this set of videos you'll learn all about the most common tools and how to perform common tasks. This category discusses the SQL Server Management Studio, Profiler, the Configuration Tools (such as the Surface Area Configuration tool and the SQL Server Configuration Manager) and many other helpful tools such as snap-ins for the Microsoft Management Console (MMC).

This set of videos also features DOS commands and utilities (sqlcmd, osql, bcp), batch-file writing, and scripting topics

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
Building a Custom MMC for Use with SQL    Free SQL Server 2005 Training Video 100 Download 8 mins.
Creating Database Diagrams in SQL Server Management Studio   200 Download 18 mins.
How to Upgrade The Documentation of SQL Server 2005 (Books Online)   100 Download 6 mins.
My Favorite SSMS Tweak (by Scott Whigham)   100 Download 7 mins.
ODBC, OLE-DB, UDLs and the SQL Native Client - Connecting to SQL Server and Maki...   200 Download 16 mins.
SQL DBA 101: How to Quickly Schedule a Backup Job   200 Download 7 mins.
Templates in SQL Server Management Studio - What They Are and How to Use Them   200 Download 9 mins.
< Return to list of all videos
Miscellaneous Bits & Pieces:
Want to see something cool? Run DBCC PERFMON WITH TABLERESULTS
After SQL Server 2000 you should not be using @@IDENTITY in your code. Microsoft replaced @@IDENTITY with SCOPE_IDENTITY() in SQL Server 2000
Which of these queries will perform faster? (a) SELECT * FROM Table WHERE Salary-1000 > 10000 or (b) SELECT * FROM Table WHERE Salary > 9000. (b) will perform faster since (a) would have to calculate (Salary-1000) first and then compare that value to 10000
Video search
Company News
Download free videos from LearnItFirst.com
     
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/3/2008 10:04:27 PM