[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] SQL Server 2008 R2 Service Pack 1 Cumulative Update 11 is available

LOGO__SQLServer2008R2Sp1About week ago Microsoft released three packages of Cumulative Updates for SQL Server environment. This is the second post in my short series will I write (in short mode as always) about those packages. 

In this Cumulative Update 11 [version build: 10.50.2869.0] Microsoft resolved only four bugs which could be applied to:

  • Microsoft SQL Server 2008 R2, when used with:
    • Microsoft SQL Server 2008 R2 Analysis Services
    • Microsoft SQL Server 2008 R2 Datacenter
    • Microsoft SQL Server 2008 R2 Developer
    • Microsoft SQL Server 2008 R2 Enterprise
    • Microsoft SQL Server 2008 R2 Express
    • Microsoft SQL Server 2008 R2 Express with Advanced Services
    • Microsoft SQL Server 2008 R2 Reporting Services
    • Microsoft SQL Server 2008 R2 Standard
    • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
    • Microsoft SQL Server 2008 R2 Web
    • Microsoft SQL Server 2008 R2 Workgroup
    • Microsoft SQL Server 2008 R2 Parallel Data Warehouse

Here is the list of resolved bugs:

VSTS BUG: 1028302 | 2760981
FIX: A PowerPivot workbook cannot connect to data source and load data when a PowerPivot server of a SharePoint farm is unavailable

VSTS BUG: 1172951 | 2780146
FIX: "Incorrect syntax near ‘IDENTITY_VALUE’" error when you try to decrypt data that is migrated from another database in SQL Server 2008 R2, SQL Server 2012 or in SQL Server 2008

VSTS BUG: 1172947 | 2791745
FIX: Access violation when you run a query that contains many constant values in an IN clause in SQL Server 2008

VSTS BUG: 1167751 | 2802113
FIX: "Failed Assertion = ‘CheckValidInput (wsName, cbName)’" error when you use database mirroring in Microsoft SQL Server 2008 R2

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 11

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

  • SQL Server 2008 R2 | All (Global) | x86 | 2008R2_SP1_PPExcel_CU11_2812683_10_50_2869_x86
  • SQL Server 2008 R2 | All (Global) | x86 | SQLServer2008R2_SP1_CU11_2812683_10_50_2869_x86
  • SQL Server 2008 R2 | All (Global) | x64 | 2008R2_SP1_RSShrPnt_CU11_2812683_10_50_2869_x64
  • SQL Server 2008 R2 | All (Global) | x64 | 2008R2_SP1_MDS_CU11_2812683_10_50_2869_x64
  • SQL Server 2008 R2 | All (Global) | x64 | 2008R2_SP1_PPExcel_CU11_2812683_10_50_2869_x64
  • SQL Server 2008 R2 | All (Global) | x64 | SQLServer2008R2_SP1_CU11_2812683_10_50_2869_x64
  • SQL Server 2008 R2 | All (Global) | ia64 | SQLServer2008R2_SP1_CU11_2812683_10_50_2869_IA64

Enjoy!

[EN] SQL Server 2012 Developer Training Kit Web Installer Phase One & Two-Fourth

In previous post I wrote about standard (just two-click technology) features from Microsoft® SQL Server® code name ‘Denali’ Community Technology Preview 3 (CTP 3) Feature Pack. Now I want to write about a little bit complicated (from the download/installation point of view) features. All are available from different pages, however all links You can find on general Page for Feature Pack HERE. Let’s play with they!

All features which I installed last night are not so big. Summarize all X64 Packages are about 146 MB in 17 installation files. The second part (look for all below) are for X64 Packages about  578 MB in 10 Files. Similar to previous post and next one in future almost all description are copied from Microsoft site. OK Let’s Play again…

Capture_CTP3FP_B_01

Step.01 | Master Data Services Add-in For Microsoft Excel The Master Data Services Add-in for Excel gives multiple users the ability to update master data in a familiar tool without compromising the data’s integrity in MDS. From within the Add-in, users can publish data to the MDS database with the click of a button. Administrators can use the Add-in to create new model objects and load data without ever launching any administrative tools, helping to speed deployment. With the Master Data Services Add-in for Excel, all master data remains centrally managed in MDS, while the ability to read or update the data is distributed to those who need it. | DOWNLOAD: MasterDataServicesExcelAddin.msi X86 Package or X64 Package

Capture_CTP3FP_B_02

