Top 10 Features in SQL Server 2008
April 10, 2008 by Jason Bean
Filed under Computers
Dan Rigsby (@danrigsby) shared some slides of information including his Top 10 Features of SQL Server 2008 at the IndyNDA meeting in Indianapolis, IN.
- LINQ
- Intellisense for SQL Server
- FileStream Datatype
- Date & Time Datatype
- DateTime2 & DateTimeOffset Datatype
- Hierarchical Datatype: i.e. org charts
- Spatial Datatype: geography, geometry
- T-SQL merge
- Table-Valued parameters: pass entire table into a stored procedure
- 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.
