[EN] SQL Server 2012 SP1 Cumulative Update 7 is available

LOGO__SQLServer2012Two updates pack has been published one day ago. Second pack is for SQL Server 2012 SP1. In this Cumulative Update No 7 (build number: 11.0.3393.0 / 778 MB in zipped file for x64 env.) Microsoft fixed many (about fifty) submitted bugs. Here is the list, but it’s strongly recommended to read details about those bugs, before installing this update in Your environment:

VSTS BUG: 1282810 | 2792921
FIX: Description of new features in SQL Server 2012 and SQL Server 2008 R2 SP2

VSTS BUG: 1615704 | 2833989
FIX: Object ID that is used in memory differs from the object ID on the disk in SQL Server 2012

VSTS BUG: 1268467 | 2843619
FIX: Tablix column header sorting buttons are Section 508 noncompliant in a Reporting Services report in SQL Server 2012

VSTS BUG: 1497516 | 2844210
FIX: The Remote Registry service crashes when an application tries to retrieve Performance Counter data from another computer

VSTS BUG: 1357295 | 2862241
FIX: Access violation when you trace an RPC event class by using SQL profiler or XEvents in SQL Server 2012

VSTS BUG: 1497535 | 2866062
FIX: Access violation when you use DTA to analyze a database that contains a partition table in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1497537 | 2868348
FIX: Chart data cannot be updated when you use the Report Viewer Web Part to view the report in SSRS 2008 R2 or in SSRS 2012

VSTS BUG: 1525444 | 2878968
FIX: Nonclustered index corruption may occur when you run a complex UPDATE statement together with a NOLOCK hint against a table in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012

VSTS BUG: 1447550 | 2879373 
FIX: The threads are not scheduled evenly in SQL Server 2012 Standard Edition

VSTS BUG: 1455690 | 2881285
FIX:  You cannot change the Run64BitRuntime property of an Integration Services project by using the SQL Server Data Tools in SQL Server 2012

VSTS BUG: 1434542 | 2881661
FIX: A memory leak occurs when a SQL Server Native Client OLE DB provider application calls the Prepare method in SQL Server 2012

VSTS BUG: 1465290 | 2883424
FIX: Dragged objects shake in an SSIS 2012 project after you apply Cumulative Update 6 for SQL Server 2012

VSTS BUG: 1465483 | 2883524
FIX: "SCN not found" error when you use Connector for Oracle by Attunity and CDC for Oracle by Attunity in SQL Server 2012

VSTS BUG: 1480767 | 2884953 
FIX: "Non-yielding Resource Monitor" when you run a workload that executes concurrent queries in SQL Server 2012

VSTS BUG: 1482635 | 2885671
FIX: Duplicated worksheets are opened when you use the SQL Server Master Data Services Add-in for Microsoft Excel in SQL Server 2012

VSTS BUG: 1492999 | 2887115
FIX: Function sys.fn_hadr_backup_is_preferred_replica costs almost all the CPU usage in Log Shipping in SQL Server 2012

VSTS BUG: 1581425 | 2887888
FIX: Slow performance in SQL Server when you build an index on a spatial data type of a large table in a SQL Server 2012 instance

VSTS BUG: 1581526 | 2887899 
FIX: Slow performance in SQL Server 2012 when you build an index on a spatial data type of a large table

VSTS BUG: 1502271 | 2888658
FIX: An access violation occurs when "sys.dm_db_index_physical_stats" is used in an IF EXISTS statement in an SQL query in SQL Server 2012

VSTS BUG: 1499492 | 2889492
FIX: You can’t open the SQL Server Analysis Services properties dialog box in Windows 8.1

VSTS BUG: 1519097 | 2889723
FIX: A series of errors occurs when you export a Reporting Services report as a PDF in SQL Server 2012

VSTS BUG: 1519527 | 2890052
FIX: Integration Services catalog permissions don’t work for Windows groups in SQL Server 2012

VSTS BUG: 1530003 | 2890415
FIX: Notification messages are not received when data updates fail in a PowerPivot sheet in an instance of SQL Server 2012 Service Pack 1 Analysis Services