Step.02 | PowerPivot for Microsoft Excel Microsoft® PowerPivot for Microsoft® Excel 2010 provides ground-breaking technology, such as fast manipulation of large data sets (often millions of rows), streamlined integration of data, and the ability to effortlessly share your analysis through Microsoft® SharePoint 2010. Microsoft® PowerPivot for Microsoft® Excel 2010 is a data analysis tool that delivers unmatched computational power directly within the software users already know and love — Microsoft® Excel. You can transform mass quantities of data with incredible speed into meaningful information to get the answers you need in seconds. You can effortlessly share your findings with others | DOWNLOAD: PowerPivot_for_Excel.msi X86 Package or X64 Package and README

Capture_CTP3FP_B_03

Step.03 | Report Builder Report Builder provides a productive report-authoring environment for IT professionals and power users. It supports the full capabilities of SQL Server code name ‘Denali’ CTP 3 Reporting Services. The download provides a stand-alone installer for Report Builder. Report Builder provides data visualizations that include charts, maps, sparklines, and data bars that can help produce new insights well beyond what can be achieved with standard tables and charts. Use Report Builder to create reports and shared datasets. Publish report parts, and then browse the Report Part Gallery to reuse existing report parts as building blocks for creating new reports quickly with a “grab and go” experience. | DOWNLOAD: ReportBuilder3.msi X86 Package (ONLY 32bit!!)

After installation of Excel Addins: Power Pivot, Reporting Services and Master Data You worksheet will change for this:

CaptureEXCL

Nice tabs isn’t? Load Test, PowerPivot, MasterData and Team. One exeption: almost all addins requires You special configuration, so chect documentations.

Capture_CTP3FP_B_04

Step.04 | Reporting Services Add-in for Microsoft SharePoint Technologies The Microsoft SQL Server code name ‘Denali’, Community Technology Preview 3 (CTP 3) Reporting Services Add-in for SharePoint Products is a Web download that integrates Reporting Services report server with a deployment of Microsoft SharePoint 2010 products. The Reporting Services Add-in provides the following functionality: >> Interactive data exploration and visualization >> Open/save reports in Report Builder from a SharePoint library >> A Report Viewer Web Part >>Web pages for create  manage reports and data sources >> Support for standard SharePoint Foundation 2010 / Server 2010 >> ability to use SharePoint permission levels and roles to control access to report server content. | DOWNLOAD: rsSharePoint.msi X64 Package (in oposite to Report Builder ONLY 364bit!!)

Capture_CTP3FP_B_05a

Step.04 | SQL Server Compact 4.0 Microsoft SQL Server Compact 4.0 is a free, embedded database that software developers can use for building ASP.NET websites and Windows desktop applications. SQL Server Compact 4.0 has a small footprint and supports private deployment of its binaries within the application folder, easy application development in Visual Studio and WebMatrix, and seamless migration of schema and data to SQL Server. | DOWNLOAD: SSCERuntime_-ENU.msi X86 Package or X64 Package

Capture_CTP3FP_B_06

Step.05a | Microsoft Drivers 3.0 for SQL Server for PHP CTP1 The Microsoft Drivers for PHP for SQL Server are PHP 5 extensions that allows for the reading and writing of SQL Server data from within PHP scripts. The SQLSRV extension provides a procedural interface while the PDO_SQLSRV extension implements PDO for accessing data in all editions of SQL Server 2005 and later. | DOWNLOAD: SQLSRV30.EXE X86 Package 

Capture_CTP3FP_B_06a

Step.05b | …PHP CTP1 The major improvement in the version 3.0 CTP1 release is support for SQL Server Codename "Denali" features including: LocalDB and AlwaysOn. Additionally, support for Buffered Queries was added. This release is available to all SQL Server users at no additional charge. Please read carrefuly: It’s still version for SQL Server CodeName DENALI CTP1 and agreements are not very new: Apache License are from January 2004.

Capture_CTP3FP_B_07

Step.06a | Microsoft® SQL Server® StreamInsight 1.2 Microsoft® StreamInsight is a platform that enables the continuous and incremental processing of unbounded sequences of events (event streams) from multiple sources with near-zero latency. These requirements, shared by vertical markets such as manufacturing, oil and gas, utilities, financial services, health care, web analytics, and IT and data center monitoring, make traditional store and query techniques impractical for event driven, timely and relevant processing of data. The ability to monitor, analyze and act on data in motion provides significant opportunity to make more informed business decisions in near real-time

Capture_CTP3FP_B_07a

Step.06b | We should read agreement and must accept it (of course) These are the new features in StreamInsight 1.2: >> Resiliency against planned and unplanned downtime through checkpointing. >> Better support for predictive modeling and pattern matching scenarios through new user-defined stream operators. >> Improved administrator experience through performance counters. >>  Improved administrator experience through the administrative event log. >> Improved development experience through support for nested event type structures and additional LINQ expressions. With the installation precess we have four files, one for server and one for client both for two platforms: DOWNLOAD: StreamInsight.msi X86 Package or X64 Package and DOWNLOAD: StreamInsightClient.msi X86 Package or X64 Package

