Tuesday 4 September 2012

Differences between SQL Server 2008 and SQL Server 2005

 

Data Encryption

  • Transparent Data Encryption. The ability to encrypt an entire database.
  • Backup Encryption. Executed at backup time to prevent tampering.


  • Administration

  • External Key Management. Storing Keys separate from the data.
  • Auditing. Monitoring of data access.
  • Data Compression. Fact Table size reduction and improved performance.
  • Resource Governor. Restrict users or groups from consuming high levels or resources.
  • Hot Plug CPU. Add CPUs on the fly.
  • Installation improvements. Disk images and service pack uninstall options.


  •      Development

  •  Performance Studio. Collection of performance monitoring tools.
  • Dynamic Development. New ADO and Visual Studio options as well as Dot Net 3.
  • Data Synchronizing. Development of frequently disconnected applications.
  • Large UDT. No size restriction on UDT.
  • Dates and Times. New data types: Date, Time, Date Time Offset.
  • File Stream. New data type VarBinary(Max) FileStream for managing binary data.
  • Table Value Parameters. The ability to pass an entire table to a stored procedure.
  • Spatial Data. Data type for storing Latitude, Longitude, and GPS entries.
  • Full Text Search. Native Indexes, thesaurus as metadata, and backup ability.
  • MERGE. TSQL command combining Insert, Update, and Delete.
  • LINQ. Development query language for access multiple types of data such as SQL and XML.
  • Entity Data Services. Line Of Business (LOB) framework and Entity Query Language (eSQL)
  •  Full support to Azure database.

  •  

    SSIS SSAS SSRS

  • SQL Server Analysis Server. Stack improvements, faster block computations.
  • SQL Server Integration Service. Improved multiprocessor support and faster lookups.
  • SQL Server Reporting Server. Improved memory management and better rendering.

  •  

    Supportability 

  • Microsoft Office 2007. Use OFFICE as an SSRS template. SSRS to WORD.
  • SQL 2000 Support Ends. Mainstream Support for SQL 2000 is coming to an end.

  •  

    No comments:

    Post a Comment