Microsoft Weblog

Top 10 Features in SQL Server 2008

by Jason Bean on April 10th, 2008

Dan Rigsby (@danrigsby) shared some slides of information including his Top 10 Features of SQL Server 2008 at the IndyNDA meeting in Indianapolis, IN.

1. LINQ
2. Intellisense for SQL Server
3. FileStream Datatype
4. Date & Time Datatype
5. DateTime2 & DateTimeOffset Datatype
6. Hierarchical Datatype: i.e. org charts
7. Spatial Datatype: geography, geometry
8. T-SQL merge
9. Table-Valued parameters: pass entire table into a stored procedure 
10. Data Change Tracking: log all changes to data into a specific tracking table. Potentially use in offline client synchronization

What do you think about each of these features? Are you familiar with them? What are you excited about? What’s the biggest advantage you see in the new features?

Update: If you’re interested in seeing Dan’s slide-deck from the presentation, it’s available on his website here in ZIP format.

Share This

Related Stories

Windows Server 2008 - Paul Hacker presentation
Interpreting Stack Trace Information on A Server Error
Hiding SQL Databases in Directory Listing
More Information on Windows Home Server (WHS)
Microsoft Eases Up on Licensing Requirements for Virtualization

POSTED IN: Corporate News, New Products, SQL Server, Servers, Software