1. Understanding SQL Server 2005
Basically the definition of SQL Server itself is a language used for accessing data in a database relation. This language is the de facto standard language used in relational database management. Currently almost all of the existing database server supports this language in its data management. SQL server 2005 is one of the products of the Relational Database ManagementSystem (RDBMS).
2. Consists of what are the components of SQL Server 2005?
SQL Server 2005 consists of several components as follows:
a. Relational Database Engine: The main component of SQL Server 2005 or the heart.
b. Analysis Services: Basis of a powerful business intelligence solutions (powerful), and supports applications OLAP (online analytical processing), and Data Minning.
c. Data Transformation Service (DTS): a machine to make a solution of export and import data, as well as to transform the data when the data is transferred.
d. Notification Services: a framework for a solution where the customer will be sent notification when an event is raised.
e. Reporting Services: service that will retrieve data from SQL Server, and generate reports.
f. Service broker: a queuing mechanism that will handle the message based communication between services.
g. Native HTTP Support: the support that allows SQL server 2005 which (if installed on Windows Server 2003) will respond to requests to HTTP endpoints, thus allowing the construction of a web service for SQL Server without using IIS.
h. SQL server Agent: will automate and manage database maintenance tasks, events and alerts.
i. . NET CLR (Common Language Runtime): will allow the manufacture of solutions using managed code written in one language. NET.
j. Replication: a series of technologies to build and distribute data and database objects from a database to another database, and synchronize to maintain consistency.
k. Full-Text Search: enabling fast and flexible indexing for keyword-based query (for text data stored in the database).
3. Does new data base administration, with fictur provided SQL server 2005?
Features for Database Administration
a. Database Mirroring
Extend log shipping capabilities with database mirroring solution. You will be able to use database mirroring to enhance availability of SQL Server systems by setting up automatic failover to a standby server.
b. Online Restore
With SQL Server 2005, database administrators can perform a restore operation while an instance of SQL Server is running. Online returns increase the availability of SQL Server because only the data to be restored is not available, the rest of the database remains online and available.
c. Online Indexing Operations
Online index option allows concurrent modifications (updates, delete, and insert) to the underlying table or clustered index the data and any associated indexes during index data execution language (DDL) definitions. For example, while the clustered index is being rebuilt, you can continue to update the underlying data and perform queries against the data.
d. Fast Recovery
A selection of new, faster recovery increases the availability of SQL Server database. Administrator can reconnect to recover the database after the transaction log has been extended to the front.
e. Standards-based Information Access
Each object, the source data, or intelligence business components can be exposed using standards-based protocols such as SOAP and HTTP, eliminating the need for mid-level audiences, such as IIS, to access a Web service interface exposed by SQL Server 2005.
f. SQL Server Management Studio
SQL Server 2005 including SQL Server Management Studio, a new integrated suite of management tools with the functionality to develop, deploy, and troubleshoot a SQL Server database, as well as enhancements to previous functionality.
g. Dedicated Administrator Connection
SQL Server 2005 provides a special administrator connection that administrators can use to access the server running even if the server is locked or unavailable. This capability allows administrators to solve problems on the server by executing diagnostic functions or Transact-SQL statement.
h. Snapshot Isolation
Snapshot Isolation (SI) is provided at the database level. With SI, users can access the last committed row using a transitionally consistent view of the database. This capability provides the Greater scalability. This capability provides greater scalability.
i. Data Partitioning
Data partitioning enhanced with native table and index partitioning that enables efficient management of large tables and indexes.
j. Replication Enhancements
For distributed databases, SQL Server 2005 provides comprehensive schema change (DDL) replication, next-generation surveillance capability, built in replication from Oracle to SQL Server, merge replication over https, and significant merge replication scalability and performance improvements. In addition, peer-to-peer transactional replication feature improved support for large-scale data by using replication.
4. Are developers the new data base, provided with fictur SQL server 2005?
Features for Database Developers
a. Hosted Common Language Runtime
With SQL Server 2005 developers can create database objects using a foreign language such as Microsoft Visual C # NET and. Microsoft Visual Basic. Developers also can create two types of user-defined objects, new and aggregate.
b. Native XML Support
Native XML data can be stored, ask, and indexed in a database-SQL Server enables developers to build new classes of connected applications around Web services and on any platform or device.
c. ADO.NET version 2.0
From new support for SQL Types to Multiple Result Sets Active (MARS), ADO.NET in SQL Server 2005 growing dataset access and manipulation to achieve scalability and greater flexibility.
d. Security Enhancements Security Enhancements
Security model in SQL Server 2005 separate users from objects, provides fine-grain access, and allows greater control over data access. Additionally, all system tables are implemented as views, providing more control over database system objects.
e. Transact-SQL Enhancements
SQL Server 2005 provides new language capabilities for developing scalable database applications. These enhancements include error handling, recursive query capabilities, relational operator PIVOT, APPLY, ROW_NUMBER and other row ranking functions, and more.
f. Reliable Messaging for Asynchronous Applications
Service Broker is a powerful messaging infrastructure that provides reliable delivery of transactional important messages between the server-to-high-performance scalable expected with asynchronous queue.
g. Visual Studio Integration
Tight integration with Microsoft Visual Studio and the. Current development and debugging data-driven applications. Developers can build database objects, such as stored procedures, using any language. NET and can seamlessly debug on. NET, and Transact-SQL (TSQL) language.
h. Web Services
With SQL Server 2005 developers can develop Web services in the database tier, making SQL Server a hypertext transfer protocol (HTTP) listener and providing a new type of data access capability to service-centric Web applications.
i. Embedded Reports
Use client-side reporting controls to embed real-time reports to the application at design time.
j. Full-Text Search Enhancements
SQL Server 2005 supports a rich, full-text search applications Cataloging capability provides greater flexibility over what is cataloged. Query performance and scalability has been improved dramatically, and new management tools that provide greater insight into the implementation of the full text.
5. What is SQL server 2005 developer tools and utilytas that can be used to build the data base solution?
a. SQL Server Management Studio
This is the primary development environment for SQL Server 2005. Developers can use it to create database solutions containing all of the scripts associated with a particular database. Developers can use it to create a database solution that contains all the scripts associated with a particular database. You can use this tool to create database applications graphically, or you can create, execute, and save scripts. You can use this tool to create database applications in graphics, or you can create, execute, and save the script.
b. Business Intelligence Studio evelopment
Used to create Analysis Services solution.
c. sqlcmd SQLCMD
SQLCMD is a new command line utility that replaces the isql and osql. This provides increased functionality and performance over its predecessor.
d. Visual Studio designers
SQL Server 2005 provides a number of designers who extend Visual Studio environment and makes it easy to build SQL Server 2005 items such as reports and manage database objects.
6. Is SQL server management studio?
SQL Server Management Studio features
Management Studio replaces both the SQL Server Enterprise Manager and SQL Server Query Analyzer, and offers an improvement over the old tools. SQL Server Management Studio provides the Following features:
SQL Server Management Studio provides the following features:
a. SQL Server Management Studio
SQL Server Management Studio can be used to create and manage the project database, which contains all the relevant connections, queries, and other objects associated with the application. Some projects can be combined into a solution, making it easier to manage complex applications.
b. Integrated source control
You can use the source control system such as Microsoft Visual SourceSafe directly from SQL Server Management Studio environment.
c. Object Explorer Object
Object Explorer is a graphical tool to find and manage servers, databases, and database objects.
d. Wizards and designers
SQL Server Management Studio combines graphical wizards and designers to create database objects and query building.
Description : SQL SERVER 2005 and SQL SERVER MANAGEMENT STUDIO
URL : http://indra-combination.blogspot.com/2012/06/sql-server-2005-and-sql-server.html
Permalink : SQL SERVER 2005 and SQL SERVER MANAGEMENT STUDIO
URL : http://indra-combination.blogspot.com/2012/06/sql-server-2005-and-sql-server.html
Permalink : SQL SERVER 2005 and SQL SERVER MANAGEMENT STUDIO