VSTS BUG: 1482450 | 2891083
FIX: Subscriptions does not have an option to use default parameter values that are based on expressions in SSRS 2012 in SharePoint Integrated mode

VSTS BUG: 1531889 | 2891088
FIX: Find option in Report Manager always takes you to the bottom of the page in SSRS 2012

VSTS BUG: 1607598 | 2891230
FIX: Error message when you select a report on the RSItemPicker.aspx page after you apply update 2791086 on a computer that is running SSRS 2008 R2 or SSRS 2012

VSTS BUG: 1465349 | 2893842
FIX: Fewer results in the MDS subscription view after you apply SQL Server 2012 SP1 or SQL Server 2012 CU2

VSTS BUG: 1499658 | 2894025
FIX: Mirror tables are dropped when you use "Change Data Capture for Oracle by Attunity" on a server that is running SQL Server 2012

VSTS BUG: 1577746 | 2894305
FIX: Suboptimal execution plan is generated when you run a query in SQL Server 2012

VSTS BUG: 1577767 |2894326
FIX: An application cannot connect to a contained database when connection pooling is enabled in SQL Server 2012

VSTS BUG: 1590906 | 2895494
FIX: Slow SQL Server performance and a memory leak occurs after you apply Cumulative Update 3 for SQL Server 2012 Service Pack 1

VSTS BUG: 1560706 | 2895694
FIX: Query scope assignment works incorrectly after you run a ClearCache command in SSAS 2012

VSTS BUG: 1599658 | 2896505
FIX: Blank values for a DAX formula are seen in PowerPivot for Excel in SQL Server 2012 Analysis Services

VSTS BUG: 1494708 | 2896720
FIX: Slow performance in SQL Server 2012 when you build an index on a spatial data type of a large table

VSTS BUG: 1578576 | 2897221
FIX: Slow performance or error messages are logged when you have a transactional replication publisher server in SQL Server 2012

VSTS BUG: 1607184 | 2897237
FIX: Transaction date format on an MDS website in SQL Server 2012 differs from the format that is defined on the computer

VSTS BUG: 1460938 | 2897263
FIX: "An error occurred when loading VertiPaq data" error occurs after you run DISCOVER_XML_METADATA Rowset or load a database and then start a trace in SQL Server 2012 Analysis Services

VSTS BUG: 1584328 | 2897265
FIX: "Invalid column name" error when you run some MDX queries against ROLAP partitions in SSAS 2012

VSTS BUG: 1607493 | 2897282
FIX: Wrong date format will be returned when you run DateAdd or Day function in SSAS 2012 on a non-US locale computer

VSTS BUG: 1596224 | 2897454
FIX: Insufficient system memory error occurs when you try to create an index in a char, varchar, or nvarchar type column in SQL Server 2012

VSTS BUG: 1602357 | 2897512
FIX: Newly added member disappears from the Master Data Explorer in SQL Server 2012 MDS

VSTS BUG: 1610265 | 2897539
FIX: IntelliSense feature does not work correctly after you type Transact-SQL statements in SSMS in SQL Server 2012

VSTS BUG: 1615705 | 2897554
FIX: Synchronization state of an AlwaysOn Availability Group replica may not be updated if primary is unhealthy

VSTS BUG: 1610741 | 2897633
FIX: You cannot start an audit by using an "ALTER" statement in SQL Server 2012

VSTS BUG: 1530104 | 2899945
FIX: "The report server cannot process the report" error when you view an SSRS 2012 report on a SharePoint website

VSTS BUG: 1631258 | 2900127
FIX: "PowerPoint was unable to open or save this document." error message after you modify an embedded PowerPivot table

VSTS BUG: 1559163 | 2905275
FIX: "The operation was cancelled by the user" error message when you run some MDX or DAX queries in SSAS 2012

VSTS BUG: 1460958 | 2905298
FIX: It takes much longer for a user without administrator permissions to run an MDX query than an administrator user in SSAS 2012

 

