SQL SERVER – SQL Server 2008 R2 Service Pack 3 – Download

It has been a long time since SQL Server 2008 R2 got Service Pack Update. Microsoft has finally released SQL Server 2008 R2 service pack  3and its feature pack. SQL Server 2008 R2 SP3 contains fixes to issues reported as well as Hotfix solutions have provided since SQL Server 2008 R2 Service Pack 2 up to and including Cumulative Update 13.

I have personally switched to SQL Server 2014 few months ago and I am happy with its performance and robust behavior. Many of the customer and clients are still using SQL Server 2012. However, if you are using SQL Server 2008 R2, I suggest that you look at upgrading to the latest version of SQL Server or at least update your software with latest service pack.

You can download SQL Server 2008 R2 Service Pack from following link:

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

SQLAuthority News – SQL Server 2012 Service Pack 2 is Available

updatesstamp SQLAuthority News   SQL Server 2012 Service Pack 2 is AvailableMicrosoft has announced SQL Server 2012 service pack 2 is available earlier this week. Service packages are cumulative updates and upgrade all editions of SQL Server 2012. This service pack contains up to and including SQL Server 2012 Service Pack1 Cumulative Update 9 (CU9). Here is the list of the bugs which are fixed in SQL Server 2012 SP2.

If you are facing any of the following issues and have not installed any of the cumulative updates, you should indeed update to SQL Server 2012 SP2. On my personal development server, I have upgraded this SP2 and after a week’s testing, I am planning to roll it out to my production server.

I am very excited about the bug fix of Poor Performance when using table variables, as I had just talked about during my last presentation in India.

  • Can’t connect to the server when you run a cube creation MDX query in SSAS 2012
  • Image is not displayed correctly in the webpage when you use DrillThrough action on an SSRS 2012 report
  • Text truncated when you use HPB renderer to view a report in SSRS 2012
  • SQL Server crashes when the log file of tempdb database is full in SQL Server 2012
  • SSRS 2012 fails with IsolatedStorageException when subscriptions exported to Excel worksheets are larger than 10 MB
  • SSRS 2012 cannot export a report that is larger than 10 MB to Excel format
  • Rollback causes database to go to suspect mode in SQL Server 2012
  • Poor performance when you run a query against a table in an RCSI-enabled database in SQL Server 2012
  • New DMF sys.dm_fts_index_keywords_position_by_document in SQL Server 2012 SP2
  • New log files are not created when you restart the Reporting Services Windows Service in SSRS 2012 on January 1
  • No error message when log backup failed in SQL Server 2012
  • Visual Studio 2012 crashes because of access violation when the data source binding is completed in Report Viewer 2012 UI in local mode
  • File Share subscription doesn’t populate the description column in SSRS 2012
  • The “Name” drop-down list is empty when an SSRS 2012 report is specified
  • Event ID 22 or error 0xC1000016 will be logged when you use Discover command in SSAS 2012
  • Performance issues when you use SSISDB as your deployment store in SQL Server 2012
  • SSAS 2012 logging feature improvement in SQL Server 2012 Service Pack 2
  • Poor performance when you use table variables in SQL Server 2012
  • Access violation occurs when you run CHECKTABLE or CHECKDB against a table that has persisted computed columns in SQL Server 2008 R2 or SQL Server 2012

You can download SQL SQL Server 2012 from this download link.

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

SQLAuthority News – Microsoft SQL Server 2012 Service Pack 1 Released (SP1)

Last week, I was attending SQLPASS 2012 and I had great fun attending the event. During the event long awaited SQL Serer 2012 Service Pack 1 was released. I am pretty excited with SP1 as new service packs are cumulative updates and upgrade all editions and service levels of SQL Server 2012 to SP1. This service pack contains SQL Server 2012 Cumulative Update 1 (CU1) and Cumulative Update 2 (CU2).

The latest SP1 has many new and enhanced features. Here are a few for example:

  • Cross-Cluster Migration of AlwaysOn Availability Groups for OS Upgrade
  • Selective XML Index
  • DBCC SHOW_STATISTICS works with SELECT permission
  • New function returns statistics properties – sys.dm_db_stats_properties
  • SSMS Complete in Express
  • SlipStream Full Installation
  • Business Intelligence highlights with Office and SharePoint Server 2013
  • Management Object Support Added for Resource Governor DDL

Please note that the size of the service pack is near 1 GB.

Here is the link to SQL Server 2012 Service Pack 1.

SQL Server Express is the free and feature rich edition of the SQL Server. It is used with lightweight website and desktop applications.

Here is the link to SQL Server 2012 EXPRESS Service Pack 1.

Here is the question for you – how long have you been using SQL Server 2012?

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

SQL SERVER – Services Pack 2 for SQL Server 2008 R2 – Microsoft SQL Server 2008 R2 Service Pack 2

Service packs are very critical and important. In the industry I have seen many people waiting for the first service pack to arrive before moving to opting the product. I often see it as a good practice because there are some unknown bugs or missed enhancements in original product which are later covered in the SP2. I believe it is not limited to SQL Server but pretty much true across most of the softwares. Here is a single suggestion, you may delay adopting the product but must not delay in adopting service packs. As soon as they are released, grab them, test them on your development thoroughly and move to production server after validating.

Microsoft has recently released SQL Server 2008 R2 service packs. Please note these are for SQL Server 2008 R2 and not for SQL Server 2008. They will not work on SQL Server 2008 but will work only on SQL Server 2008 R2. If you have  have a fresh install of SQL Server 2008 R2, you just have to download and install SP2 and there is no need to install SP1 as this service pack is cumulative SP and contains all the previous upgrades of SP1.

Microsoft SQL Server 2008 R2 Service Pack 2

Microsoft SQL Server 2008 R2 Service Pack 2 Express Edition

Microsoft SQL Server 2008 R2 Service Pack 2 Feature Pack

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