[EN] SharePoint Solution Deployer 5 is available

Matthias Einig MVP {BLOG|TWITTER|FACEBOOK|LINKEDIN} LOGO__BannerGross_SPSDwho works with FANTASTIC TEAM at Tretton 37 and is owner Rencore AB company gave me, and other SharePoint enthusiast new version of his fantastic tool exactly for New Year. SPSD > SharePoint Solution Deployer is highly configurable special PowerShell tool for deploying wsp packages into Microsoft SharePoint 2010 and 2013. Based on information from his blog (LINK) we can find new features:

  • New: SPSD now has an extension system which allow you to create your custom PowerShell extensions and integrate them in the deployment process!
  • New: Added and example extension
  • New: Environment file can now be passed as parameter to the batch files
  • New: Added timestamps to better measure execution time
  • New: Added new deployment command “Ask” which asks the user for the deployment command.
  • New CP16167: SPSD now works also when run though an application (e.g. console app), output will be just logged into the log file
  • New: Countdown after deployment until windows closes

And of course we are very happy, that Matthias had enough time for fixing some bugs:

  • Updated: SharePointVersions.xml to include new SharePoint versions for SP2010/SP2013
  • Changed: Renamed CustomTarget SkipSolution to ProcessSolution
  • Changed: Stability improvements
  • Changed: Memory disposal improvements
  • Fixed CP16490: Incompatible with PowerShell 4.0 due to switch statements
  • Fixed CP16441: Compatibility Level ignored for global deploys
  • Fixed: CloseAllPSSessions had unused parameter in signature
  • Fixed: Startup in batch with relative path when not running from cmdline was failing when user UAC was enabled

This software working on Windows Server 2008/2008R2/2012 and Windows 7 (that’s official).

Great and big article with screenshots and introduction slidedeck You can find in the TechNet Gallery. More informations, build releases history You can find at CodePlex.

IMPORTANT (based on slideshare slide 9): Before unpacking the ZIP field, open the file properties and unblock the file!

Download, Deploy, Enjoy!

[EN] SQL Server 2012 RTM Cumulative Update 2 is available

LOGO__SQLServer2012Last and in my opinion most interesting is the second update for new SQL Server 2012. It’s third package of cumulative updates (after packages for SQL Server 2008 R2 and SQL Server 2008 R2 Service Pack 1) in today series.

In this Cumulative Update 2 [version build: 11.0.2325.0.] Microsoft resolved & fixed a big number of bugs for TEN (!) components:
* for SQL Server Analysis Services
* for SQL Server Manageability
* for SQL Server Master Data Services
* for SQL Server Reporting Services
* for SQL Server SQL Engine
* for SQL Server Integration Services
* for SQL Server Data Quality Services
* for SQL Server Deployment Platform
* for SQL Server Massively Parallel Data Warehousing
* for SQL Server Connectivity

Below You can find short information about fixed bugs:

VSTS BUG: 930636 | 2550375
FIX: Deadlock might occur in sys.dm_database_encryption_keys DMV in SQL Server 2008 R2 or in SQL Server 2012 when you run log shipping from many databases to one secondary server

VSTS BUG: 898904 | 2554905
FIX: “File error: Data may have been lost” error message when you use Excel 2010 to open an Excel report file that was exported from SSRS 2008, from SSRS 2008 R2 or from SSRS 2012

VSTS BUG: 952541 | 2567366
FIX: Slow performance when you restore a database in SQL Server 2008 R2, in SQL Server 2008 or in SQL Server 2012 if CDC is enabled

VSTS BUG: 898891 | 2658474
FIX: Incorrect results when the SqlConnection.GetSchema method retrieves a table’s schema information in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 898897 | 2665649
FIX: “bufferLen >= colLen” assertion when you run a parallel query in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 934436 | 2673997
FIX: “The index data is damaged” error message when you run an MDX query against a dimension or partition in SSAS 2008, in SSAS 2008 R2 or in SSAS 2012

