SYSK 349: What’s New in SQL 2008 (code named Katmai)?


Here are some of the new and improved features (extracted from David Campbell’s presentation) that will be available in SQL 2008:


      Transparent data encryption


      External key management


      Data auditing


      Pluggable CPU


      Transparent failover for data mirroring


      Declarative management framework


      Server group management


      Streamlined installation


      Enterprise system management


      Performance data collection


      System analysis


      Data compression


      Query optimization modes


      Resource governor


      Entity data model


      LINQ


      Visual entity designer


      Entity aware adapters


      SQL Server change tracking


      Synchronized programming model


      Visual studio support


      SQL Server conflict detection


      FILESTREAM data type


      Integrated full text search


      Sparse columns


      Large (> 1 page) user defined types


      Data/time data type


      LOCATION data type


      SPACIAL data type


      Virtual Earth integration


      Partitioned table parallelism


      Query optimizations


      Persistent lookups


      Change data capture


      Backup compression


      MERGE SQL statement


      Data profiling


      Star join


      Enterprise reporting engine


      Internet report deployment


      Block computations


      Scale out analysis


      BI platform management


      Export to Word and Excel


      Author reports in Word and Excel


      Report Builder enhancements


      TABLIX


      Rich formatted data


      Personalized perspectives


      … and many more


 


 


You can hear David’s webcast, and learning more about what those feature actually bring, visit http://www.microsoft.com/events/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22ID%22+Value%3d%221032341072%22%2f%5e%7earg+Name%3d%22ProviderID%22+Value%3d%22A6B43178-497C-4225-BA42-DF595171F04C%22%2f%5e%7earg+Name%3d%22lang%22+Value%3d%22en%22%2f%5e%7earg+Name%3d%22cr%22+Value%3d%22US%22%2f%5e%7esParams%5e%7e%2fsParams%5e%7e%2fCMTYDataSvcParams%5e


 


or search by event id 1032341072 at http://msevents.microsoft.com/cui/AdvancedSearch.aspx?culture=en-US


 


 


If you’re short on time, you may choose to skip the first 18 minutes containing introduction, a bit of data processing history and the new scenario-based rather than feature-based product development.


 


Here are some main time points:


 


00:00 – 18:00


Intro, history


18:00 – 23:30


New & improved features related to the secure, trusted platform, policy-based management, and optimized and predictable performance scenarios


23:30 – 28:15


Demo of declarative management


28:15 – 40:40


Features related to entity based development, storing content of any type, and SQL Server support for location-aware data


40:40 – 46:30


Demo of application & SQL Server integration with Virtual Earth


46:30 – 54:25


Data-warehouse and BI related features


54:25 – 58:20


Demo that did not work, but restarted at 59:05


59:05 – 1:05:00


Demo on how Dundas charts (will be part of SQL 2008) could improve your SSRS reports


 


 


In case you did not attend TechEd 2007, many presentations from that conference are now available as webcasts on http://www.microsoft.com/events/default.mspx.


 


 

Comments (0)

Skip to main content