Pt. 1 - An Introduction to SQL Server Management Studio (SSMS) -
view detailsScott Whigham does a phenomenal job of introducing you to the new SQL SERVER MANAGEMENT STUDIO (SSMS).This solid introduction begins with the most common uses of SSMS. This lesson does utilize the SP2 version of SQL 2005 however does not require the student to have this installed. This video is filled with a wealth of knowledge and information waiting to be absorbed. This is a fantastic video for the new and old programmers alike. If you are unfamiliar with any of the following than this video is for you:
- SQL SERVER 2005 terminology.
- Just in Time terminology and explanation (JIT)
- JIT Compiling explanation of usage within SQL Server Management Studio
- SSMS Terminology
- Pertinent and important options available within SSMS
- Introduction to working with PINUPS within the WINDOWS Start menu.
- OBJECT Explorer in SSMS (Closest replacement for Enterprise Manager/Object Browser)
- Proper usage of the OBJECT Explorer
- SQL SERVER 2005 Version Number (Version 9)
- Introduction to beginning troubleshooting with SQL SERVER CONFIGURATION MANAGER
- Connecting to Reporting Services, Integration Services and Database Engines.
- Introduction to scripting within SSMS.
- Non MODAL Windows in SSMS 2005 vs. MODAL Windows in SQL 2000
This video is a must see for all beginners and anyone looking to further their basic knowledge about SSMS. If you are not familiar with SSMS you will be very pleased with how easy this video is to follow & absorb and how quickly Scott makes use of your valuable time in properly teaching the correct way to enter the world of SQL SERVER MANAGEMENT STUDIO.
NOTE: This video description was written by one of our members, Wayne Leiser. Thanks, Wayne!
To download this video,
log in, then visit the video's
detail page and click "download". This is a subscriber-only video so a
subscription is required.
Note: You must have the TSCC codec installed to view this video
Keywords Associated with this video: SQL SERVER MANAGEMENT STUDIO, SSMS, Object Explorer, SQL SERVER 2005, JIT Compiling, JIT, SSMS Terminology, SSMS Options, NON MO