About SQL Server2005, it should be up to 13 things

Source: Internet
Author: User
Tags ibm database management studio sql server management sql server management studio ssis

About SQL Server2005, it should be up to 13 things

SQL Server 2005: The 13 things you should know


Microsoft's release of SQL Server 2005 official version has been around for almost a year. With the latest two research reports, SQL Server

2005 has aroused the industry's concern and comments-Microsoft with SQL Server 2005 has achieved more than the Oracle and IBM database products market accounted for

Rate of growth. However, there are a few things you should know about SQL Server 2005, which is less than one year old, listed in this article

13 things you should know about SQL Server 2005.

New features in SQL Server 2005

1. New Product Version

In addition to SQL Server 2005 Standard Edition and Enterprise Edition, SQL Server 2005 Lite is also included in the product line (SQL Server

2005 Express) and two new versions of Workgroup Edition (SQL Server 2005 Workgroup).

SQL Server 2005 express--its role is to replace the Microsoft SQL Server Desktop Engine (Microsoft SQL Server

Desktop engine,msde). SQL Server 2005 Express can be used for free publishing and uses the same off as SQL Server

Database Core engine. The difference is that it does not use Query manager like MSDE. The only limitation is a cpu,1g of memory and every

4G of storage space for a database.

SQL Server 2005--Workgroup Edition is not free to publish. It is designed to focus on Server Message Block Protocol (SMB) and sub-

Departmental solutions. In quantitative performance, it is better than SQL Server 2005 Express and can provide support for relational databases, just

The analysis service is missing. Workgroup Edition limited to two cpu,3g memory, database size unlimited.

2. New subsystems

Driven by a number of new subsystems, application support in SQL Server 2005 is very powerful, including consolidation services,

Services, service agents, and Reporting Services.

Consolidation services-600% faster than DTS, which previously was responsible for this feature. SQL Server Consolidation service is a powerful workflow

Enterprise-Class ETL platform with control capability.

Reminder Service--can provide an application framework for building a custom alert program.

Service Broker-provides asynchronous process processing capabilities for establishing highly quantified programs.

Reporting Services-This is one of the most desirable features to upgrade. Reporting Services is an enterprise-level report generation platform that can be used for design, deployment,

A detailed report on sales. The powerful Reportbuilder component enables end users to enjoy Reporting Services as well.

3. Integrate the new. NET Framework

One of the biggest enhancements to SQL Server 2005 is the consolidation of the. NET Framework. Enable the new. NET Integration feature, you can

To easily create stored procedures, functions, triggers, custom types, custom datasets. You can at any. NET language use of EXEC

sp_configure ' clr enabled ', ' 1 ' command enables CLR support. If you're still using past, non-managed extended stored procedures

, the sqlclr stored procedure should be replaced immediately.

3. New data types

Two new data types were added in SQL Server 2005: XML and varbinary (max).

XML data Type--can be used to store typed or untyped XML data in a SQL Server database, and through XQuery into

Row queries.

Varbinary (max) data type--you can store and read binary data, such as images, as you would access normal data.

4. New Point-to-point transactional mapping

With the new features in SQL Server 2005, we can easily grasp the biggest changes Microsoft has made to mapping. Point-to-point transactions

Type mapping is designed for bidirectional mapping, which allows two or more databases to be synchronized when any one of the acknowledgements changes.


Features that are missing from SQL Server 2005

6. Data mirroring

No doubt, data mirroring is a feature that has been missing since the release of the RTM version of SQL Server in November 2005, because

It is one of the main reasons why enterprises are determined to upgrade to SQL Server 2005. This feature is expected to be re-added in the second half of 2006



7.SQL Quick Manager

The Quick manager tries to provide a graphical management interface for SQL Server 2005 Express. However, its function is limited and it runs slowly

, Microsoft had to abandon it in SQL Server Management Studio and rename it to express.

How do I find these features in SQL Server 2005?

If you are using SQL Server 2005 for the first time, you may be dazzled by a number of new features and interface changes. With any one

SQL Server 2005 has the largest number of changes compared to a single version. You may find that in SQL Server 2000 or SQL Server 7

Used tools have been modified or removed.

8.SQL Server Service Manager

After you upgrade to SQL Server 2005, you may have questions: is the upgrade really done? Because you'll find the System icon

Service Manager is missing. SQL Server Service Manager has been replaced with SQL Server Configuration Manager and can be

Program->sql Server 2005-> management tool->sql Server Configuration Manager, or right-click on "My Computer-managed"

After you open the service and configure the tab to run.

9. Enterprise Manager

To find a new manager is a bit of a hassle, but you'll soon find out in SQL Server 2005, SQL Server Enterprise Manager (SEM

) has been replaced by the SQL Server Admin Center (SSMS). SSMs runs faster in the management of a large number of objects and servers.

All operations can be implemented in a script. And most dialogs are not traditional dialog boxes, and you can better handle multiple tasks at the same time.

10. Query Analyzer

The most important query parser for developers and database administrators has been replaced by the Query Editor. You can select in the Admin Center

Select New query to invoke it. The Query Editor provides basic parser functionality for writing and running T-SQL query statements, and can be

SourceSafe integration for version control. However, the query editor lacks the ability to debug T-SQL statements. You need to use visual Studio

2005 of the database project to be debugged.

11. Analysis Service Manager

In SQL Server 2005, Microsoft revolutionized the management and development configuration of analytics services. Previous Analytics Service Manager was SSMs

and the Business Intelligence Development Center (BIDS). The management of Analysis Services is handled by SSMS, and development tasks such as creating and deploying cube structures are

Bids processing.

12.DTS Designer

In SQL Server 2005, DTS is replaced by SQL Server Consolidation Services (SSIS). In the process, the previous DTS Designer

Replaced by the new SSIS Designer. In SQL Server 2000, DTS Designer is started in Enterprise Manager. and SSIS Designer is the

Start in bids. Open bids, select Integrated Services Project, business Intelligence Project, new project, file, and so on to start SSIS Designer.

13. Import/Export Wizard

The menu does not have this option, but it is not deleted and you can run Dtswizard.exe in command-line mode to find it (do not

Is literally deceived, this program is used by SSIS, not DTS). You can also open an SSIS project and right-click on the SSIS package to start

Import/Export.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.