This update could be applied for: Microsoft SQL Server 2012 Service Pack 1, when used with:

  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 SP1 PowerPivot for Microsoft Excel 2010

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 7

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 both platforms: 32-bit & 64-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

  • SQL Server 2012 | x86 | 2012_SP1_DAC_CU7_2894115_11_0_3393_x86
  • SQL Server 2012 | x86 | 2012_SP1_AOrcleDes_CU7_2894115_11_0_3393_x86
  • SQL Server 2012 | x86 | 2012_SP1_AOrcleSer_CU7_2894115_11_0_3393_x86
  • SQL Server 2012 | x86 | SQLServer2012_SP1_CU7_2894115_11_0_3393_x86
  • SQL Server 2012 | x64 | SQLServer2012_SP1_CU7_2894115_11_0_3393_x64
  • SQL Server 2012 | x64 | 2012_SP1_RSShrPnt_CU7_2894115_11_0_3393_x64
  • SQL Server 2012 | x64 | 2012_SP1_AOrcleSer_CU7_2894115_11_0_3393_x64
  • SQL Server 2012 | x64 | 2012_SP1_PPExcel_CU7_2894115_11_0_3393_x64
  • SQL Server 2012 | x64 | 2012_SP1_AOrcleDes_CU7_2894115_11_0_3393_x64

Enjoy!

[EN] Technical documentation for support SQL Server 2012 and Project Server 2010

LOGO__ProjectServer2010SQL Server 2012 came to the market a little bit earlier that expected. Because (for any reason) is possible to want to use SQL Server 2012 for existing products such SharePoint Server 2010  or Project Server 2010 we MUST be very careful and think and plan BEFORE we going to the installation process. On March 20 knowledge base on Microsoft TechNet was updated in the topic of:  support SQL Server 2012 and Project Server 2010. Let’s look for few most important points of that:

Environment:

  • Database server in a farm
    The 64-bit edition of Microsoft SQL Server 2012. The SharePoint Server 2010 Service Pack 1 and Project Server 2010 Service Pack 1 updates must be installed to your Project Server 2010 installations in your farm in order to use SQL Server 2012 to host your farm databases.
  • Single server that uses built-in database
    If you have Microsoft "Geneva" Framework installed, you must uninstall it before you install the Windows Identity Foundation (WIF).
  • Front-end Web servers and application servers in a farm
    The 64-bit edition of Windows Server 2008 (…) SP2; or the 64-bit edition of Windows Server 2008 R2 (…) If you are running Windows Server 2008 with SP1, the Microsoft SharePoint Products Preparation Tool installs Windows Server 2008 SP2 automatically.
  • Project Web App
    Project Professional client connectivity to Project Server 2010. Office Project Professional 2007 (SP2) will connect to Project Server 2010 only when backward compatibility mode (BCM) is enabled on the server. For more information about BCM, see Project Server 2010 upgrade overview.
  • Microsoft Project Professional 2010
    Microsoft Office Project Professional 2003 connectivity to Project Server 2010 is not supported, even when BCM is enabled on the server.
  • Reporting
    Microsoft Office Excel 2007 or Microsoft Excel 2010 is required for report authoring. Project Web App users do not require Microsoft Excel to view reports because the reports are rendered in HTML through Excel Services in Microsoft SharePoint Server 2010. To use reporting in Project Server 2010, you must install the SQL Server 2008 Analysis Management Objects (AMO) on each application server in the farm

More very detailed information and over thirty external links You will find on the page:  Hardware and software requirements (Project Server 2010)

[EN] October 2011 Cumulative Updates Packages for SharePoint 2010 Family

LOGO__SharePoint2010About one month ago Microsoft published new Cumulative Packages for SharePoint 2010 Family. In the title I wrote “SharePoint 2010 Family” but in fact it’s Microsoft Office 2010 Family. These updates are for Office 2010, Project Server 2010, SharePoint Server 2010 (with some services) and SharePoint Foundation 2010. One month (in my opinion) is enough time break to start to think about this installation. If You are familiar to SharePoint solutions, probably You heard about “un-updateable photos” (for June update) or “Unable to complete upgrate…” (for August update).

What You can find in this update (in three parts | full list is here):

1 > INDIVIDUAL SERVER UPDATES (most important for us – SP Admins)

