Microsoft ships SQL Server 2008



Email    print   
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://sdt.bz/32675
 
Most Read Latest News Blog Resources

Add comment


Name*
Email*  
Country     


  • Comment
Loading




close
NEXT ARTICLE
Microsoft readies small business and mid-market server offerings
Microsoft's Essentials series of Windows Server products will become available in November, bringing with it a price increase for Small Business Server, as well as a new mid-market product Read More...
 
 
 
 
News on Monday
more>>
SharePoint Tech Report
more>>


   

 
 

Download Current Issue
FEBRUARY 2012 PDF ISSUE

Need Back Issues?
DOWNLOAD HERE

Want to subscribe?


 
blogs tab
Are you at risk for burnout?
Burnout is a severe problem and it can strike at any time. Here's how to tell if you are nearing the edge.
02/09/2012 02:16 PM EST

Agility, mom, and apple pie
If we're to evaluate the state-of-the-art in software development, we should start with the values espoused in the Agile Manifesto.
02/07/2012 11:57 AM EST

RIM woos developers with free tablet
How do you get more apps ported to the BlackBerry PlayBook? By giving every developer a free tablet, of course!
02/04/2012 01:57 PM EST

GitHire: Use Headhunters to Find Your Perfect Programmer
Are you a hiring manager tired of scouring the job boards? Check out this new service that will find 5 people interested in your jobs.
02/03/2012 12:17 PM EST

Facebook claims hacker cred
Facebook's SEC S-1 filing form includes a short essay on the Hacker Way by Mark Zuckerberg himself.
02/02/2012 08:26 AM EST

Ryan Dahl steps down
Ryan Dahl, creator of Node.js, steps back from his position as gatekeeper for the project.
02/01/2012 04:58 PM EST

 
Events calendar tab
2/13/2012 to 2/16/2012
Santa Clara
TechWeb

2/26/2012 to 2/29/2012
San Francisco
BZ Media

2/27/2012 to 3/2/2012
San Francisco
RSA

3/4/2012 to 3/7/2012
Las Vegas
IBM Tivoli

3/5/2012 to 3/9/2012
San Francisco
TechWeb