[EN] SQL Server 2012 SP1 Cumulative Update 10 is available!

Today Microsoft released tenth package with updates for SQL Server. In this Cumulative Update No 10 (build number: 11.0.3431.0) for SQL Server 2012 with Service Pack 1 Microsoft resolved almost forty problems. Here is the list of bugs and addressed areas:

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

VSTS BUG: 2002694 | 2928300
FIX: Intense query compilation workload does not scale with growing number of cores on NUMA hardware and results in CPU saturation in SQL Server 2012
SQL performance

VSTS BUG: 2052021 | 2932559
FIX: Totals are wrong after you filter on a pivot table item and remove the filter in SSAS 2012
Analysis Services

VSTS BUG: 2357156 | 2933103
FIX: Assertion failure when you execute a query specifying TOP N and ORDER BY in SQL Server 2008 R2 or SQL Server 2012
SQL performance

VSTS BUG: 2357158 | 2936154
FIX: DTA utility crashes with an access violation when you use user-defined function in SQL Server 2008 R2 or SQL Server 2012
Management Tools

VSTS BUG: 2356242 | 2936328
FIX: Access violation occurs when you run CHECKTABLE or CHECKDB against a table that has persisted computed columns in SQL Server 2008 R2 or SQL Server 2012
SQL service

VSTS BUG: 2116531 | 2938192
FIX: The execution of SSIS package takes a long time when you cannot enable garbage collector server mode in SSIS 2012
Integration Services

VSTS BUG: 2357154 | 2938476
FIX: Errors when you use export/import data wizard to move data after apply CU2 for SQL Server 2008 R2 SP2 or in SQL Server 2012
Integration Services

VSTS BUG: 2124209 | 2939277
FIX: Incorrect results when you run queries that contain UNION operator by using parallel query plan in SQL Server 2012
SQL performance

VSTS BUG: 2129886 | 2950189
FIX: An access violation occurs when you execute update query on a table that has a DML trigger in SQL Server 2008 R2 or SQL Server 2012
SQL service

VSTS BUG: 2186130 | 2950209
FIX: Access violation when the start offset is larger than the string length in function Substring in SQL Server 2012
SQL service

VSTS BUG: 2197034 | 2952101
FIX: Poor cardinality estimation when the ascending key column is branded as stationary in SQL Server 2012
SQL performance

VSTS BUG: 2356248 | 2953354
FIX: Log Reader Agent fails when you have Oracle Publishing configured in SQL Server 2008 R2 or SQL Server 2012
SQL service

VSTS BUG: 2115512 | 2954480
FIX: SSAS instance crashes when you perform writeback action by using the role with cell security defined
Analysis Services

VSTS BUG: 2232058 | 2954861
FIX: "Query Timeout Expired" when you preview a command of an SSIS package in SSDT 2012
Integration Services

VSTS BUG: 2306969 | 2956619
FIX: The execution of an SSIS 2012 package that is stored in MSDB is slower than it is stored on the file system
Integration Services

VSTS BUG: 2281773 | 2957768
FIX: Excel rendering extension produces corrupted files when rendering a NaN or Infinity value in SSRS 2012
Reporting Services

VSTS BUG: 2125329 | 2957957
FIX: Attributes sort incorrectly after using the Attribute Properties function in SQL Server 2012 MDS Add-in for Excel
Data Quality Services (DQS)

VSTS BUG: 2283857 | 2958012
FIX: Poor performance on I/O when you execute select into temporary table operation in SQL Server 2012
SQL service

VSTS BUG: 2279622 | 2958062
FIX: Error 515 when you add a subscription and then delete it in SQL Server 2012
SQL service

VSTS BUG: 2303094 | 2959342
FIX: Data-driven subscription can’t be created when the driving query takes longer than 30 seconds to execute in SQL Server 2012
Reporting Services

VSTS BUG: 2149812 | 2960237
FIX: Error when you execute DQS stored procedure [internal_core].[RestoreDQDatabases] in SQL Server 2012

VSTS BUG: 2311200 | 2960310
FIX: Access violation when you maintain RBS with the .NET Framework 4.0 in related configuration file in SQL Server 2012
SQL service

VSTS BUG: 2420698 | 2960735
FIX: Windows Update for SQL Server 2012 image does not work in Microsoft Azure Virtual Machine gallery
Setup & Install