2596586 | Description of the Excel Services in SharePoint Server 2010 hotfix package (Vsrvwfe-x-none.msp, Xlsrvwfe-x-none.msp)  | Excel Services in SharePoint Server 2010
2596582 | Description of the Excel Services in SharePoint Server 2010 hotfix package (Xlsrvwfe-x-none.msp)Excel Services in SharePoint Server 2010
2596583 | Description of the Excel Web App hotfix package (Xlwacwfe-x-none.msp) | Excel Web App
2596550 | Description of the Groove Server 2010 hotfix package (Ems-x-none.msp, Emsmui-xx-xx.msp):Groove Server 2010
2596580 | Description of the Office Web Apps hotfix package (Wacwfe-x-none.msp) | Office Web Apps
2596590 | Description of the PerformancePoint Services for SharePoint Server 2010 hotfix package (Ppsmawfe-x-none.msp, Ppsmamui-xx-xx.msp) | PerformancePoint Services for SharePoint Server 2010
2596498 | Description of the Project Server 2010 hotfix package (Pjsrvwfe-x-none.msp)Project Server 2010
2596484 | Description of the SharePoint Foundation 2010 hotfix package (Sts-x-none.msp) |  SharePoint Foundation 2010
2596584 | Description of the SharePoint Server 2010 hotfix package (Dlc-x-none.msp, Osrv-x-none.msp, Wosrv-x-none.msp)SharePoint Server 2010
2596581 | Description of the SharePoint Server 2010 hotfix package (Wdsrv-x-none.msp)SharePoint Server 2010

2 > ROLLUP SERVER UPDATES

Project server-package   
2596506  | Description of the Project Server 2010 cumulative update package (Project server-package)
Note: By installing this package, you will apply the whole cumulative update for Project Server, SharePoint Server, and SharePoint Foundation. It includes all applicable updates from the list of individual server updates in the following table.    
SharePoint server-package   
2596505  | Description of the SharePoint Server 2010 cumulative update package (SharePoint server-package)
Note: By installing this package, you will apply the whole cumulative update for SharePoint Server and SharePoint Foundation. It includes all applicable updates from the list of individual server updates in the following table.
SharePoint Foundation server-package   
2596508  | Description of the SharePoint Foundation 2010 cumulative update package (SharePoint Foundation server-package)

3 > OFFICE CLIENT UPDATES

2596587 | Description of the Access 2010 hotfix package (Ace-x-none.msp) | Access 2010
2596585 | Description of the Access 2010 hotfix package (Vbe7-x-none.msp) | Access 2010
2596496
| Description of the Access 2010 hotfix package (Access-x-none.msp) | Access 2010
2596554 | Description of the Excel 2010 hotfix package (x32 Excel-x-none.msp, x64 Excel-x-none.msp, Graph-x-none.msp) | Excel 2010
2596494
| Description of the Excel 2010 hotfix package (x86 Excel-x-none.msp,x64 Excel-x-none.msp) | Excel 2010
2596552
| Description of the Office 2010 hotfix package (Gfx-x-none.msp) | Office 2010
2596501 | Description of the Office 2010 hotfix package (Mso-x-none.msp) | Office 2010
2596500
| Description of the Office 2010 hotfix package (Oart-x-none.msp) | Office 2010
2596589 | Description of the OneNote 2010 hotfix package (Onenote-x-none.msp) | OneNote 2010
2596485 | Description of the Outlook 2010 hotfix package (x64 Outlook-x-none.msp; x86 Outlook-x-none.msp) | Outlook 2010
2596503 | Description of the PowerPoint 2010 hotfix package (Pptview-x-none.msp, Powerpoint-x-none.msp) | PowerPoint 2010
2596495
| Description of the Project 2010 hotfix package (Project-x-none.msp) | Project 2010
2596553
| Description of the Visio 2010 hotfix package (Visio-x-none.msp) | Visio 2010
2596551 | Description of the Word 2010 hotfix package (Word-x-none.msp) | Word 2010

As always – cumulative update IS NOT for automating, default installation. Before You go to update, please read documentation and workarounds. Apply any of above ONLY if the specific problem happen. Apply any of above ALWAYS first in testing environment, next for production systems.