VSTS BUG: 919039 | 2675233
FIX: Slow performance when you run an MDX query that uses some sub queries in SSAS 2008 R2 or in SSAS 2012

VSTS BUG: 919042 | 2675522
FIX: Access violation when you run DML statements against a table that has partitioned indexes in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 919043 | 2678796
FIX: You cannot search a Word document or an Excel workbook that is exported from an SSRS 2008 R2 or an SSRS 2012 report by using a keyword in the content of the document or of the workbook in SharePoint 2010

VSTS BUG: 919044 | 2679342
FIX: The field list of the dataset disappears unexpectedly when a report uses a query as a dataset that includes named parameters in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 919050 | 2682488
FIX: Backup operation fails in a SQL Server 2008, in a SQL Server 2008 R2 or in a SQL Server 2012 database after you enable change tracking

VSTS BUG: 919046 | 2682819
FIX: SQL Server 2008 R2 may stop responding when you perform many Update Cube writeback transactions on multiple cubes that belong to different SSAS 2008 R2 or SSAS 2012 databases

VSTS BUG: 929392 | 2683304
FIX: An update is available for SQL Server 2012 that changes the permission restrictions

VSTS BUG: 919047 | 2685132
FIX: The log shipping restore job restores a corrupted transaction log backup to a secondary database when you run a log shipping backup job on an instance of SQL Server 2008 R2 or an instance of SQL Server 2012

VSTS BUG: 890422 | 2685743
FIX: The DQS_PROJECTS database may grow very quickly when you perform the Discovery activity or the Cleansing activity in SQL Server 2012 DQS

VSTS BUG: 919051 | 2689903
FIX: A non-convergence occurs when you run a merge replication publication that uses web synchronization if the value of a column is NULL in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 893264 | 2693652
FIX: Access violation when you run a DAX or MDX query against a tabular model database through a BI semantic model connection in SQL Server 2012

VSTS BUG: 905727 | 2698150
FIX: “FlowConfigurationServiceSaveFatalError” error message when you try to open or create a knowledge base in the Data Quality Client in SQL Server 2012

VSTS BUG: 907480 | 2699163
FIX: “An unexpected error occurred” error in the PFMemoryHolder::RegisterMemoryHolder function when you run an MDX query in SQL Server 2012

VSTS BUG: 915388 | 2699820
FIX: Incorrect alert error message appears in the email message when SQL Server Performance condition alerts send the alerts errors through email message in SQL Server 2012

VSTS BUG: 921065 | 2703152
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

VSTS BUG: 935025 | 2705571
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

VSTS BUG: 890393 | 2708594
FIX: Locked page allocations are enabled without any warning after you upgrade to SQL Server 2012

VSTS BUG: 934699 | 2710782
FIX: A database from an earlier version of SQL Server becomes unusable when you attach it to an instance of SQL Server 2012

VSTS BUG: 933353 | 2711683
FIX: An access violation occurs intermittently when you run a query against a table that has a columnstore index in SQL Server 2012

VSTS BUG: 949533 | 2714785
FIX: “Cannot show requested dialog” error message when you try to view properties of a database in a SQL Server 2012 instance

VSTS BUG: 921066 | 2717234
FIX: Transaction history does not log the changes after you use EBS to change an attribute which has a NULL value in SQL Server 2012

VSTS BUG: 931241 | 2717239
FIX: “An error occurred while saving the subscription view” error message occurs when you create a subscription view against a recursive derived hierarchy in SQL Server 2012 Master Data Services

VSTS BUG: 958921 | 2719217
FIX: SQL Server stops responding when you enable RCSI for a database in Microsoft SQL Server 2008 R2 or in Microsoft SQL Server 2012

VSTS BUG: 924987 | 2720678
FIX: A hotfix is available that reverts the ID for AMO trace subclasses in SQL Server 2012 to earlier versions

VSTS BUG: 948931 | 2720690
FIX: SQL Server 2012 SSDT cannot open a Bulk Insert task in an SSIS package that is created by using the Japanese edition of BIDS