VSTS BUG: 2304784 | 2960989
FIX: Error when you use DQS Cleansing Component with large batch in an SSIS 2012 package

VSTS BUG: 2285141 | 2961254
FIX: The execution of an MDX query in SSAS 2012 is much slower than it is SSAS 2008 R2
Analysis Services

VSTS BUG: 2306218 | 2961525
FIX: Keyboard keys do not work for Report Viewer 2012 in a Windows Forms application
Reporting Services

VSTS BUG: 2325197 | 2961559
FIX: Incorrect folder when deploying PowerPivot solutions through CA
Analysis Services

VSTS BUG: 2361530 | 2962650
FIX: Access violation occurs when running a Process Recalc on a tabular table in SSAS 2012
Analysis Services

VSTS BUG: 2060158 | 2963138
FIX: Parallel deadlock or self-deadlock occurs when you run a query that results in parallelism in SQL Server 2012
SQL service

VSTS BUG: 2357979 | 2963372
FIX: Sub-total of calculated measure is incorrect (non-filtered) when you execute MDX query in SSAS 2012 
Analysis Services

VSTS BUG: 2262879 | 2963373
FIX: Performance regression when you operate on a string or Boolean column by using DAX functions in SQL Server 2012
Analysis Services

VSTS BUG: 2262837 | 2963377
FIX: An exception and access violation occur when you run an MDX calculation in SSAS 2012
Analysis Services

VSTS BUG: 2288955 | 2963836
FIX: "Parameter missing value" error when you use a drillthrough report in SharePoint in SSRS 2012
Reporting Services

VSTS BUG: 2024232 | 2967634
FIX: SSIS 2012 XML validator only outputs "TRUE" or "FALSE" when you perform XML validation
Integration Services

VSTS BUG: 2290141 | 2967635
FIX: Incorrect DBA reference of business rules after you upgrade SQL Server 2008 R2 MDS to SQL Server 2012 MDS


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

  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 Express

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 10

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

>> 2012_SP1_RBS_CU10_2954099_11_0_3431_x64
>> 2012_SP1_RSShrPnt_CU10_2954099_11_0_3431_x64
>> 2012_SP1_DAC_CU10_2954099_11_0_3431_x64
>> 2012_SP1_CU10_2954099_11_0_3431_x64
>> 2012_SP1_PPExcel_CU10_2954099_11_0_3431_x64
>> 2012_SP1_RBS_CU10_2954099_11_0_3431_x86
>> 2012_SP1_DAC_CU10_2954099_11_0_3431_x86
>> 2012_SP1_PPExcel_CU10_2954099_11_0_3431_x86
>> SQLServer2012_SP1_CU10_2954099_11_0_3431_x86


[EN] TechEd NA 2014 Live Streaming

Yesterday I just visited MVA site and got link for special live event. Microsoft TechEd North America 2014 will start in Houston next Monday. I observed a lot of tweets, fecebook’s posts and othe social media short message: I’ going/on my way/ landed for TechEd NA 2014”.


This year I’m not going to this conference (I have two more important conferences in May and June and cannot go for this event), but me and thousands of ITPros, Devs, Admins and of course all BOFH’s should watching not only Keynote (as usual) but more different sesions:

May 12 at 11-12 noon   
Enabling Enterprise Mobility with Windows Intune, Microsoft Azure, and Windows Server
Adam Hall; Andrew Conway; Demi Albuz; Jason Leznek
May 12 at 1:15-2:30pm
Windows PowerShell Unplugged with Jeffrey Snover
Jeffrey Snover
May 12 at 3-4:15pm
RemoteApp for Mobility and BYOD
Demi Albuz;Samim Erdogan
May 12 at 4:45-6pm
Microsoft System Center 2012 Configuration Manager: MVP Experts Panel

Greg Ramsey;Jason Sandys;Johan Arwidmark;Kent Agerlund;Steve Thompson
May 13 at 8:30-9:45am
INTRODUCING: The Future of .NET on the Server
Scott Hanselman;Scott Hunter
May 13 at 10:15-11:30am
DEEP DIVE: The Future of .NET on the Server
David Fowler;Scott Hanselman
May 13 at 1:30-2:45pm
Group Policy: Notes from the Field – Tips, Tricks, and Troubleshooting
Jeremy Moskowitz
May 13 at 3:15-4:30pm
Microsoft Desktop Virtualization Overview Session

