WHITE PAPERS SPONSORED PROFILES JOB BOARD WEBINAR CENTER FREE SOFTWARE BZ RESEARCH ALMSHAREPOINT EVENTS CALENDAR PRINT/PDF EDITION PRINT/PDF BACK ISSUES

SUBSCRIBE TODAY CUSTOMER SERVICE EDITORIAL BEATS GUEST VIEW GUIDE SD TIMES 100 GUIDE EVENTS CALENDAR ADVERTISING ARTICLE REPRINTS REPORT A BUG SITE MAP

ABOUT US BZ MEDIA NEWS BZ RESEARCH NEWS ON MONDAY SPTECHREPORT SPTECHWEB SPTECHCON IPHONE/IPAD DEVCON ANDROID DEVCON PRIVACY POLICY CONTACT US

HOME >> LATEST NEWS

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://sdt.bz/32675

Most Read Latest News Blog Resources

Android is the focus of two new design tools
Anywhere Software and Xamarin provide ways for developers to create and test their applications on PCs

LEADTOOLS HTML5 add-on modules released
Including New HTML5 Zero Footprint Viewer, JavaScript Libraries and RESTful Web Services for Document and Medical SDKs

How to speed up your Cukes
Using a five-step process derived from Six Sigma, Cucumber tests can go much faster

WhiteSource offers open-source license management as a service
Software gives companies insight into the open-source components in products

SmartBear rolls out new quality solution: API Complete
Software gives organizations ability to write test scripts and monitor APIs by bridging the DevOps divide

Android is the focus of two new design tools
Anywhere Software and Xamarin provide ways for developers to create and test their applications on PCs

WhiteSource offers open-source license management as a service
Software gives companies insight into the open-source components in products

Top five devices you can integrate with your applications
A five-fingered list of common, household items with which you can talk to (via software, of course)

Slick...but who needs it?
compilr.com is a well-designed site and the folks behind it seem to have their heart in the right place. But...who needs it?

How to be a better software developer
Want to be a better developer? You won't get there by mastering an interesting language or learning a new set of APIs.

Wooing Galatea
Do yourself a favor and check out Galatea 2.2, a wonderful book by novelist Richard Powers.

The world as story
An artificial-intelligence system at Carnegie Mellon seeks to understand the world by making statements about it.

Five SCM Best Practices Two-thirds of all software projects fail, according to the Standish Group’s CHAOS study. Improper usage of software configuration management...

Best Practices for Branching and Merging Patterns

Development teams often create a branching pattern, usually drawn out on a white board or in a Visio document, that is used as a model to...

Automated Error Reporting We invite you to read a short e-zine that tells you all about automated error reporting for .NET applications. This 8-page e-zine is packed...

The End of Application Redeploys Imagine that every time you wanted to write, send or receive an email, you needed to restart your computer. How much time would this take, a...

Technorati

Digg

Slashdot

Facebook

Friendfeed

Twitter

del.icio.us

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.

Why program Microsoft SQL Server from .NET? Microsoft's José Blankley gives three situations in which programming the database from .NET is a sound option. He says that .NET is good for building core database constructs, for instance.

Microsoft places SQL data service up in the ‘cloud’ Details are unveiled concerning a new Web-based data server based on cloud computing, with developers being the target audience.

Add comment

Name*
Email*
Country

Comment

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
MAY 2012 PDF ISSUE

Need Back Issues?
DOWNLOAD HERE

Want to subscribe?

Slick...but who needs it?
compilr.com is a well-designed site and the folks behind it seem to have their heart in the right place. But...who needs it?
05/16/2012 12:45 PM EST

How to be a better software developer
Want to be a better developer? You won't get there by mastering an interesting language or learning a new set of APIs.
05/14/2012 12:18 PM EST

Wooing Galatea
Do yourself a favor and check out Galatea 2.2, a wonderful book by novelist Richard Powers.
05/12/2012 07:05 PM EST

The world as story
An artificial-intelligence system at Carnegie Mellon seeks to understand the world by making statements about it.
05/10/2012 06:39 AM EST

The Rise of the Brogrammer, or the Rise of the Sexist Programmer?
Women in Silicon Valley get vocal about sexist ads and campaigns that contribute to a tense work environment.
05/09/2012 03:14 PM EST

Retriever Communications Releases RADE3
Organizations concerned about the growing popularity of bring your own device to work policies may be comforted by the release of RADE3.
05/09/2012 11:46 AM EST