LOGIN | REGISTER NOW | SUBSCRIBE
 
print Printable version 
Most Read Latest News Blog Resources
Does Windows cost Microsoft opportunities?
Microsoft's decision to focus .NET on Windows is stifling innovation due to the specter of...

Mono brings .NET to Android
At Microsoft MIX, Mono will unveil the ability to port .NET applications to the Android op...

OSBC focus turns to best practices for open-source adoption
Businesses are no longer asking why they should adopt, but how do they use open source leg...

Digg!  Digg
Reddit  Reddit
Slashdot  Slashdot
Share on facebook  Facebook
Share on Twitter  Twitter

Microsoft ships SQL Server 2008


By David Worthington
August 6, 2008 — 
Many months after its official launch event, Microsoft today has delivered SQL Server 2008 to customers. The server is the vehicle for Microsoft’s ADO.NET data entity framework and is designed to accommodate large-scale data warehousing.

SQL Server 2008, formerly known by the code name "Katmai," is immediately available to MSDN and TechNet subscribers; pricing will remain consistent with SQL Server 2005. It ships in seven varieties, each targeting a different subset of customers.

Two of those versions, SQL Server 2008 Express and SQL Server Compact editions are generally available as a free download today.

Microsoft held a triple play launch event in February for SQL Server, Visual Studio 2008 and Windows Server 2008. SQL Server is the last of those products to ship, due in part to its introduction of a new data entity framework that is rooted in the company’s shelved Windows Future Storage effort.

The server includes Microsoft’s next-generation ADO.NET Entity Data Model (EDM), a model-based concept that provides developers with an additional layer of abstraction between the database and themselves. EDM enables custom views of the database for applications; entities are independent of their underlying data store representations.

The entities can be retrieved and queried natively within any .NET language by using LINQ (Language Integrated Query). In that vein, Microsoft also keyed in on data warehousing.

The server’s data warehousing capabilities are more advanced than SQL Server 2005, with updates to SQL Server Integration Services to load and add data to a data warehouse, and the SQL Server engine’s change-capture functionality.

It can also synchronize data from devices to the central data store and has support for geospatial data.

Additionally, Microsoft has integrated SQL Server with Microsoft Office system front-end tools to provide for more reporting capabilities. The database also introduces a rules-based system that defines a common set of policies for database operations, as well as new resource governing and failover capabilities.


Related Search Term(s): SQL Server, Microsoft


Share this link: http://www.sdtimes.com/link/32675
 

Add comment


Name*
Email*  
Country     


  • Comment
  • Preview
Loading



 
 
 
 
News on Monday
more>>
SharePoint Tech Report
more>>


   

 
 
Download Current Issue
ISSUE 3/15/2010 PDF

Need Back Issues?
DOWNLOAD HERE

Receive the print Edition?


 
blogs tab
Google Code turns 5
Google Code Turns 5, and adds a Paxos Algorithm to make the system more stable and reliable.
03/17/2010 11:16 AM EST

Test your Visual Studio 2010 know-how
Microsoft is offering free beta certification exams for Visual Studio 2010.
03/17/2010 11:08 AM EST

Microsoft lifts the hood on IE9
Microsoft is previewing IE9.
03/16/2010 01:10 PM EST

 

Events calendar tab
EclipseCon
3/22/2010 to 3/25/2010
Santa Clara, Calif.
The Eclipse Foundation

DevConnections
4/12/2010 to 4/14/2010
Las Vegas
Penton Media

MySQL Conf. and Expo
4/12/2010 to 4/15/2010
Santa Clara, Calif.
O'Reilly Media

High Performance Computing Linux Financial Markets
4/19/2010
New York City
Flagg Management

Informix User Conf.
4/25/2010 to 4/28/2010
Overland Park, Kans.
IIUG