VSTS BUG: 950925 | 2721122
FIX: “Could not open embedded Powerpivot data” error message when a non-administrator user starts SQL Server 2012 PowerPivot for Excel 2010

VSTS BUG: 900425 | 2721610
FIX: An instance of SQL Server 2012 may end unexpectedly when FILESTREAM data is accessed

VSTS BUG: 934799 | 2711145
FIX: Error 41009 is logged in the SQL Server Error log file when you try to create multiple Availability Groups in a SQL Server 2012 AlwaysOn failover clustering environment

VSTS BUG: 894873 | 2720619
FIX: Calculated column that uses the RELATED function c in DAX contains empty values in SQL Server 2012 PowerPivot for Excel 2010 or in Analysis Services Tabular models

VSTS BUG: 950463 | 2720673
FIX: The running of UpdateCells command fails after you run the UpdateCells command two or multiple times to update the value of one cell in a write-enabled cube in SQL Server 2012

VSTS BUG: 924478 | 2720961
FIX: Cluster upgrade operation fails when you upgrade a SQL Server 2008 or SQL Server 2008 R2 cluster instance to SQL Server 2012

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 2

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 32-bit, 64-bit). This release is prepared as multilingual package. As You not Itanium version was not released in SQL Server 2012.

[EN] SQL Server 2012 Cumulative Update 1 is now available

image003Just a moment ago Microsoft released SQL Server 2012 RTM. Almost in the same time the same vendor (yes, is not a big surprise) released First Cumulative Update for new product. So, the fun just began.

Cumulative update package no. 1 for SQL Server 2012 [version build: 11.0.2316.0] fixed biggest in my experience number of bugs for TEN components:
* for SQL Server Analysis Services
* for SQL Server Manageability
* for SQL Server Master Data Services
* for SQL Server Reporting Services
* for SQL Server Engine
* for SQL Server Integration Services
* for SQL Server Data and Modeling
* for SQL Server Data Quality services
* for SQL Server Deployment Platform
* for SQL Server Documentation

Below You can find short information about fixed bugs (only described in articles):

VSTS BUG: 899274 | 2562753
FIX: Slow performance when an MDX query uses unary operators on parent/child hierarchy members in SSAS 2008 R2 or in SSAS 2012 if you define a scope calculation on these members and if the query accesses multiple dates in a time dimension

VSTS BUG: 887635 | 2574714
FIX: Incorrect results when an MDX query runs against an SSAS 2008 or an SSAS 2012 database if you set the RealTimeOlap property to True

VSTS BUG: 892370 | 2588047
FIX: MDX query incorrectly returns a NULL value in SSAS 2008 R2 or in SSAS 2012 if a linked cube contains a many-to-many dimension and a distinct count measure group

VSTS BUG: 892362 | 2590200
FIX: “The results of the current statement cannot be stored on the server” error when UpdateCells commands concurrently perform many writeback operations in SSAS 2008 R2 or in SSAS 2012

VSTS BUG: 885538 | 2590839
FIX: Low CPU spikes at a set interval even without user activity in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 896319 | 2591902
FIX: XML data loss when a merge replication encounters a foreign key violation error in SQL Server 2005, in SQL Server 2008, in SQL Server 2008 R2, or in SQL Server 2012

VSTS BUG: 893296 | 2603910
FIX: Backup fails in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 if you enable change tracking on the database

VSTS BUG: 885533 | 2605756
FIX: Internal error when you run a MDX query that uses the Descendants function after you upgrade from SSAS 2005 to SSAS 2008, to SSAS 2008 R2 or to SSAS 2012

VSTS BUG: 899270 | 2606211
FIX: Error when a complex MDX query has the NONEMPTY clause in SSAS 2008 R2 or in SSAS 2012 if the WHERE clause has a named set

