The RTM version of Service Pack 4 (SP4) for Microsoft SQL Server 2005 is now available for download, and includes SQL Server 2005 SP3 cumulative updates 1 to 11, customer requested fixes and the SQL Server 2005 SP4 database engine support for DAC operations.
As part of our continued commitment to software excellence for our customers, this upgrade is free and doesn’t require an additional service contract. SQL Server 2005 service pack upgrades are cumulative, and this edition upgrades all service levels of SQL Server 2005 to SP4 RTM.
To obtain SQL Server 2005 SP4 RTM with its improved security and supportability please visit the links below:
If it’s time for your company to consider a SQL Server upgrade, SQL Server 2008 R2 showcases a continued commitment to mission-critical workloads, providing a trusted scalable platform, increased developer and IT efficiency and managed self-service BI. Some of the capabilities include:
Resource Governor, a feature than you can use to manage SQL Server workload and system resource consumption
PowerPivot, a managed self-service analysis solution that empowers end users to access, analyze and share data across the enterprise in an IT managed environment using Excel2010 and SharePoint Sever 2010
Master Data Services (MDS) an ‘any domain’ hub that helps organizations standardize and streamline the business data used enterprise-wide.
Application and Multi-server Management, better utilization of resources and SMP scale up with support for up to 256 logical processors
Report Builder 3.0 with support for geospatial visualization,
Compliance-ready security features like Transparent Data Encryption and SQL Server Auditing
A savings of 50-60% on data storage with backup and data compression
Policy-Based Management for server policy compliance and PowerShell support for automating administrative tasks
Support for a more diverse set of applications with support for unstructured documents and file types and spatial data.
To find out more about SQL Server 2008 R2 visit http://www.microsoft.com/sqlserver/en/us/product-info/whats-new.aspx.
Abhishek SinhaProgram ManagerSQL Server Sustained Engineering
I should really appreciate Abhishek Sinha to post such an useful and reliable topic in this blog. The two download links are very useful to us. Thanks for this effort.
Thanks for posting this. Two questions:
1. The SQL Server 2005 SP4 system requirements exclude Windows Server 2003 and Windows Server 2003 R2. Will installations on those operating systems have to remain on SQL Server 2005 SP3? If so, what will happen when SQL Server 2005 SP3 is no longer supported? (According to normal policy, SP3 will be supported no more than 12 months after the release of SP4.)
2. Does DAC stand for Dedicated Administrator Connection or Data-tier Application Components? The latter is a new feature in SQL Server 2008 R2 which is also supported in SQL Server 2008 SP2.
Thanks for any help,
Hi Rob, DAC is Dedicated Administrator Connection. I think this would solve your problem.
Since Service Pack 2 was relelased, numerous bugs have been fixed. They are available in cumulative update packages (6 to date). However, Microsoft recommends customers not to install these cumulative updates unless affected by one of the fixed bugs. That creates a dilemma for SQL Server administrators. You do not want to install a package if Microsoft recommends against it, but you also want to take pro-active action so that you can squash the bug BEFORE it affects you.
Thanks for your questions.
For question #1:
Windows Server 2003 was inadvertently omitted from the main package page for SQL Server 2005 SP4. Customers using Windows 2003 may upgrade to SQL Server 2005 SP4.
For question #2:
DAC stands for Data Application Component; which is a new feature in SQL Server 2008 R2. SQL Server 2005 SP4 provides customers with SQL Server 2008 R2 in their environments to deploy and manage DAC’s. To learn more about the DAC please visit technet.microsoft.com/.../ff381683(SQL.100).aspx.
SQL Server Sustained Engineering
Excellent, thanks for clarifying these!