SQLAuthority News – Release of SQL Server 2008 R2 Announced

SQL Server 2008 R2 expands on the value delivered in SQL Server 2008 by providinga wealth of new features and capabilities that can benefit your entire organization. This release will further improve IT Efficiency with new and enhanced management capabilities and empower business users to access, integrate, analyze and share information using business intelligence tools they already know.

  • Capitalize on Hardware Innovation
  • Optimize Hardware Resources
  • Manage Efficiently at Scale
  • Enhance Collaboration Across Development and IT
  • Improve the Quality of Your Data
  • Manage User-Generated Analytical Applications
  • Report with Ease
  • Get More Out of Your Data
  • Build Robust Analytical Applications
  • Consolidate Your Data
  • Share and Collaborate with Confidence

Read more here.

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

SQLAuthority News – Download Cumulative update package 3 for SQL Server 2008

For almost one year I have been using SQL Server 2008 and I keep watch on its update. Cumulative Update Package 3 has been made available now. Latest SQL Server 2008 version is 10.0.1787.0.

Download Cumulative update package 3 for SQL Server 2008

Abstract courtesy : Microsoft

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

SQLAuthority News – Download Microsoft SQL Server 2005 Service Pack 3

Service Pack 3 for Microsoft SQL Server 2005 is now available. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP3. You can use these packages to upgrade any of the following SQL Server 2005 editions:

  • Enterprise
  • Enterprise Evaluation
  • Developer
  • Standard
  • Workgroup

Download Service Pack 3 for Microsoft SQL Server 2005

Abstract courtesy : Microsoft

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

    SQLAuthority News – Cumulative update package 1 for SQL Server 2008

    Cumulative update package 1 for SQL Server 2008 is released.

    Click on link : http://support.microsoft.com/kb/956717/en-us

    Update : I have received few emails where developer did not find where to click on the support page to download the update package. Following image describes the link which is on very top of the page.

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

    SQLAuthority News – Security Update for SQL Server 2005 Service Pack 2

    Developers who are using SQL Server Service Pack 2 must install this security patch for it. A security issue has been identified in the SQL Server 2005 Service Pack 2 that could allow an attacker to compromise your system and gain control over it. You can help protect your computer by installing this update from Microsoft. After you install this item, you may have to restart your computer.

    Download Security Patch for SQL Server Service Pack 2

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

    SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported

    While attending conference SQLAuthority Author Visit – Microsoft Student Partner Conference, some developers informed me that SQL SERVER 2008 cannot be connected to Visual Studio 2008 and error displays as MS does not support SQL Server version. I was surprised initially as I could not believe that two MS products are not compatible. When trying myself I got the same error.

    SQL Server 2008 when connected to Visual Studio 2008 gives the error that “This server version is not supported.  Only servers up to Microsoft SQL Server 2005 are supported“.

    This error can be easily resolved by just installing Service pack. Download Visual Studio Service Pack 1 and install. Once service pack installed it will connect just fine.

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

    SQL SERVER 2005 – Microsoft Will Release SP3 Soon

    I have received quite a few inquires if Microsoft is going to release SP3 for SQL Server or not?

    Yes! Microsoft is going to release SP3 very soon. The exact date is not announced yet. You can read the announcement of SP3 here.

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