Katmai (Sql 2008) – The List of New Features


So, I've been getting quite a few pings about providing a list of new features to look for in Katmai (Sql 2008) and/or those that I'll be either blogging about and/or presenting on at the DC area groups I mentioned here: http://blogs.msdn.com/chadboyd/archive/2007/07/18/katmai-sql-server-2008-presentations-in-the-dc-area-novasql-caparea-net-cmap.aspx


Well, I put together a list below, and this isn't even everything (though it's a lot of the major stuff) - I even tried to categorize it (and some things may appear in multiple categories). I'll be blogging/presenting/etc. on many, many of these in the coming months, so stay tuned:


  Security/Auditing
     - Transparent Data Encryption (encryption while data is 'still' on disk, transparent to applications)
     - External Key Management (Consolidation of key management, integration with external products)
     - Data Auditing (1st-class 'AUDIT' objects; DDL support; audit objects, principals, data, etc.; support for multiple logging targets)
    
  Availability/Reliability
     - Pluggable CPU support
     - Enhanced Database Mirroring (compression of mirror streams, enhanced performance, automatic page-level repair for principal/mirror)
   
  Performance
     - Data compression (easy to enable/disable online, more efficient data storage (this is NOT traditional data compression))
     - Backup stream compression (server level control or backup statement control, all backup types)
     - Performance data collection (single, common framework for data collection, reporting, and storage/warehousing)
     - Improved Plan Guide support (plan freezing, pull plans directly from plan cache, SSMS integration, etc.)
     - Resource Governor (create pools and groups to govern, define classifications based on built-in functions, segment resource utilization amoung groups)
 
  Management
     - Policy-based management framework (manage via policies vs. scripts, enterprise-wide support, automated monitoring/enforcement, etc.)
     - Integrate with Microsoft System Center
     - Extended Events (high perf lightweight tracing infrastructure, NOT sql trace, integrated with ETW, unprecidented insight into goings-on)
    
  Development Enhancements
     - Improved datetime datatypes (100th nanosecond precision (7 digits past second), time-zone datetime offset, date only, time only)
     - HierarchyID datatype (hierarchical-aware data type, ORDPath values, built-in functions, methods, etc.)
     - Entity Data Model support (develop 'business entities' vs. tables, model complex relationships, retrieve entities vs. rows/columns)
     - LINQ
     - Sql Server Change Tracking (Change Data Capture, get 'diff' data changes WITHOUT a comparible value (i.e. datetime, timestamp, etc.))
     - Table Valued Parameters
     - MERGE statement ('upsert' data, also includes deletion functionality)
     - Large UDT's (no more 8000 byte limit on CLR-based UDTs, no more 8000 byte limit for UDA's)
     - Spatial data (GEOMETRY and GEOGRAPHY data types, built-in spatial function support, spatial indexes)
     - XML enhancements (support for lax validation, office 12 support, xs:dateTime support, lists/union types, LET FLOWR support, etc.)
     - Inline initialization and compound assignment
    
  Service Broker
     - New UI and Tools for working with (add/drop/edit functionality within SSMS, Diag tools, )
     - Conversation Priority (set message ordering, send/receive impact, 1-10 levels)
  
  Data Storage
     - Data compression (see above)
     - FILESTREAM attribute (get the 'best of both' functionality from BLOBs in the DB vs. BLOBs on filesystem, no more "to blob or not to blob")
     - Integrated Full Text Search (FTS fully integrated into DB engine, no external storage, no external service, more efficient and reliable costing)
     - Sparse columns (more efficient storage for 'wide' tables with many columns that repeat and don't contain data)
     - New index types (spatial indexes, hierarchical indexes, FILTERED indexes (indexes on filtered values within columns), etc.)
  
  Data Warehousing/ETL
     - Partitioned Table Parallelism (no more thread limit per partition)
     - Star Join support (no special syntax, optimizer based, full backward syntax support)
     - Data compression (see above)
     - Resource Governor (see above)
     - Persistent Lookups in SSIS (no more re-querying for lookup operators, cache lookups in multiple ways, persist lookups to disk)
     - Improved thread scheduling in SSIS (shared thread pool, pipeline parallelism)
     - Change Data Capture (see above)
     - MERGE statement (see above, great uses with slowly changing dimensions)
     - Scale-out analysis services (read-only storage supports multiple AS servers)
     - Subspace computations
     - New Tools for Cube design
     - Best Practice Design Alerting
     - Backup cubes with better scalability
     - Data-mining add-ins for Excell
    
  Reporting
     - IIS Agnostic Reporting Services Deployment (no IIS required to run RS any longer)
     - Rich-text support
     - Enhanced visualiztion (graphing)
     - New Word rendering (render reports to Microsoft Word)
    
  Deprecation
     - Many 'old' features ARE REMOVED/GONE (those that have been deprecated for some time - 60/65/70 compat modes, nolog / truncateonly syntax, etc.)



That's the list I've got for now...I'm sure I missed something or 2, and I'll continue to add to the list if I see something left out. I'm sure there are LOTS of questions around each of these, so I'll be continuing to blog on subsets of the features in-depth over the next few weeks/months. If there are specific questions, by all means post to this blog and/or email me via this blog, and I'll be sure to answer them directly or in a post covering the topic in question. Stay tuned!


Chad Boyd ~~~ This posting is provided "AS IS" with no warranties, and confers no rights. Use of any included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm.


Comments (13)

  1. Mabsterama says:

    Over on the Sql Stuff blog , Chad’s posted a list of new features in next release of SQL Server (due

  2. I took some time to look at the ”nifty" features in SQL Server 2008. There is a long list of new features

  3. Sql Stuff has an overview of Katmai (Sql 2008) – The List of New Features .

  4. binarymechanic says:

    Does the Full-text integration mean that full-text indexes can now be partitioned like tables?

  5. La próxima versión de SQL Server ofrecerá una serie de características interesantes, de performance y

  6. Spruce Media says:

    Hi binarymechanic. Unfortunately, no, this is not allowed in RTM at this point for Katmai and Integrated FTS.  FT Indexes will be monolithic and per table, like in former releases, however, this time it will be part of the engine.  I can tell you that this is a feature that’s extremely high on the list of features for Katmai + 1 release, but obviously can’t guarantee anything.

    Thanks!

  7. Pawel Tarnik says:

    Just one question: will there finally be Intellisense in SQL Server Management Studio?

    Thanks.

  8. Para quienes se preguntan cuáles son las nuevas características de SQL Server 2008. Security/Auditing

  9. Para quienes se preguntan cuáles son las nuevas características de SQL Server 2008. Security/Auditing

  10. reagan83 says:

    Great writeup Boyd.

    I’m also wondering if there is going to be intellisense in SSMS for SQL Server 2008?

  11. Spruce Media says:

    Hi guys – unfortunately I don’t believe intellisense is being included – I’ll double check to verify, but that’s not on the list to my knowledge.

  12. ryangaraygay says:

    I can’t seem to find any "Intellisense" feature in SQL 2008 July CTP. Am I missing something or it’s really not there? Any word on whether any work is done with regards to this?

  13. SQL Server 2008 comes with the following list of improvements (Do I miss anything?): Transparent data

Skip to main content