Demi Albuz;Robin Brandl;Thomas Willingham
May 13 at 5-6:15pm   
TWC: Sysinternals Primer: TechEd 2014 Edition
Aaron Margosis
May 14 at 8:30-9:45am
Making Sense of the Microsoft Information Protection Stack
Chris Hallum
May 14 at 10:15-11:30am
Mark Russinovich and Mark Minasi on Cloud Computing
Mark Minasi;Mark Russinovich
May 14 at 1:30-2:45pm
Entity Framework: Building Applications with Entity Framework 6

Rowan Miller
May 14 at 3:15-4:30pm
Windows PowerShell Best Practices and Patterns: Time to Get Serious

Don Jones
May 14 at 5-6:15pm
What’s New in Windows Server 2012 R2 Hyper-V
Jeff Woolsey
May 15 at 8:30-9:45am
Real-World Windows 8.1 Deployment: Notes from the Field
Johan Arwidmark
May 15 at 10:15-11:30am
Async Best Practices for C# and Visual Basic
Mads Torgersen
May 15 at 1-2:15pm
VDI Deployment Walkthrough
John Kelbley;Rich McBrine;Robin Brandl
May 15 at 2:45-4pm
2014 Edition: How Many Coffees Can You Drink While Your PC Starts?
Matthew Reynolds

More info, registration and calendar files are available here: http://bit.ly/1nuZHZ5

[EN] T-2 weeks till ITCamp–Are You Ready?

LOGO__ITCamp2014One year ago I visited Capitol of Transylvania first tme. Cluj-Napoca. Beautiful, tourist-friendly city in Romania (but close to Hungary). I had great pleasure to speaking for dozens of hundreds attendees which chosed my session. And it was great success. I got really great feedback for my session not only from organizers, but (which is most important) from attendees.

This year I will back to IT Camp, but for more days. I’m really happy to inviting for my thee moments at this conference:

  • Wednesday, May 21st – I will presenting my first full Pre-Conf. That’s exciting, and I’m very proud to got invitation from Tudor Damian {BLOG | TWITTER} for this action. My full-day workshop subjest is simple: High Availability of SQL Server in the context of Service Level Agreement. And I’m only one non-local speaker for pre-conf day, all other three experts are:
  • Agile in practice (Radu Vunvulea)
    Automating your IT infrastructure using PowerShell (Razvan Rusu)
    Mobile Device Management with Windows Intune and SCCM (Adrian Stoian)

  • Thursday, May 22nd – first conference day with four tracks and many not speakers not only from Romania, but from many place from the world. In blue line at 5PM I will presenting session: SQL Server Source Control about controling code for SQL Server Development, using Visual Studio and more, Cloud (and no-cloud) Source Control Application, and RedGate Software.
  • Friday, May 23rd – second and last day of conference. I hope that between those two days of conference I will find time for visiting city center. Early morning at 9AM in green line I will presenting session: SQL Azure from Plan, To Backup, To Cloud about Cloud Services and Backup and Restore features.

It is one of the biggest conference in Europe, even almost all speakers are from Romania this time all sessions will be presenting in English – I hope that more attendees will be ready for activity attendance, for speaking, commenting, asking and sharing knowledge. And here is the amazing list of speakers:

Tim Huckaby, Peter Leeson, Alex Ionescu, David Giard, Raffaele Rialdi, Jonathan "J" Tower, Martin Kulov, Andy Cross, Adam Granicz, Alessandro Pilotti, Ciprian Jichici, Adrian Stoian, Cristian Lefter, Valy Greavu, Tiberiu Covaci, Tiberiu Radu, Petru Jucovschi, Lorant Domokos, Florin Cardașim, Dan Nicola, Florin Coroș, Răzvan Rusu, Florin Loghiade, Claudia Jelea, Alex Mang, Romulus Crișan, Attila-Mihaly Balazs, Silviu Niculiță, Bogdan Toporan, Dan Ardelean, Radu Vunvulea, Mihai Tătăran, Tudor Damian.

I hope that oraginizers will be ready, and they have really big speaker room (last year speaker room was awesome).


Last important and logistic data:

  • WHERE: Hotel Grand Italia, Romania, Cluj-Napoca
  • WHEN: May 21st (pre-conf), May 22nd-23rd (conference)
  • SITE and REGISTRATION: http://ITCamp.ro/