An Introduction to the SQL Server Management Studio (SSMS) - Video Series Video Category: The Development Environment - Tools, Code Generation, and More Skill Level: 200 (Beginner - Intermediate) Versions/Editions Covered: SQL Server 2005 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

Videos in this Series:

Title Skill Length Download Pt. 1 - An Introduction to SQL Server Management Studio (SSMS)   200 10 mins. Download Pt. 2 - SQL Server Management Studio (SSMS) Functionality and Available Options ...   200 12 mins. Download Pt. 3 - Changing Table Design and Properties; Using the Query Designer in SSMS   300 14 mins. Download Pt. 4 - Viewing Reports; Configuring and Viewing the SQL Server and Windows Appl...   300 5 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

The command-line command "netstat" can show you active connections, TCP port usage, network statistics and more Book You Should Probably Own: Joe Celko's "SQL for Smarties" Keyboard Shortcut for SQL Server Management Studio: CTRL+N opens a new query window