[EN] SQL Server 2008 R2 Service Pack 3 is available!

LOGO__SQLServer2008SP3Long awaited Service Pack 3 for Microsoft SQL Server 2008 R2 is available from last week. This Service Pack 3 (build number 10.50.600.34) include whole previously published updates for Service Pack 2 and up to Cumulative Update 13. And it is the last update for this platform, Microsoft will not release any Cumulative Update for Service Pack 3.

You cand download this update form Microsoft Download Centre and you can get two files (for x86 and x64 platforms):

  • ENU\SQLServer2008R2SP3-KB2979597-x64-ENU.exe | 358.4 MB
  • ENU\SQLServer2008R2SP3-KB2979597-x86-ENU.exe | 247.2 MB

This package can be used for upgrading following SQL Server 2008 R2 editions:

  • SQL Server 2008 R2 Parallel Computing Edition
  • SQL Server 2008 R2 Datacenter Edition
  • SQL Server 2008 R2 Enterprise Edition and Developer Edition
  • SQL Server 2008 R2 Standard Edition
  • SQL Server 2008 R2 Web Edition
  • SQL Server 2008 R2 Workgroup Edition

 

In the same moment MIcrosoft released Microsoft® SQL Server® 2008 R2 SP3 Feature Pack. It’s very important stand-alone packages which provide additional value of SQL Server 2008 R2 SP2. Here is the link for Knowledge Base Article and list of packages:

  • Microsoft® Connector 1.1 for SAP BW for SQL Server® 2008 R2
  • Microsoft® System CLR Types for SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Remote Blob Store
  • Microsoft® SQL Server® 2008 R2 Native Client
  • Microsoft® SQL Server® 2008 R2 Command Line Utilities
  • Microsoft® SQL Server® Service Broker External Activator for SQL Server® 2008 R2  The Microsoft SQL Server 2008 R2 Service Broker External
  • Microsoft® Windows PowerShell Extensions for SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Shared Management Objects
  • Microsoft® SQL Server® 2008 R2 ADOMD.NET
  • Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Analysis Management Objects

and full list of downloadable files:

image

 

Please read more information on all of those products and updates under linked addresses:

 

More important notes from producer:

  • We are not releasing  SQL Server 2008 R2 Express Service Pack 3 refresh.
  • This Service Pack will not be available on Microsoft Update. To facilitate the deployment on your side you could either use custom rules in SCCM or local publishing in WSUS as explained here.
  • Slipstream technology is not available for SQL Server 2008 R2. To slipstream a SQL Server 2008 R2  with Service Pack 3 please see this post .
  • October 16th 2014: We have discovered an issue with Report Builder 3.0 that ships with SQL Server 2008 R2 Service Pack 3.You will find on the SQL Server Release Services blog a public message sharing details and mitigations.

[EN] SQL Server 2008 R2 SP2 Cumulative Update 13 isavailable!

NOTE:
This is the final Cumulative Update for SQL Server 2008 R2 Service Pack 2.  SQL Server 2008 R2 SP2 exits mainstream support on July 8, 2014.

The sentence above is most important part in this post. In Last Cumulative Update No 13 (build number: 10.50.4319.0) for SQL Server 2008 R2 SP2 Microsoft fixed fifteen bugs:

 

VSTS BUG: 1918779 | 2922526
FIX: Missing rows on subscriber when you drop and re-add article from another publication or add subscription
SQL service

VSTS BUG: 2463716 | 2926217
FIX: Performance problems occur when database lock activity increases in SQL Server
SQL service

VSTS BUG: 2556589 | 2936984
FIX: "Failed to generate dynamic snapshot" when you call sp_MScreatemergedynamicsnapshot in SQL Server 2008 or SQL Server 2008 R2
SQL service

VSTS BUG: 2371475 | 2939277
FIX: Incorrect results when you run queries that contain UNION operator by using parallel query plan in SQL Server
SQL performance