VSTS BUG: 895589 |2606883
FIX: Slow performance when an AFTER trigger runs on a partitioned table in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 896325 | 2606918
FIX: NULL value in the Retention column in the sysmergepublications table and effects on the metadata cleanup process when you set up a merge replication environment in a republishing topology in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 895595 | 2616481
FIX: SSRS 2008 R2 report or SSRS 2012 report has no Export menu in Internet Explorer 9.0 if you use the out-of-box viewer page in the SharePoint Report Viewer Web Part

VSTS BUG: 896327 | 2616718
FIX: Poor performance when you synchronize the data from a SQL Server 2008 R2 or a SQL Server 2012 publisher to a SQL Server compact 3.5 subscriber

VSTS BUG: 896330 | 2622668
FIX: Error message when you delete some records in a table on a publisher if the schema name of the table is not “[dbo]”

VSTS BUG: 899281 | 2626637
FIX: DRILLTHROUGH statement does not work if it is run against some attribute members whose values contain one or more double quotation marks in SSAS 2008 R2 or in SSAS 2012

VSTS BUG: 892372 | 2629168
FIX: Internal error when you update a cellset that is returned after you run a query against a perspective in SSAS 2008 R2 or in SSAS 2012

VSTS BUG: 88553 | 2636425
FIX: Incorrect result when you update multiple Excel 2010 worksheets that use PowerPivot for Excel 2010 at the same time in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 884204 | 2637802
FIX: Pages of an SSRS 2008 R2 or an SSRS 2012 report are delivered incorrectly if you use the ReportExecutionService.Render method to render the report in image format or in EMF format

VSTS BUG: 895728 | 2638448
FIX: Access violation when a query is compiled or recompiled in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 881813 | 2638932
FIX: Error when you run the ProcessUpdate command against a cube that has partitions that use aggregation designs in SSAS 2008 or in SSAS 2008 R2

VSTS BUG: 896 | 2644396
FIX: Merge replication changes are missing on a SQL Server Compact subscriber when they subscribe to a partition in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 895600 | 2647120
FIX: Incorrect page numbers are displayed when you export a SSRS 2008 R2 report into PDF format

VSTS BUG: 891519 | 2648158
FIX: “The process could not execute” error message when you set a nonzero value in the MaxCmdsInTran parameter of the Log Reader Agent in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 895618 | 2649359
FIX: An access violation occurs in the “sqlservr!CSbMsgDispatcher::CSbReceivedDialog::AppendMsg” class in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 885534 | 2649913
FIX: Performance might decrease when you run a query that uses the sp_cursoropen stored procedure after you upgrade from SQL Server 2005 to SQL Server 2008 or to SQL Server 2008 R2 or to SQL Server 2012

VSTS BUG: 877206 | 2652024
FIX: You receive the error message “ConfigServiceConfigurationAlreadyExists” when you try to open a knowledge base in the Data Quality Client in SQL Server 2012

VSTS BUG: 896199 | 2652582
FIX: “Invalid authorization specification” error message when you run the SQL Server 2008 R2 Analysis Services Deployment Wizard by using the SQL Server Authentication mode

VSTS BUG: 893278 2653893
FIX: It takes a long time to restore a database in SQL Server 2008 R2 or in SQL Server 2008 or in SQL 2012

VSTS BUG: 885542 | 2655789
FIX: Replication Log Reader Agent fails with “18773” and “18805” error messages if you set the ‘”arge value types out of row” table option to ON for the publication article table

VSTS BUG: 885544 | 2658214
FIX: Poor performance when you run a query that contains correlated AND predicates in SQL Server 2008 or in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 881809 | 2658234
FIX: Unnecessary updates to a subscriber after you reinitialize it if a new article is added to a publication in SQL Server 2008 or in SQL Server 2012

VSTS BUG: 885548 | 2661225
FIX: Unable to connect to a data source when you use SQL Server Analysis Services 10.0 OLE DB Provider if you enable the “Automatically detect settings” option in the Connections tab of Internet Explorer

