Working with SQL Server Management Studio

Page 1

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


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.