VSTS BUG: 2525246 | 2952260
FIX: New FILESTREAM Filegroup can’t be recognized when you alter a partition function with SPLIT RANGE in SQL Server
SQL service

VSTS BUG: 2272416 | 2957174
FIX: Cannot create compressed nonclustered index on a table that has a clustered index with two or more bit columns
SQL service

VSTS BUG: 2556600 | 2963408
FIX: Error 5180 occurs when you query BLOB column data in SQL Server
SQL service

VSTS BUG: 2447011 | 2963658
FIX: The TDE enabled database stops responding indefinitely on WRITELOG or LOGBUFFER wait in SQL Server
SQL service

VSTS BUG: 2442037 | 2963668
FIX: w3wp.exe process crashes during merge replication with SQL Server Compact subscribers and precomputed partitions
SQL service

VSTS BUG: 2403831 | 2967103
FIX: Service broker stops working when you unregister and remove a session in SQL Server 2008 R2
SQL service

VSTS BUG: 2462604 | 2967240
FIX: Cannot reclaim unused space by using shrink operation in the table that contains a LOB column in SQL Server
SQL service

VSTS BUG: 2451659 | 2971611
FIX: Memory leak occurs during Process Update on a dimension in SSAS 2008 R2
Analysis Services

VSTS BUG: 2626083 | 2973961
FIX: Non-convergence or merge agent failure occurs when you use a custom stored procedure resolver in SQL Server 2008 R2
SQL service

VSTS BUG: 2691569 | 2975743
FIX: Incorrect result and exception occur when you use MDX query to do session cube grouping in SSAS 2008 R2
Analysis Services

VSTS BUG: 2624484 | 2977312
FIX: Incorrect result when you use LIKE pattern to match the Japanese repeat character (Cho-On) in SQL Server 2008 R2
SQL service

This update could be applied to Microsoft SQL Server 2008 R2 Service Pack 2, when used with:

  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Analysis Services
  • Microsoft SQL Server 2008 R2 Integration Services
  • Microsoft SQL Server 2008 R2 Reporting Services

 

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 13 

You may have to restart the computer after you apply this cumulative update.

If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for all platforms: 64-bit, 32-bit and Itanium) . This release is prepared as multilingual package. And here is the full list af all packages:

>> 2008R2_SP2_CU13_2967540_10_50_4319_IA64
>> 2008R2_SP2_SNAC_CU13_2967540_10_50_4319_IA64
>> 2008R2_SP2_MDS_CU13_2967540_10_50_4319_x64
>> 2008R2_SP2_SNAC_CU13_2967540_10_50_4319_x64
>> SQLServer2008R2_SP2_CU13_2967540_10_50_4319_x64
>> 2008R2_SP2_RSShrPnt_CU13_2967540_10_50_4319_x64
>> 2008R2_SP2_SNAC_CU13_2967540_10_50_4319_x86
>> SQLServer2008R2_SP2_CU13_2967540_10_50_4319_x86

Enjoy for Last Time!

[EN] Updates, patches and support for SQL Server in year 2014…

As a standard, monthly patches arriving to SQL Administrators (better known as DBA or SQL DBA). Some of them are installed automaticaly, some not. Sometimes we use development stage for checking, sometimes we push updates directly to production systems. What we can expect in 2014?

FIRST

Most significant subject is end of mainstream support for SQL Server 2008 (build no 10.xx.xx) and SQL Server 2008 R2 (build no 10.50.xx). Based on Microsoft Lifecycle Policy Mainstream Support for this editions will end at 8th July, 2014. What is this policy?

Microsoft provides support on the current service pack, and in some cases the immediately preceding service pack, for the products listed below. See the Lifecycle Support Policy FAQ for details on the Service Pack Support Policy. If you have any questions regarding support for a product, please contact your Microsoft representative. If you need technical support, visit the Contact Microsoft Web site.

image

 

