Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · LearnIntegrationServices.com · LearnTransactSql.com
     
Instructor-Led Video Training for SQL Server             * LearnIntegrationServices.com
* LearnTransactSql.com
* More Videobooks...
Email
Password
Register
LearnSqlServer.com LearnSqlServer.com
SQL Server 2008/2005 Videos By Category Home  Subscriber Videos  
Tools, Utilities and Common Tasks for Managing SQL Server - 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

For those of you with SQL Server 2000, this category also features videos on Enterprise Manager, Query Analyzer, Profiler, tools in the SQL Server 2000 Resource Kit and many other helpful tools such as snap-ins for the Microsoft Management Console (MMC).



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 Video 100 Download 8 mins.
Building a Customized Microsoft Management Console (MMC) for Use with SQL Server   200 Download 10 mins.
Creating Database Diagrams in SQL Server Management Studio   200 Download 18 mins.
Database Diagrams - An Introduction   100 Download 9 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, DSNs, and UDLs - Creating Reusable Connection Information   200 Download 10 mins.
ODBC, OLE-DB, UDLs and the SQL Native Client - Connecting to SQL Server and Maki...   200 Download 16 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 OPENTRAN (<insert your database name here >) WITH TABLERESULTS to view the most recent transaction details
Helpful Keyboard Shortcuts: "Windows key" + "L" locks your computer
Security Tip: Be very wary of assigning logins to be members of any of the fixed server roles. The server roles in SQL Server 7.0 and 2000 have a few "holes": did you know that any member of a server role can indescriminately make other logins members of that same role? Another gotcha: the Database Creators role allows its members to drop any database!
Video search
Company News
Exchange 2007/2003 Training Videos
     
Home | About Us | Advertising | Contact Us | Privacy | System Requirements | Terms and Conditions | Testimonials | Blogs | Site Map Refer a Friend and Get a Free Subscription!
© Copyright 2004-2007 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.
5/9/2008 12:17:23 PM