Wednesday, September 19, 2007

SQL Server 2008 Spec sheets are OUT!!

Well it looks like Microsoft has released the new spec sheets on SQL Server 2008 and man there is a lot of sweet stuff they have added.

Here are the highlights..

  • Policy-based Management
    A framework that enables policies to be defined for explicit and automated administration of server entities across one or multiple servers.

  • New Language Integrated Query (LINQ) extensions
    This enables developers to be more productive by working with logical data entities that align with business requirements instead of programming directly with tables and columns.

  • Beyond relational data
    New data types such as a geospatial type, filestream type, 4 new data & time types and a Hierarchy ID type have been added.

Another really cool feature that will help in the swelling of database sizes is the addition of Sparse columns. Its a highly efficient way of managing empty data in a database by enabling NULL data to consume no physical space.

I'm sure all the GIS nerds out there are chopping at the bit to get there hands on the new geospatial functionality. Well its here and it looks very promising.

Check out some of the features below...

Comprehensive Spatial Support

  • Work with geodetic and planar data types
    Implement Round Earth solutions with the geography data type; using latitude
    and longitude coordinates to define areas on the Earth’s surface. Implement
    Flat Earth solutions with the geometry data type; storing polygons, points,
    and lines that are associated with projected planar surfaces and naturally
    planar data, such as interior spaces.

  • Build on industry standards
    Import and export spatial data in industry-standard formats, such as Well
    Known Text, Well Known Binary, and Geographic Markup Language (GML).

  • Perform spatial operations
    Use the methods provided by SQL Server 2008 spatial data types to write
    Transact-SQL code that performs operations on spatial data, such as finding
    intersections between geospatial objects and distances between locations.

High Performance Spatial Data Capabilities

  • Store large and complex spatial objects
    Use the spatial types in SQL Server 2008 to accommodate spatial objects,
    regardless of whether the objects are simple or very complex.

  • Build high-performance solutions with spatial data indexing
    Enhance query performance by using indexes for spatial data that are
    integrated into the SQL Server database engine. Take advantage of accurate
    query optimizer cost assessment for spatial queries that can determine the
    optimal query plan and identify appropriate index selection.

  • Consolidate relational and spatial data in business applications
    Use the native support for spatial data types in SQL Server 2008 to
    seamlessly incorporate spatial data into line-of-business applications.

Geospatial Application Extensibility

  • Build spatial solutions of any scale
    Take advantage of spatial support in multiple editions of SQL Server 2008,
    from SQL Server Express to SQL Server Enterprise Edition.

  • Use spatial standards support to integrate applications
    Leverage a .NET-based geometry library that supports OGC standards. Build
    applications that consume and manipulate spatial data. Integrate with
    geospatial services, such as Microsoft Virtual Earth™, to build
    comprehensive location-enabled solutions that render your spatial data for

  • Benefit from spatial community support
    Take advantage of spatial products and services offered by Microsoft
    partners that integrate with SQL Server 2008.

These are just the highlights. There is a ton of additional enhancements and features they've added that's really worth looking at.
Get more info here...SQL Server 2008


Anonymous said...

Your blog keeps getting better and better! Your older articles are not as good as newer ones you have a lot more creativity and originality now keep it up!

Donny said...

Thanks ;-)