Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training
   
Transact SQL Training Videos
Transact SQL Video Tutorial Home  Subscriber Videos  

Transact SQL Tutorial: Pt. 1 - An Introduction to SQL Server Management Studio (SSMS)

   Chapter: The Development Environment - Tools, Code Generation, and More
Download! Skill Level: 200 (Beginner - Intermediate)
Duration: 9:45
Size: 7.44MB
Versions/Editions Covered: SQL Server 2005
Added/Updated: Apr 19, 2007
Staff Pick!
Download this video
Scott 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!
Tags for this video: JIT JIT Compiling NON MODAL Windows Object Explorer scripting sql server 2005 ssms SSMS Options SSMS Terminology  
< Back Download this video
AddThis Social Bookmark Button
People Who Downloaded this Video Also Downloaded:
TitleSkillDownload
Subqueries, Nested Queries, and Derived Tables - An Introduction to Advanced SQL... 300 Download
Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys 200 Download
When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Claus... 300 Download
Query Analyzer - Beyond the Basics (SQL Server 2000) 200 Download
JOINs and UNIONs - How Do I Know When to Use a JOIN or a UNION? 300 Download
This video is part of the following video series: "An Introduction to the SQL Server Management Studio (SSMS)"
If you are new to vast world of Sql Server Management Studio (SSMS) or just looking to update your knowledge, then this video series is just what the doctor ordered! In this 4-part series, Scott Whigham will give you a great overview of SSMS, discuss the functionaltiy and availiable options for ssms, working with the query designer, and how best to view reports.

Highlights from this series:
  • JIT Compiling explanation of usage within SQL Server Management Studio
  • SSMS Terminology
  • Pertinent and important options available within SSMS
  • How to comment and uncomment blocks of code with a couple pushes of keys
  • Funny SSMS non malicious bug in SSMS
  • Benefits of the Change Scripts
  • Schema Change Definition
  • Introduction and explanation of the unified log viewer
  • Introduction to integration of reports in management studio
To view all videos in this series, click here

About the Instructor:
Scott Whigham Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott Whigham's full bio can be found on the About the Author page)

   
 
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!
 
11/20/2008 4:37:00 PM