Logo

Navigation
  • Home
  • Services
    • ERP Solutions
    • Implementation Solutions
    • Support and Maintenance Solutions
    • Custom Solutions
    • Upgrade Solutions
    • Training and Mentoring
    • Web Solutions
    • Production Support
    • Architecture Designing
    • Independent Validation and Testing Services
    • Infrastructure Management
  • Expertise
    • Microsoft Development Expertise
    • Mobile Development
    • SQL Server Database and BI
    • SAP BI, SAP Hana, SAP BO
    • Oracle and BI
    • Oracle RAC
  • Technical Training
    • Learn Data Management
      • Business Intelligence
      • Data Mining
      • Data Modeling
      • Data Warehousing
      • Disaster Recovery
    • Learn Concepts
      • Application Development
      • Client Server
      • Cloud Computing Tutorials
      • Cluster Computing
      • CRM Tutorial
      • EDI Tutorials
      • ERP Tutorials
      • NLP
      • OOPS
      • Concepts
      • SOA Tutorial
      • Supply Chain
      • Technology Trends
      • UML
      • Virtualization
      • Web 2.0
    • Learn Java
      • JavaScript Tutorial
      • JSP Tutorials
      • J2EE
    • Learn Microsoft
      • MSAS
      • ASP.NET
      • ASP.NET 2.0
      • C Sharp
      • MS Project Training
      • Silverlight
      • SQL Server 2005
      • VB.NET 2005
    • Learn Networking
      • Networking
      • Wireless
    • Learn Oracle
      • Oracle 10g
      • PL/SQL
      • Oracle 11g Tutorials
      • Oracle 9i
      • Oracle Apps
    • Learn Programming
      • Ajax Tutorial
      • C Language
      • C++ Tutorials
      • CSS Tutorial
      • CSS3 Tutorial
      • JavaScript Tutorial
      • jQuery Tutorial
      • MainFrame
      • PHP Tutorial
      • VBScript Tutorial
      • XML Tutorial
    • Learn Software Testing
      • Software Testing Types
      • SQA
      • Testing
  • Career Training
    • Career Improvement
      • Career Articles
      • Certification Articles
      • Conflict Management
      • Core Skills
      • Decision Making
      • Entrepreneurship
      • Goal Setting
      • Life Skills
      • Performance Development
      • Personal Excellence
      • Personality Development
      • Problem Solving
      • Relationship Management
      • Self Confidence
      • Self Supervision
      • Social Networking
      • Strategic Planning
      • Time Management
    • Education Help
      • Career Tracks
      • Essay Writing
      • Internship Tips
      • Online Education
      • Scholarships
      • Student Loans
    • Managerial Skills
      • Business Communication
      • Business Networking
      • Facilitator Skills
      • Managing Change
      • Marketing Management
      • Meeting Management
      • Process Management
      • Project Management
      • Project Management Life Cycle
      • Project Management Process
      • Project Risk Management
      • Relationship Management
      • Task Management
      • Team Building
      • Virtual Team Management
    • Essential Life Skills
      • Anger Management
      • Anxiety Management
      • Attitude Development
      • Coaching and Mentoring
      • Emotional Intelligence
      • Stress Management
      • Positive Thinking
    • Communication Skills
      • Conversation Skills
      • Cross Culture Competence
      • English Vocabulary
      • Listening Skills
      • Public Speaking Skills
      • Questioning Skills
    • Soft Skills
      • Assertive Skills
      • Influence Skills
      • Leadership Skills
      • Memory Skills
      • People Skills
      • Presentation Skills
    • Finding a Job
      • Etiquette Tips
      • Group Discussions
      • HR Interviews
      • Interview Notes
      • Job Search Tips
      • Resume Tips
      • Sample Resumes
 

SQL Server 2005 Management Studio

By Exforsys | on September 8, 2005 |
SQL Server 2005

SQL Server Management Studio

SQL Server Architecture and Components

What strikes the developer is the absence of the SQL Enterprise Manager in the interface. The SQL Server Management Studio offers functionality enhancements and a new look and feel to the application. It has been implemented using Winforms and .NET framework and is completely different from the Microsoft management console and looks more like the Visual studio Interactive development Environment(IDE).

The design allows administration and programming features through the same interface focusing upon consistency of experience. A significant improvement is the introduction of non modal dialog boxes. These boxes allow the comparison of content and are resizable and permit switching between dialog boxes for performing multiple actions in parallel.

The tool is backward compatible and manages instances of SQL 2000. It can also be used to control Server Mobile Edition. A number of SQL based server utilities can also be launched from the Tools menu such as the SQL Profiler and the Database Tuning Advisor.

The SQL Server Management Studio is modular and contains a number of windows that can be docked or remain floating

