SQLAuthority News – SQL Server 2008 SP3 Available to Download

October 15, 2011

This news is one week late but still very useful as per my perspective. Please note this are for SQL Server 2008 and will not work with SQL Server 2008 R2.

SQL Server 2008 Service Pack 3

Enhanced upgrade experience from previous versions of SQL Server to SQL Server 2008 SP3. In addition, we have increased the performance & reliability of the setup experience.
In SQL Server Integration Services logs will now show the total number of rows sent in Data Flows.
Enhanced warning messages when creating the maintenance plan if the Shrink Database option is enabled.
Resolving database issue with transparent data encryption enabled and making it available even if certificate is dropped.
Optimized query outcomes when indexed Spatial Data Type column is referenced by DTA (Database Tuning Advisor).
Superior user experience with Sequence Functions (e.g Row_Numbers()) in a Parallel execution plan.

Microsoft SQL Server 2008 SP3 Express Edition
SQL Server 2008 SP3 Express is a free edition of SQL Server that is ideal for learning and building desktop and small server applications, and for redistribution by ISVs.

Microsoft SQL Server 2008 Service Pack 3 Feature Pack
The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008 SP3.

Microsoft SQL Server 2008 SP3 Reporting Services Report Builder
Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 delivers an intuitive, Office-like report authoring environment enabling business and power users to leverage their experience with Microsoft Office 2007 products.

Microsoft SQL Server 2008 SP3 Reporting Services Add-in for Microsoft SharePoint Technologies
The Microsoft SQL Server 2008 SP3 Reporting Services Add-in for Microsoft SharePoint Technologies is a Web download that provides features for running a report server within a larger deployment of Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007.

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

SQL Documentation, SQL Download

SQL SERVER – SQLPASS Memory Lane of 2009 and 2010

SQL SERVER – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry

2 Comments. Leave new

Srinivas Kadiyala
October 15, 2011 10:03 am
can i install on top of sql server R2 …this sql server sp3
Reply
- Nakul Vachhrajani
  October 15, 2011 8:07 pm
  Srinivas,
  No. If you look at the Release Notes at: https://social.technet.microsoft.com/wiki/contents/articles/4937.microsoft-sql-server-2008-sp3-release-notes.aspx, you can see that this Service Pack does not apply to SQL Server 2008 R2.
  “Server 2008 R2 components are not affected by the SQL Server 2008 service pack update.”
  (Just search for “R2” once the Release Notes page is loaded)
  Reply