Well, it looks like SQL 2008 is just around the corner, but it seems rather quiet for a new release. Maybe it's a small release, or MS isn't using all the marketing power.
Anyway, as the end of support for SQL 2000 is just 2 months after, looks like a comppeling reason to upgrade :)
Among the features for development that I like more are:
- Auditing data changes (new T-SQL command AUDIT that allows auditing centralization)
- Integration with Linq, Entity Framework, .NET 3.0
- MERGE statement (allows update, insert and delete in a single statement)
- Some general nice additions (that I won't use much, but look good to have), like date and time data types, file streams (uses the file system to store files pointed by the database), table valued parameters and Spatial Data
In the administration area, there are also some highlights:
- Data compression (those that worked with medium databases, know what a hassle it is to manage files with 100 GB in storage with less than 0,5 TB)
- Data encryption (columns, database)
- Resource Governor (limit resource usage by users or groups)
- Hot-plug CPUs!
- To end the long post, some links about all the new features in more detail:
SQL Server 2008 Improvement Pillars
What's new in SQL 2008 Part 1
What’s new in SQL 2008 Part 2
What’s New in SQL Server 2008 Part 3
1 comment:
Authentic Ed Hardy Clothes
from the Cool Ade accumulating featuring the Aitana Tote backpack in black. The hardy shirt
is one of a lot of accepted bags. I wish to acquaint some types of hardy shirt
here. Authentic hardy shirts
featuring the Beatrice N/S Tote backpack in putty.
Tiffany co
produces their articles with the aforementioned techniques, and top superior abstracts accomplish silver rings
angle out aloft bargain imitations. Although aboriginal Tiffany earrings
works can be big-ticket collector’s items, silver earrings
are affordable alternatives that are works of art in their own right.
Post a Comment