VSTS BUG: 885549 | 2662301
FIX: Slow performance occurs in SQL Server 2008 R2 or in SQL Server 2012 if high CPU usage is observed with contention over the QUERY_EXEC_STATS spinlock

VSTS BUG: 885550 | 2669148
FIX: Exception might occur when you run a parallel query that contains a CLR UDA function in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 871311 | 2669955
FIX: Slow performance when you use DQS to perform a data cleansing against a large data source in SQL Server 2012

VSTS BUG: 887936 | 2672531
FIX: “non-yielding on Scheduler” error if you use Service Broker to run a distributed query in SQL Server 2012

VSTS BUG: 884202 | 2673056
FIX: SQL Server Configuration Manager takes a long time to open if many SQL Server 2008 R2 or SQL Server 2012 instances are installed

VSTS BUG: 874242 | 2674817
FIX: The Data Quality Services feature is not supported on a SQL Server 2012 AlwaysOn failover cluster instance

VSTS BUG: 866374 | 2678370
FIX: Error 17310 when you perform an operation that triggers an audit event that is defined in an audit specification in SQL Server 2012

VSTS BUG: 875390 | 2683293
FIX: “Deserialization failed: Requested value ‘<ServerEdition>’ was not found” error message when you use AMO to connect to SQL Server 2012 Analysis Services

VSTS BUG: 887776 | 2683467
FIX: Master Data Services is not supported on a clustered installation of SQL Server 2012

VSTS BUG: 872113 | 2683514
FIX: “A database error has occurred” error message in SQL Server 2012 when you create a business rule in which the name of an attribute contains a space

VSTS BUG: 872110 | 2683516
FIX: SystemOutOfMemory error occurs when you use MDSModelDeploy.exe to deploy a Model Deployment Package that contains more than 100000 rows in SQL Server 2012

VSTS BUG: 887665 | 2685308
FIX: SSAS uses only 20 cores in SQL Server 2012 Business Intelligence

VSTS BUG: 891933 | 2686690
FIX: Cluster disk validation takes long time unexpectedly if there are more than 20 disks or volumes under a single drive letter during SQL Server 2012 failover cluster installation

VSTS BUG: 893874 2688692
FIX: Error code 17883 when you run the SQL Server 2012 Setup program and enable the FileStream configuration

VSTS BUG: 893881 | 2688697
FIX: Out-of-memory error when you run SQL Server 2012 on a computer that uses NUMA

VSTS BUG: 893908 | 2688721
FIX: Error message if you use more than 30 user-defined resource governor resource pools for an instance of SQL Server 2012: “Non-yielding IOCP Listener”

VSTS BUG: 893913 | 2688722
FIX: Overflow exception occurs when you run a SQL Server 2012 in a virtual machine if the state of the virtual machine is saved for a long time

VSTS BUG: 894427 | 2688967
FIX: Progress bar freezes for a long time when you install or uninstall a hotfix package for SQL Server 2012

VSTS BUG: 893254 | 2693568
FIX: Out-of-memory error when you run a DAX query against a Tabular model in SQL Server 2012 Analysis Services

VSTS BUG: 894853 | 2689367
FIX: The secondary databases are in “unknown” state if you join the secondary replica into the AGs two times in SQL Server 2012

VSTS BUG: 894307 | 2688964
FIX: Error message when you use the SQL Server 2012 installation media to upgrade, to repair, or to uninstall features: “The state of your SQL Server installation was not changed after the setup execution”

VSTS BUG: 894249 | 2688946
FIX: Error message when you install SQL Server 2012: “The identities of the manifests are identical but their contents are different”

Microsoft has recommended to test all hotfixes before updating in production environment. And the restart of system (physical or virtual computer; not only SQL Server instance) could be required.

More information about this release You can find with the article: Cumulative Update 1 for SQL Server 2012 RTM

If You want to go directly to download section jump to Request Hotfix Download Site, where You can choose version (for 32-bit, 64-bit). This release is prepared as multilingual package.

From SQL SERVER 2012 is released – there is no Itanium editions more!!