Working with SQL Server Management Studio http://www.LearnNowOnline.com
Learn More @ http://www.learnnowonline.com Copyright Š by Application Developers Training Company
Objectives • Learn about Management Studio and see how you can use it to write code and administer a server • Explore Management Studio’s Object Explorer tool • See how you can use the Query Editor to write and debug code
Learn More @ http://www.learnnowonline.com Copyright © by Application Developers Training Company
Agenda • Getting Started with Management Studio • Exploring the Object Explorer • Working with the Query Editor
Learn More @ http://www.learnnowonline.com Copyright © by Application Developers Training Company
Getting Started with Management Studio • Includes many tools • Wizards and designers • Tools for Reporting Services, Integration Services • Object Explorer • SQL Server Profiler and the Database Engine Tuning Advisor • Support for management of complex applications • Rich scripting capabilities • Compatibility with source control systems
Learn More @ http://www.learnnowonline.com Copyright © by Application Developers Training Company
Agenda • Getting Started with Management Studio • Exploring the Object Explorer • Working with the Query Editor
Learn More @ http://www.learnnowonline.com Copyright © by Application Developers Training Company
Exploring the Object Explorer • Displays server and database information • Hierarchical treeview • Supports add-on services • Administer server features
• Deep insight into every corner of SQL Server • Uses hierarchical treeview
Learn More @ http://www.learnnowonline.com Copyright © by Application Developers Training Company
Agenda • Getting Started with Management Studio • Exploring the Object Explorer • Working with the Query Editor
Learn More @ http://www.learnnowonline.com Copyright © by Application Developers Training Company
Working with the Query Editor • Write most of your code in query editor • To create a new query • New Query button on toolbar • Database Engine Query on toolbar • File|New|Query with Current Connection or File|
New|Database Engine Query from menu • File|Open|File or File|Open|Solution/Project to open saved files Learn More @ http://www.learnnowonline.com Copyright © by Application Developers Training Company
Questions? http://www.LearnNowOnline.com
Learn More @ http://www.learnnowonline.com Copyright Š by Application Developers Training Company