Video:
Pt. 2 - SQL Server Management Studio (SSMS) Functionality and Available Options (Including Writing Queries)
-
Skill level:
200 (Beginner - Intermediate)
-
Run Time:
11:30
-
Instructor:
Scott Whigham
Description:
Another great introduction video to SQL SERVER MANAGEMENT STUDIO (SSMS) by Scott Whigham. This video leaps us onto the next stepping stone for SSMS. Scott not only continues his teachings about Generating Scripts within SSMS, he also gives is the another basic introduction to SSMS and explains why SSMS is the sole tool to utilize when writing TSQL. Included in this video are the following excellent features:
- SQL SERVER Connection Requirements in 7.0 or 2000
- SQL SERVER 2005 Color Coded Syntax
- Disconnect and Switch Connection options
- Basic Introduction to SAVE ME Asterisks
- Basic Introduction to MDX and DMX Queries inside SSMS
- Lack of Intellisense within SSMS
- History of Intellisense
- Third party Intellisense software is available
- SSMS available options
- Hot keys within SSMS and where to set them
- SQL SERVER 2005 Chords - ie. Commenting out blocks of code (CTRL+K, CTRL+C)
- How to comment and uncomment blocks of code with a couple pushes of keys
- Funny SSMS non malicious bug in SSMS
This video is a must see, even if only for the bug within SSMS SP2. It is funny once you know about it and can be confusing if you see it before you know it is a BUG. Scott does a fantastic job of bringing us up to speed on the newest software used in developing TSQL (SSMS). This video is extremely easy to follow and is very well done.
NOTE: This video description was written by one of our members, Wayne Leiser. Thanks, Wayne!
Download
and watch this video
NOTE: You will need the TSCC codec
installed to view video
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's full bio can be found here)
|
Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys
|
200
|
Download
|
|
Subqueries, Nested Queries, and Derived Tables - An Introduction to Advanced SQL Constructs
|
300
|
Download
|
|
Creating Database Diagrams in SQL Server Management Studio
|
200
|
Download
|
|
When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Clause
|
300
|
Download
|
|
JOINs - An Overview of the Five Types of JOINs (Cross, Outer, and Inner)
|
200
|
Download
|
NOTE: This video is part of our
SQL Server Programming (SQL Server 2005/2000): Transact SQL course.
This video is from Chapter
1:
The Development Environment - Tools, Code Generation, and More
Jump to a specific chapter: