Month: April 2012

[EN] Another SQL Event, Another International Speaking

koprowskit

Few months ago I heard about another one SQL Server & SharePoint event n Europe. Just exactly in next three weeks (Tuesday 8th May 2012 – Wednesday 9th May 2012) in Kongresshaus Berchtesgaden (near Munich) will start

SQL Server 2012 & SharePoint Connections

List of international speakers is really big and every names are well known – both in SharePoint and SQL Server subjects:

For SQL Server track:
• Klaus Aschenbrenner author of "Pro-SQL Server 2008 Service Broker"
• Chris Webb, co-author of "MDX solutions" and "Expert Cube Development with SQL Server Analysis Services 2008"
• Margarita Naumova (Microsoft Certified Master SQL Server, MVP, Founder SQL Master Academy)
• Constantin Klein (SQL Server MVP & DBA Developer)
• Satya Jayanty (SQL Server MVP & DBA Administrator)
• Oliver Engels (Board Member of PASS Germany)
• Charley Hanania (Swiss PASS)
• Gianluca Hotz ( SQL Server MVP)

For SharePoint track:
• Steve Fox
• Michael Noel (MCSE+1, CISSP, SharePoint MVP)
• Asif Rehmani (SharePoint MVP & MCT)
• Wouter van Vugt (SharePoint MVP)
• Daniel Sorlov  (one of just a few Microsoft SharePoint 2010 Ignite approved trainers)
• Agnes Molnar (SharePoint MVP)

200x200 bannerFew words about this event are below:
SQL Server 2012 is THE big Microsoft Launch this year, so join us in the beautiful resort of Berchtesgaden in Germany for 2 days of amazing deep SQL Server content presented by some of the industry’s top international speakers.

SharePoint Connections industry recognized local & internationally renowned speakers will help you get the most out of Microsoft SharePoint. You and your team can learn  about what tools and features  will allow you to build better solutions on top of SharePoint.

And finally most important news (not only) for me: I AM SPEAKER at this event. My session has been accepted by organizers and on Wednesday 9th May I’ll present my visions about licensing in the session called: Welcome to the Licensing Nightmare {abstract HERE}.

I’m so glad to going there and meet some of my well known friends like Klaus, Chris, Satya and Daniel and take great opportunity to meet new. if You want to go to this conference with me (ok not directly with me, but for meet my and other speakers) I can share for readers of my blog special discount of 50% off normal price. How? Just catch me directly (DM) on my twitter.

[EN] SQL Server 2008 R2 SP 1 Cumulative Update 6 is available

koprowskit

image003 (2)The second pack of updates for SQL Server, which has been released today is for SQL Server 2008 R2 too, but this time for versions with Service Pack 1. Let’s look for a moment for this pack.

In this Cumulative Update 6 [version build: 10.50.2811.0.] Microsoft resolved & fixed bugs for issues of components:
* for SQL Server Engine
* for SQL Server Analysis Services
* for SQL Server Reporting Services
* for SQL Server Manageability
* for SQL Server Connectivity

Below You can find short information about fixed bugs:

VSTS BUG: 90116 | 2511963
FIX: Query stops responding in SQL Server 2008 or in SQL Server 2008 R2 if the query alters or stops an Extended Events session

VSTS BUG: 898893 | 2515286
FIX: “There is no function ‘{urn:schemas-microsoft-com:xml-sql}:variable()” error for an XQuery query that updates the value of an XML column in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 889313 | 2543687
FIX: Errors when client application sends an attention signal to SQL Server 2008 or SQL Server 2008 R2

VSTS BUG: 898903 | 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 or from SSRS 2008 R2

VSTS BUG: 884203 | 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: 834643 | 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: 852841 | 2653857
FIX: You cannot connect to SQL Server by using JDBC Driver for SQL Server after you upgrade to JRE 6 update 29 or a later version

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

VSTS BUG: 884201 | 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: 871718 | 2675233
FIX: Slow performance when you run an MDX query that uses some sub queries in SSAS 2008 R2

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

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

VSTS BUG: 884188 | 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

VSTS BUG: 886487 | 2681514
FIX: Replication Log Reader Agent crashes when an empty string is inserted into an XML column of a table in a transactional replication publication in SQL Server 2008 R2

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

VSTS BUG: 887487 | 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 databases

VSTS BUG: 889220 | 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

VSTS BUG: 895302 | 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

VSTS BUG: 881012 | 2698639
FIX: Performance of a SELECT statement that contains a LIKE operator and an ESCAPE clause is low in SQL Server 2008 R2

VSTS BUG: 896034 | 2700227
FIX: Error message when you try to create a data service document in a data feed library from a sub-site collection in SharePoint 2010 to publish Atom feeds: “There is no file with URL”

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 6

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, itanium). This release is prepared as multilingual package.

[EN] SQL Server 2008 R2 Cumulative Update 13 is available

koprowskit

image003 (1)Today, April 17th Microsoft has published two sets of Cumulative Update for SQL Server. In this post I’m writing about updates for SQL Server 2008 R2.

In this Cumulative Update 13 [version build: 10.50.1815.0.] Microsoft resolved & fixed bugs for four components:
* for SQL Server Engine
* for SQL Analysis Services
* for SQL Server Reporting Services
* for SQL Server Connectivity

Below You can find short information about fixed bugs:

VSTS BUG: 898892 | 2515286
FIX: “There is no function ‘{urn:schemas-microsoft-com:xml-sql}:variable()” error for an XQuery query that updates the value of an XML column in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 898901 | 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 or from SSRS 2008 R2

VSTS BUG:  799332 | 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: 89888 | 2651629
FIX: Error message when you use DTA to tune one or more queries against a database that contains many objects in SQL Server 2008 R2 or in SQL Server 2008

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

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

VSTS BUG: 877044 | 2674636
FIX: The size of the database file is not reduced when you try to use DBCC SHRINKFILE command to reduce the size of the database file in SQL Server 2008 R2

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

VSTS BUG: 877004| 2696161
FIX: “Different query parameters resulted in a same hash” error when you try to view a report in SSRS 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 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 32-bit, 64-bit, itanium). This release is prepared as multilingual package.