Capture_CTP3FP_B_07b

Step.06c | Name and Company are important but not too much. What is Client version of StreamInsight? The Microsoft® StreamInsight Client package installs a subset of Microsoft® StreamInsight which lets you implement only the client side functionality: Connecting to an existing StreamInsight server, managing queries, and using the debugger tool. It does not support running an embedded server or creating a StreamInsight service. The installation of the Microsoft® StreamInsight Client does not need a product key.

Capture_CTP3FP_B_07c

Step.06d | We can create instance on the installation process or later. We must create separate instance for data store in future. Why? For performance, especially when we will work with StreamInsight with typical data: · Process monitoring i.e. scheduling, control, and inventory including processing such as RFID, bar codes, process monitoring at oil and gas refinery · Financial algorithmic trading, compliance monitoring, fraud detection, risk management · Click stream analysis on websites , context sensitive navigation and ad-delivery model · Utility grid monitoring – demand from meters and supply from generation units combined with energy trading · Patient Monitoring (Healthcare) · Network traffic monitoring, security intrusion detection · IT monitoring · Telecom network monitoring · Anomaly detection

Capture_CTP3FP_B_07d

Step.06e | Choosing Evaluation or Production Edition. For testing we can choose defaul option: Evaluation Edition. For Production Environment we choosing “Product-Key” Version. Please remember about availability for SQL Server:  StreamInsight Standard for SQL Server in versions: Standard, Enterprise, Web and StreamInsight Premium for SQL Server in versions: Datacenter, Developer, Evaluation.

Capture_CTP3FP_B_07e

Step.06f | On next windows we choosing: creating SI Host Windows Service and privileges. What is SI Host Windows Service? When we click “Create…” will happen: 1. The Windows NetworkService account is used as the login account for the service. Users with administrative privileges can change the login account for the service after Setup is complete. 2. An XML configuration file for the service is created. The typical installation location is C:\Program Files\Microsoft StreamInsight 1.2\Host\<instance_name>. This configuration file contains server-specific parameters such as the type of metadata store as well as Windows Communication Foundation-specific parameters. If, for example, the StreamInsight server URI of the service instance must be modified, the configuration file must be edited by a user with administrative privileges.

Capture_CTP3FP_B_07f

Step.06g | Almost end – Install

Capture_CTP3FP_B_07g

Step.06h | We need about 10 minutes for Express Edition (ok, I need on my laptop)

Capture_CTP3FP_B_07h

Step.06i | If we have previous (before 4.0) version of SQL Server Compact Edition, we must install Cumulative Update 4 for SQL Compact Edition 3.5. You can READ about it or directly REQUEST download file. Next screen called Finish.

Capture_CTP3FP_B_08a

Step.07a | Semantic Language Statistics CTP3 The Semantic Language Statistics Database is a required component for the Statistical Semantic Search feature in Microsoft SQL Server code name ‘Denali’. You can download this database from this page, attach it to your SQL Server “Denali” instance, and register it to use the new Semantic Search features. Statistical Semantic Search provides deep insight into unstructured documents stored in SQL Server databases by extracting and indexing statistically relevant key phrases and similar documents based on this keyphrases. Semantic Search builds upon the existing Full-Text Search feature in SQL Server, and enables new scenarios that extend beyond keyword searches into the meaning of the document. Solutions that are now possible include automatic tag extraction, related content discovery, and hierarchical navigation across similar content. For example, users can query the index of key phrases to build the taxonomy for an organization, or for a corpus of technical documents. Or for example in an HR scenario, a recruiter can query the document similarity index to identify resumes that match a job description. Developers can easily enable Semantic Search using familiar Fulltext search syntax. They can then access Semantic Search results using the new Semantic Rowset functions (similar to CONTAINSTABLE and FREETEXTTABLE). Semantic Search follows all of the Fulltext index population models to work seamlessly in the existing Fulltext scenarios. | DOWNLOAD: SemanticLanguageDatabase.msi X86 Package or X64 Package

Capture_CTP3FP_B_08b

Step.07b | Installation process is very simple. Just few clics. But when we look for disk cost we will se 750 MB is required for this installation. We can…

Capture_CTP3FP_B_08c

Step.07c | …change default folder for different place. We save almost 400MB. It will be important for us in future (especially that it’s place on partition C).

In the second part we installed almost all necessary features for our future learning. Let’s check the SQL Server 2012 Developer Training Kit Installer. Was something changed based on first post?

Capture_SQLSRV2012_DevKitUpdate_15

Better, but not ideal. We will working with this installation…