1. The Object Explorer enables registration, browsing and management of servers and their components. Objects are arranged in hierarchies and can be ordered according to the type or filtered based on their name, schema or date. The information about the objects are available in the Summary view window or in the Reporting Services. The new asynchronous refresh for the windows allows access to manipulate loaded objects without waiting of the processes to be completed by others. The script option allows administrative tasks to be scripted with ease.

This option is available in the menu of the properties window. Once scripted the task can be scheduled for later execution and this automatically creates an SQL Server Agent job. Functions and stored procedures can be created with assisted editors. Maintenance plans node serves as a replacement for the Database Maintenance Wizard and integrates with the Data Transformation services. This enables design of workflow for a variety of maintenance tasks.

2. Servers can be registered and connections can be recorded per server with all associated settings. Server registration can also be exported form one instance of the SQL to another.

3. The Solution Explorer implements the programming paradigm of the Visual Studio in SQL Server. It groups pieces of related code and integrates with Visual SourceSafe for supporting version control. However, the Solution Explorer does not offer the ability to compile programs written in .NET languages. It supports T-SQL and XML Query Language scripts, XML for Analysis services and MDX cube calculations or DMX operations.



4. The Query Editor is a combination of the Query Analyzer and Analysis Manager. It has the ability of executing queries written in T-SQL, XMLA, MDX and DMA against SQL server mobile edition and Analysis Services in connected and disconnected scenarios. It integrates the Visual SourceSafe version control. Query execution plan can be displayed with estimated and actual plans and the showplan can be saved as an XML document, making it portable ad simplifying logistics for troubleshooting. The Query Editor can also be run in the SQLCMD mode. It can be accessed both from the file menu and the Query menu.

5. The Template Explorer helps in creating queries based on existing templates.

6. Dynamic Help is available from the help menu and from the context sensitive help feature.

« « Overview of SQL Server 2005 for the Database Developer
ASP.NET GridView Control » »

Author Description

Avatar

Editorial Team at Exforsys is a team of IT Consulting and Training team led by Chandra Vennapoosa.

Ads

Free Training

RSSSubscribe 416 Followers
Ads
  • Popular
  • Recent
  • Native HTTP Support in SQL Server 2005

    November 1, 2005 - 0 Comment
  • Managing SQL Server 2005 Security

    December 24, 2005 - 0 Comment
  • Planning to Install SQL Server 2005

    November 29, 2005 - 0 Comment
  • Getting started with SQL Server 2005

    August 9, 2005 - 0 Comment
  • Using SQL Sever Management Studio – Part 2

    December 15, 2005 - 0 Comment
  • NET CLR in SQL Server 2005

    November 1, 2005 - 0 Comment
  • SQL Server 2005 – Managing Permissions

    December 26, 2005 - 0 Comment
  • Installing a Second Copy of SQL Server 2005

    November 29, 2005 - 0 Comment
  • Overview of SQL Server 2005 for the Database Developer

    September 8, 2005 - 0 Comment
  • Using the SQL Management Objects

    December 15, 2005 - 0 Comment
  • SQL Server 2005 – Configuring Replication

    January 11, 2006 - 0 Comment
  • SQL Server 2005 Replication Enhancements

    January 11, 2006 - 0 Comment
  • SQL Server 2005 – Mirror Server

    January 11, 2006 - 0 Comment
  • SQL Server 2005 – Introduction to Data Availability

    January 1, 2006 - 0 Comment
  • SQL Server 2005 – Backing up a Database

    January 1, 2006 - 0 Comment
  • SQL Server 2005 – Using Database Snapshots

    December 26, 2005 - 0 Comment
  • SQL Server 2005 – Disaster Recovery

    December 26, 2005 - 0 Comment
  • SQL Server 2005 – Managing Certificates

    December 26, 2005 - 0 Comment
  • SQL Server 2005 – Managing Permissions

    December 26, 2005 - 0 Comment
  • Managing SQL Server 2005 Security

    December 24, 2005 - 0 Comment

Exforsys e-Newsletter

ebook
 

Related Articles

  • SQL Server 2005 – Configuring Replication
  • SQL Server 2005 Replication Enhancements
  • SQL Server 2005 – Mirror Server
  • SQL Server 2005 – Introduction to Data Availability
  • SQL Server 2005 – Backing up a Database

Latest Articles

  • Project Management Techniques
  • Product Development Best Practices
  • Importance of Quality Data Management
  • How to Maximize Quality Assurance
  • Utilizing Effective Quality Assurance Strategies
  • Sitemap
  • Privacy Policy
  • DMCA
  • Trademark Information
  • Contact Us
© 2021. All Rights Reserved.IT Training and Consulting
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Reject Read More
Privacy & Cookies Policy
Necessary Always Enabled