As we see mainstream support will end in July 2014, and extended support will end in September 2019. A lot of us wait for Service Pack 4 for SQL Server 2008 before support will end.

SECOND

Of course we can expect more cumulative updates, and even full Service Pack no 2 for SQL Server 2012. We still get a lots of updates for SQL Server 2012 with every Cumulative Updates – examples? over thirty with CU9 and CU8 and almost fifty in CU7. Is it time for Service Pack 2? Definitely YES. And on SQL Server Release Service blog {LINK} we can find a short annoucement: “We are planning to deliver Service Pack 2 for SQL Server 2012 later this year” (by Jean-Yves Devant, Senior Program manager). It will be really great to have SP2 about holiday months.

 

THIRD

The newest, very fresh and young version of SQL Server are now on the market. Microsoft SQL Server 2014 has been released on July 1st and it is not a April Joke. Here is the initial annoucement of this premiere by Quentin Clark (Corporate Vice President) and Eron Kelly (General Manager at DPG) {LINK}. Whats new? Many, many things, but most highlighted are below:

>> In-Memory OLTP
>> In-Memory Updateable ColumnStore
>> Extending Memory to SSDs
>> Enhanced High Availability
      >> New AlwaysOn features
      >> Improved Online Database Operations
>> Encrypted Backup
>> IO Resource Governance
>> Hybrid Scenarios
      >> SQL Server Backup to Azure
      >> AlwaysOn with Azure Secondaries
      >> SQL XI (XStore Integration)
      >> Deployment Wizard

You can download installation files from MSDN portal, or get it for trial usage from this site (where You can choose on of three editions: ISO 32-bit and 64-bit / CAB 32-bit and 64-bit / SQL Server 2014 on Windows Azure):

http://technet.microsoft.com/en-US/evalcenter/dn205290

image

okay, okay. How about updates? You probably remember my stories about updates for SQL Server 2012 {LINK}. Just few days after RTM, about one hundred updates has been delivered (only Oralce is better prepared for this). I’m really interesting how long we will wait for first Cumulative Updates for SQL Server 2014 and of course… how many bug will be fixed this time. Time is counting!!!

But in the meantime – if you dodn’t start yet – let’s play with newest, very hot SQL Server. Of course I cannot forgot about SQL Server 2014 Express Edition. Here it is:

 

Microsoft SQL Server 2014 Express

Microsoft SQL Server 2014 Express is a free, feature-rich edition of SQL Server that is ideal for learning, developing, powering desktop, web & small server applications, and for redistribution by ISVs. The SQL Server 2014 Express release includes the full version of SQL Server 2014 Management Studio instead of SQL Server 2014 Management Studio Express.

You can download the following editions of Express from this page:

LocalDB (SqlLocalDB) LocalDB is a lightweight version of Express that has all its programmability features, yet runs in user mode and has a fast, zero-configuration installation and short list of pre-requisites. Use this if you need a simple way to create and work with databases from code. It can be bundled with Application and Database Development tools like Visual Studio and or embedded with an application that needs local databases.

Express (SQLEXPR) Express edition includes the SQL Server database engine only. Best suited to accept remote connections or administer remotely.

Express with Tools (SQLEXPRWT) This package contains everything needed to install and configure SQL Server as a database server including the full version of SQL Server 2014 Management Studio. Choose either LocalDB or Express depending on your needs above.

SQL Server Management Studio Express (SQLManagementStudio) This does not contain the database, but only the tools to manage SQL Server instances, including LocalDB, SQL Express, SQL Azure, full version of SQL Server 2014 Management Studio, etc. Use this if you already have the database and only need the management tools.

Express with Advanced Services (SQLEXPRADV) This package contains all the components of SQL Server Express including the full version of SQL Server 2014 Management Studio. This is a larger download than “with Tools,” as it also includes both Full Text Search and Reporting Services.

http://msdn.microsoft.com/en-US/evalcenter/dn434042.aspx

 

ENJOY!!!