SQLAuthority News – SQL Server 2008 R2 – Release Date in May 2010

Microsoft has announced that SQL Server 2008 R2 will be available by May 2010. Its CTP (Community Technology Preview) version was already available from August 2009. It is still available for download.

This new release offers many benefits over the previous versions. Also, the pricing has not been revealed thus far.

What’s new?

  • Master Data Services: This technology deals with the secure and direct management of master data, ensuring its integrity.
  • StreamInsight Technology: This technology deals with complex high-scale event processing.

Benefits

This technology has helped the IT departments of many prominent industries to effectively manage and monitor information centrally. Some of the major highlights of this technology are as follows: the central management of information, including databases; and support for virtualization and Live Migration. It also supports the effective deployment and development of applications.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Microsoft has announced that SQL Server 2008 R2 will be available by May 2010. Its CTP (Community Technology Preview) version was already available from August 2009. It is still available for download.

This new realese offers many benefits over the previous versions. Also, the pricing has not been revealed thus far.

What’s new?

  • Master Data Services: This technology deals with the secure and direct management of master data, ensuring its integrity.
  • StreamInsight Technology: This technology deals with complex high-scale event processing.

Benefits

This technology has helped the IT departments of many prominent industries to effectively manage and monitor information centrally. Some of the major highlights of this technology are as follows: the central management of information, including databases; and support for virtualization and Live Migration. It also supports the effective deployment and development of applications.

About these ads

9 thoughts on “SQLAuthority News – SQL Server 2008 R2 – Release Date in May 2010

  1. Hi pinal

    i have created the table valued function Getreport with parameter @Deliverdate

    i have also created SP GetReportDetails with various columns in select list and selecting the Table valued function in subquery as follows

    SELECT FacilityId,Name,Address1,
    (select * from dbo.GetPrizeForCubist(@EndDate))as ‘Prize’

    IT returns the error as

    (95 row(s) affected)

    (101 row(s) affected)

    (65 row(s) affected)
    Msg 116, Level 16, State 1, Line 53
    Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

    i dont have enough knowledge with this error.

    provide me the solution

    Thankx:)

    • Hi Senjay,
      It seems like you are trying to get two result sets in one query. The result from the table valued function probably has to be inserted into a table, then join that table to the query containing select facility.
      You could possibly post the complete query…then we can check it out.

  2. small mistake i have made

    (select * from dbo.GetPrizeForCubist(@EndDate))as ‘Prize

    not the function name and the function is

    (select * from dbo.Getreport(@EndDate))as ‘Prize

  3. The Streaminsight technology looka very interesting, read an article on sqlservercentral about it. It looks at real time business intelligence and working with continous stream of input data.

  4. hai

    i have a table named products.

    it has date,price and description as columns.

    i want to retrieve the values within specified date range and if not previous date

    example

    if i give the year as 2009

    if not in table it should return 2008 or 2007 or some previous year value for different description and different price as in table

    Thankx:)

  5. Pinal,

    There is one BIG point to watch out for with 2008 R2, which just caught us by surprise. It’s not documented anywhere that I can find. Only in blogs and forums where people have hit this trap.

    We have production and test servers running SQL 2008. We do not have “Software Assurance.”

    We downloaded and installed SQL 2008 R2 on our development computers.

    We developed new databases, then tried to copy and attach the files to a test server. We got this nice message:

    “The database ‘dbName’ cannot be opened because it is version yyy. This server supports version xxx and earlier. A downgrade path is not supported.”

    So everybody watch out!
    Database files from “2008 R2″ are NOT compatible with “2008.” They changed the file structure, and thus the “database version.”

    If you have paid extra for “Software Assurance,” then you can get a “free” upgrade for your 2008 servers. Basically, though, you can’t upgrade to R2 unless you send money to Microsoft one way or another.

    Microsoft SHOULD HAVE released R2 as “SQL 2010″ and version 11.x. But they did not, even though this is a major breaking change.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s