July - Technical Rollup Mail - SQL
News
Partner Blog Feature: Why Epicor thinks Microsoft SQL Server 2012 makes Business Intelligence Personal
The Fantastic 12 of 2012: Behind the Scenes of Creating “Rapid Data Exploration & Visualization”
The Fantastic 12 of 2012: Behind the Scenes of Creating Optimized Productivity
The Fantastic 12 of 2012: Behind the Scenes of Creating Fast Time to Solution Technologies
Hy-Vee boosts performance by up to 100X, increases competitiveness with Parallel Data Warehouse deployment
New SQL Services in Windows Azure
Other
https://blogs.technet.com/trm/default.aspx
Events/Webcasts
TechEd Europe
Documents
The Fantastic 12 of 2012
New KB Articles
SQL 2012
Microsoft SQL Server 2012 Business Intelligence
FIX: Access violation when you call a CLR stored procedure that references a user-defined table type parameter in SQL Server 2012 or in SQL Server 2008 R2
https://support.microsoft.com/kb/2703152
Microsoft SQL Server 2012 Business Intelligence
Cumulative update package 2 for SQL Server 2012 is available
https://support.microsoft.com/kb/2703275
Microsoft SQL Server 2012 Business Intelligence
FIX: "FlowConfigurationServiceSaveFatalError" error when you try to open or create a knowledge base in the Data Quality Client in SQL Server 2012
https://support.microsoft.com/kb/2698150
Microsoft SQL Server 2012 Business Intelligence
FIX: "An unexpected error occurred" error in the PFMemoryHolder::RegisterMemoryHolder function when you run an MDX query in SQL Server 2012
https://support.microsoft.com/kb/2699163
Microsoft SQL Server 2012 Business Intelligence
FIX: Locked page allocations are enabled without any warning after you upgrade to SQL Server 2012
https://support.microsoft.com/kb/2708594
Microsoft SQL Server 2012 Business Intelligence
FIX: The DQS_PROJECTS database may grow very quickly when you perform the Discovery activity or the Cleansing activity in SQL Server 2012 DQS
https://support.microsoft.com/kb/2685743
Microsoft SQL Server 2012 Business Intelligence
FIX: "Cannot show requested dialog" error message when you try to view properties of a database in a SQL Server 2012 instance
https://support.microsoft.com/kb/2714785
Microsoft SQL Server 2012 Business Intelligence
FIX: "An error occurred while saving the subscription view" error when you create a subscription view against a recursive-derived hierarchy in SQL Server 2012 Master Data Services
https://support.microsoft.com/kb/2717239
Microsoft SQL Server 2012 Business Intelligence
FIX: The UpdateCells command fails after you run the command two or more times to update the value of one cell in a write-enabled cube in SQL Server 2012
https://support.microsoft.com/kb/2720673
Microsoft SQL Server 2012 Business Intelligence
A hotfix is available that reverts the IDs for AMO trace subclasses in SQL Server 2012 to earlier versions
https://support.microsoft.com/kb/2720678
Microsoft SQL Server 2012 Business Intelligence
FIX: SQL Server 2012 SSDT cannot open a Bulk Insert task in an SSIS package that was created by using the Japanese edition of BIDS
https://support.microsoft.com/kb/2720690
Microsoft SQL Server 2012 Developer
FIX: Latch time-out error when you have heap tables and data compression is enabled in SQL Server 2008 R2 or in SQL Server 2012
https://support.microsoft.com/kb/2719217
Microsoft SQL Server 2012 Developer
FIX: SQL Server Data Quality Client stops responding when you try to delete a data quality project after you install Cumulative Update 1 for SQL Server 2012
https://support.microsoft.com/kb/2705571
Microsoft SQL Server 2012 Developer
FIX: Error 41009 when you try to create multiple availability groups in a SQL Server 2012 AlwaysOn failover clustering environment
https://support.microsoft.com/kb/2711145
Microsoft SQL Server 2012 Developer
FIX: Cluster upgrade operation fails when you upgrade a SQL Server 2008 or SQL Server 2008 R2 cluster instance to SQL Server 2012
https://support.microsoft.com/kb/2720961
Microsoft SQL Server 2012 Developer
FIX: An instance of SQL Server 2012 may end unexpectedly when FILESTREAM data is accessed
https://support.microsoft.com/kb/2721610
Microsoft SQL Server 2012 Developer
Error message when you try to deploy an assembly in SQL Server 2012: "Clr Assembly must have main file specified"
https://support.microsoft.com/kb/2709869
Microsoft SQL Server 2012 Enterprise
FIX: Incomplete Performance Condition alert in SQL Server 2012
https://support.microsoft.com/kb/2699820
Microsoft SQL Server 2012 Enterprise
FIX: Transaction history does not log changes after you use EBS to change an attribute that has a NULL value in SQL Server 2012
https://support.microsoft.com/kb/2717234
Microsoft SQL Server 2012 Enterprise
FIX: Calculated column that uses the RELATED function in DAX contains empty values in SQL Server 2012 PowerPivot for Excel 2010 or in Analysis Services tabular models
https://support.microsoft.com/kb/2720619
Microsoft SQL Server 2012 Enterprise
You receive a warning message when you add a Reporting Services assembly as references to a custom report item project in SQL Server 2012 Reporting Services
https://support.microsoft.com/kb/2722683
SQL 2008
Microsoft SQL Server 2008 R2 Datacenter
FIX: Access violation in the sqlservr!ReplicaToPrimaryPageCopier::ReadIoCompletionRoutine function in SQL Server 2008 R2
https://support.microsoft.com/kb/2661644
Microsoft SQL Server 2008 R2 Datacenter
FIX: "The connection string format is not valid" error when you try to create a maintenance plan for a SQL Server 2008 R2 server
https://support.microsoft.com/kb/2667037
Microsoft SQL Server 2008 R2 Datacenter
FIX: SQL Server 2008 R2 may not accept the client connection request when you perform a bulk insert and an OS error occurs
https://support.microsoft.com/kb/2703214
Microsoft SQL Server 2008 R2 Datacenter
FIX: An exception occurs when the SqlCommandBuilder.DeriveParameters method is used to retrieve parameter information from a CLR stored procedure in SQL Server 2008 R2
https://support.microsoft.com/kb/2706519
Microsoft SQL Server 2008 R2 Datacenter
FIX: Incorrect results when you convert a datetimeoffset column to a smalldatetime column in SQL Server 2008 R2 when there is an index on the datetimeoffset column
https://support.microsoft.com/kb/2715289
Microsoft SQL Server 2008 R2 Datacenter
FIX: A restore operation does not stop at the time that you defined in SQL Server 2008 R2
https://support.microsoft.com/kb/2722165
Microsoft SQL Server 2008 R2 Datacenter
Cumulative update package 14 for SQL Server 2008 R2
https://support.microsoft.com/kb/2703280
Microsoft SQL Server 2008 R2 Datacenter
FIX: SQL Server 2008 R2 takes a long time to generate scripts for a partitioned table that uses the data compression feature
https://support.microsoft.com/kb/2714634
Microsoft SQL Server 2008 R2 Datacenter
FIX: An error message is logged when you start SQL Server 2008 R2 or when a client sends a request to SQL Server 2008 R2
https://support.microsoft.com/kb/2711549
Microsoft SQL Server 2008 R2 Developer
FIX: An incorrect value is stored in the TIME_ZONE column of the BACKUPSET table in SQL Server 2008 R2
https://support.microsoft.com/kb/2697983
Microsoft SQL Server 2008 R2 Developer
FIX: Errors when you run a query that uses the FOR XML clause in the PATH mode in SQL Server 2008 R2
https://support.microsoft.com/kb/2715312
Microsoft SQL Server 2008 R2 Developer
FIX: SQL Server 2008 R2 stops responding and a "Non-yielding Scheduler" error is logged
https://support.microsoft.com/kb/2699013
Microsoft SQL Server 2008 R2 Powerpivot for Excel 2012
FIX: "Could not open embedded Powerpivot data" error when a non-administrator user starts SQL Server 2012 PowerPivot for Excel 2010
https://support.microsoft.com/kb/2721122
Microsoft SQL Server 2008 R2 Reporting Services
FIX: Series groups in a report are missing when you render the report in SQL Server 2008 Reporting Services or in later versions of Reporting Services
https://support.microsoft.com/kb/2706601
Microsoft SQL Server 2008 R2 Reporting Services
FIX: "An error has occurred during report processing" error message when you try to preview an SSRS 2008 R2 report after you set the dataset collation to Greek or Greek_100
https://support.microsoft.com/kb/2708027
Microsoft SQL Server 2008 R2 Standard
Cumulative update package 7 for SQL Server 2008 R2 Service Pack 1