TechBubbles Microsoft Technology BLOG

SQL server 2005 Features

Development Features

  • CommonTableExpressions
    Which returns a record set in a statement.
    CTE can be thought of as a temporary result set which can be defined in the SELECT,INSERT,UPDATE and DELETE statements. CTE can be self-referencing and can be referenced multiple times in the same query. 

       The basic syntax structure for a CTE is:

        WITH expression_name [ ( column_name [,…n] ) ]

        AS ( CTE_query_definition )

  • CLR support To build business objects
    (stored procedures,triggers, functions, etc) which enables you to execute .NET code in the DBMS.
  • ServiceBroker handles the messaging between a sender and receiver in a loosely coupled manner.
  • Data Encryption
    Native supported functions to encrypt the data in user defined databases.
  • Microsoft incorporates SMTP mail to improve the native mail capabilities.
  • Multiple Active Result Sets(MARS) Allow a persistance database connection to server more requests from a single client.
  • SQL server Integration Services (SSIS) has replaced
    DTS(Data Transformation Services) as the primary ETL tool and ship with the SQl server for free.
  • XML enhancements
  • Try Catch Functionality
  • Data Partioning

Management Features

  • Backup enhancements
  • Better Email handling
  • Full 64-bit support
  • Database Mirroring
  • Dedicated administrator connection
  • Database snapshots

About the author

Kalyan Bandarupalli

My name is kalyan, I am a software architect and builds the applications using Microsoft .NET technologies. Here I am trying to share what I feel and what I think with whoever comes along wandering to Internet home of mine.I hope that this page and its contents will speak for me and that is the reason I am not going to say anything specially about my self here.

1 Comment

  • […] Cool Stuff » ABOUT wrote an interesting post today onHere’s a quick excerpt Development Features CommonTableExpressions Which returns a record set in a statement. CTE can be thought of as a temporary result set which can be defined in the SELECT,INSERT,UPDATE and DELETE statements. CTE can be self-referencing and can be referenced multiple times in the same query.         The basic syntax structure for a CTE is:         WITH expression_name [ ( column_name [,…n] ) ]         AS ( CTE_query_definition ) CLR support To build business objects (stored procedu […]

TechBubbles Microsoft Technology BLOG

Follow me

Archives

Tag Cloud