Shulou(Shulou.com)05/31 Report--

SQL Server 2005 top ten new features are what, many novices are not very clear about this, in order to help you solve this problem, the following small series will be explained in detail for everyone, there are people who need to learn, I hope you can harvest.

Top 10 Latest Features of SQL Server 2005

In the business world, everything competes to be "better, faster, cheaper"-SQL Server 2005 also offers many new features to save effort, time, and money. This version of SQL Server is superior to other versions in everything from administrative capabilities, and it enhances features already present in SQL Server 2000. Here I list the top ten most important new features in order of importance.

Enhanced T-SQL (Transaction SQL )

T-SQL is inherently a set-based relational management systems programming language that provides high-performance data access. It is now combined with many new features, including error handling by using both TRY and CTACH, common table expressions (CTEs) that can return a result set in statements, and the ability to convert columns to rows and vice versa via the PIVOT and UNPIVOT commands.

CLR(Common Language Runtime)

The second major enhancement in SQL Server 2005 is the integration of. NET compliant languages such as C#, ASP.NET or VB. NET which can build objects (stored procedures, triggers, functions, etc.). This allows you to execute. NET code in your database management system to take full advantage of. NET functionality. It promises to replace extended stored procedures in SQL Server 2000 environments while also extending the capabilities of traditional relational engines.

3. Service Broker

A service proxy handles messages between senders and receivers that are loosely connected. A message is sent, processed, and answered, completing the entire transaction. This greatly extends the performance of data-driven applications to meet workflow or customer business requirements.

4. Data encryption

SQL Server 2000 has no documented or publicly supported functions to encrypt data within the tables themselves. Businesses need to rely on third-party products to meet this demand. SQL Server 2005 comes with native support for encrypting data stored in user-defined databases.

5. SMTP mail

Sending mail directly in SQL Server 2000 is possible, but complex. In SQL Server 2005, Microsoft improved its mail performance by merging SMTP mail. SQL Server says "bye-bye" to Outlook!

6. HTTP terminal

You can easily create an HTTP terminal by making an object accessible on the Internet with a simple T-SQL statement. This allows a simple object to be called from the Internet to retrieve the required data.

Multiple Active Result Sets (MARS)

Multiple active result sets allow a persistent connection to be maintained from a single client to the database so that there is more than one active request per connection. This is a major performance improvement that allows developers to empower users with new capabilities while working with SQL Server. For example, it allows multiple queries, or simultaneous entry of data for a single query. The bottom line is that a client connection can have multiple active processes simultaneously.

8. Dedicated administrator connection

If everything goes wrong, you can only shut down SQL Server services or press the power key. Dedicated administrator connections end this situation. This feature allows database administrators to initiate a single diagnostic connection to SQL Server, even if the server is experiencing problems.

SQL Server Integrated Services (SSIS)

SSIS has replaced DTS(Data Transfer Service) as the primary ETL(Extract, Transfer and Load) work and is released free of charge with SQL Server. The tool, completely rewritten since SQL Server 2000, now has a great deal of flexibility to meet complex data movement needs.

10. Database Mirrors

I don't expect this feature to ship with SQL Server 2005 in RTM in November, but I think it has a lot of potential. Database mirroring is an extension of local high availability capabilities. All, still tweaking more details…so now, bless.

Two other technologies that can't be left out of SQL Server 2005's top ten list are its analytics services and reporting services. Although SQL Server 2005 does not introduce any of these, they are integrated into SQL Server Integrated Services to complement Microsoft's core business intelligence suite. These technologies are critical to business intelligence success. Learn new features and how the enterprise can implement them in real projects.

Did reading the above help you? If you still want to have further understanding of related knowledge or read more related articles, please pay attention to the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.