[EN] Do ya wanna get rocked? T -48 hours till KulenDayz & MVP CEE Summit!

LOGO__KulenDayz2012 I expected that August 2012 will be free of the community, conferences, meetings – and have some free days. I was wrong. As always. Except wedding party (not mine fortunatelly) and three days near Baltic Sea Coast with fantastic ladies I’m going to my first MVP Summit. Wait! In August? Easy. It’s not full MVP Summit (held as always in Feb/Mar in Redmond). Inside one of the biggest south European community conference: KulenDayz 2012 I’m going to MVP CEE & Italy Summit 2012.

KulenDayz 2012 is prepared by Microsoft Community Osijek together with Microsoft Croatia with support from INETA, Hupro, MIC Varaždin and Mreža. Conference is bringing together leading IT Experts from the region with local IT Community and giving them a chance to spend a weekend filled with attractive sessions presented by top speakers and relaxing at Kopacki Rit Nature Park and enjoying unspoiled nature.

MVP CEE & Italy Summit is more like a social event, an opportunity to meet other MVPs from the Region, networking and mingling with each other, and get to know the Microsoft vision for the next Fiscal Year (FY13, which started on July, 1st).

My trip for this event is not easy: by bus from Wroclaw to Warsaw, next night train from Warsaw to Budapest and after by daily train form Budapest to Osijek. I’m happy to stay one day in Budapest (for my lovely sightseeing) on Thursday. On Friday we have day for MVP’s and on Saturday many great sessions in seven tracks: Office 365, Development,Database, Private Cloud, Windows Phone, Project Management, Chalk & Talk

09:00 –10:20


Alessandro Teglia, Damien Caro, Jamie Mann, Jeremy Chapman, Tomislav Bronzin, Bernardin Katić

10:30 –11:20

A New Hope: What’s new in Office PI – End User

Jeremy Chapman

Win8 Dev/Async

Jose Luis Latorre Millas

Change Data Capture in SQL Server 2012

Aleksandar Talev

Windows Server 2012 – what’s new for ITPros

Damir Dizdarević

Windows Phone 8 – Development

Andrej Radinger

Survival kit for PMs

Marija Bajica

Managing Remote Work

Adam Granicz

11:30 –12:20

Return of the Technical Jedi: What’s new in Office P2 – IT Pro

Jeremy Chapman

Contracts in Windows 8

Domagoj Pavlešić

The Curse of the Cursors

Daniel Joskovski

Windows 2012 Networking

Marin Franković

WP 8 is around the corner, what now?

Catalin Gheorghiu

What project managers should learn from Titanic disaster

Stanislav Stresnjak

Social Media

Ilija Brajkovic

12:30 –13:20

Becoming the Jedi Master: New Office Deployment and Architecture Deep Dive

Jeremy Chapman

Building scalable social web apps on Windows Azure

Marjan Nikolovski

SQL Server Myths & Legends

Dean Vitner, Marko Culo

Windows 2012 Storage

Damien Caro

WP – Augmented Reality

Igor Ralić

Influence of emotional intelligence (EQ) on project management

Ivan Matejašić

Building Distributed Web Systems

Damir Dobric

13:20 –15:00


15:00 –15:50

SharePoint 2010 vs SharePoint 365

Zvonimir Mavretić

VS + Specflow: Behaviour Driven Development

Ivan Pavlović

Fraud Detection – Notes from the Field

Dejan Sarka

SCVMM 2012 i App Ctrl 2012

Romeo Mlinar

Agile vs Waterfall

Nenad Trajkovski

Responsive Web Design

Toni Podmanicki

16:00 –16:50

SharePoint in the clouds

Adis Jugo

Kinect Programming

Jerislav Bobić

SQL Server Columnstor​e Indexes

Dragoslav Ogar

Managing Private Cloud with PowerShell

Aleksandar Nikolić

Motivation of the team in crisis

Mirna Koričan

Parallel Programming 101

Tiberiu Covaci

16:50 –17:10

Coffee Break

17:10 –18:00

Office 365, Lync, SharePoint and Exchange integration with Windows Phone

Željka Knezović

F# Web Application Development

Adam Granicz

SQL Server 2012 Statistical Semantic Search

Matija Lah

SC Orchestrator

Luka Manojlović

Project in problems – challange for PM

Vesna Hitrec

SOLID – clean code for mere mortals

Wekoslav Stefanovski

18:10 –19:00

Exchange 2013/Lync 2013

Igor Pavleković

GPdotNET – Darwian’s teory of evolution in solving engineering problems by C#

Bahrudin Hrnjica

Solving common cube design problems

Tomislav Piasevoli

Deploying Private Cloud

Tomica Kaniski

Rx & Async

Toni Petrina


Amazing, isn’t? But of course sessions are not most important. For me the community, old friends and new faces are most important. Sharing knowledge, experiences and ideas. Hope to meet a lot of my friends from European community. So…


Let’s get, let’s get, let’s get, let’s get rocked
Let’s get, let’s get, let’s get, let’s get rocked
Let’s go all the way
Get it night’n’day
Come on, let’s get, let’s get, let’s get, let’s get rocked




[EN] Cambridge Calling – just four weeks till SQL Saturday No #162

sqlsat162_Im_speaking_squareSeptember 2012. The Holidays (for some peoples) just over. First time ever, in the United Kingdom, exactly (from my perspective) in the center of England, SQL Server Peoples under flags: SQL Cambs and SQL PASS will meet in two days on the way of learning – with the brand: SQL Saturday. What is this? Based on SQL Saturday Home Page, the definition is simple: PASS SQLSaturday’s are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Whether you’re attending a SQLSaturday or thinking about hosting your own, we think you’ll find it’s a great way to spend a Saturday – or any day.

Based on my previous experience (SQL Saturday in Dublin) I think that this will be really multicultural event. I expect few hundreds SQL Server fans from many different countries, such as UK, Germany, Ireland, Poland, Italy, The Netherlands, United States, Portugal, Brazil and more… The schedule for this event looks fantastic:

Friday, 7th September – The PreConf Workshops Day:

  • Data Visualisation Deep-Dive using SQL Server 2012 with Jen Stirrup (MVP)
  • Buck Woody’s Ragtime DBA Workshop with Buck Woody (Microsoft)
  • A Deep-Dive into the depths of the SQL Server storage engine and MDF file format with Mark Rasmussen (SQL Internals expert)

Saturday, 8th September – The Community Conference Day:

  • Conference Keynote by Buck Woody
  • Over thirty technical sessions in all levels – from beginner to advanced users
  • Special sponsors sessions
  • Super Special Prize Draw Session

List of speakers are really impressive – I have no idea how the organizers do that:

Jen Stirrup | Mobile Business Intelligence for Everyone, Now!
Neil Hambly | Extended Events – New Age of Profiling
David Peter Hansen | Layered Partitioning – (re)load your data fast
Mark Pryce-Maher | Creating SSMS 2012 Add-ins for Crash Test Dummies
Aaron Bertrand | T-SQL : Bad Habits and Best Practices
Andrè Kamman | Practical PoSh – Design and build larger scripts
Tobiasz Koprowski | 2 AM. A Disaster just began…
Chris Testa-O’Neill | Understanding Microsoft Certification in SQL Server
Andy Leonard | Designing an SSIS Framework
David Morrison | Query Plan Operators Deep Dive
Niko Neugebauer | Inheriting a database for Developers
Gavin Payne | I want to be a better architect
Dave Ballantyne | What’s new in SQL Server 2012 – TSQL
Duncan Sutcliffe | The Magic of SQL Server 2012 BI in SharePoint
Martin Cairns | Partitioning Design for Performance and Maintainab
Bob Duffy | SQL 2012 Always On-Deep Dive
Hugo Kornelis | Make Your Queries Fly With Columnstore Indexes
Peter Baddeley | I work with SQL why should I care about SharePoint
Allan Mitchell | SQL Server 2012 SSIS Change Data Capture
Mark S. Rasmussen | Optimizing Storage and Performance Using Page and
Rob Volk | Tame Your Unruly Data…With Constraints!
Tobiasz Koprowski | Welcome to the Licensing Nightmare
Chris Webb | Intro to Tabular Model in Analysis Services 2012
Laerte Junior | Troubleshooting SQL Server with PowerShell
Alex Whittles | Merge-tastic: a better way of loading dimensions
Phil Quinn | XML: The Marmite of SQL Server
Chris Testa-O’Neill | Notes on SQL 2012 Highly Available BI Environments
Bruno Basto | SQL Internal Storage
Gavin Payne | NUMA Internals of SQL Server 2012

As You – probably – see above:


This SQL Saturday No 162 will be my first (and not last this year) SQL Saturday where I have big opportunity for speaking. And – THANK YOU ORGANIZERS – I will be speaker twice:

  • 2 AM. A Disaster just began… | Level: Intermediate | Room 3 | 09:20 AM | ABSTRACT
  • Welcome to the Licensing Nightmare | Level: Intermediate | Room 4 | 02:35 PM | ABSTRACT

So, after: SQL Bits 9 Query Across Mersey in last year, SQL Saturday No  105 (Lightening Talks) & SQL Bits X in this year – this event will be my fourth speaking and second full session in foreign language. I am really, really exciting. I You want to learn a lot of facts, myths, half-truths about SQL Server for administrators, developers, architects and managers, from real experts from different companies, from many Microsoft Certified Professionals (on every levels), from Microsoft Certified Trainers, Microsoft Certified Masters and finally from Microsoft Most Valuable Professionals just save the DATE: 7th & 8th September; PLACE: Cambridge, UK; PRICE: £190 + VAT (at 20%) for PreConfs and FREE for Saturday Conference. And of course register here: SQL Sat #162.

Post Scriptum: please follow us and share Your availability on social networks:

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

LOGO__SQLServer2008R2Sp2One week ago, and two weeks after releasing Service Pack No 2 for SQL Server 2008 R2, Microsoft published first Cumulative Update for this environment. Let’s look for a moment for this update.

In this Cumulative Update 1 [version build: 10.50.4260.0] Microsoft resolved a lot of requested issues for:

SQL Server Analysis Services 
SQL Server Reporting Services 
SQL Server SQL Engine
SQL Server Client Tool 
SQL Server Connectivity

If You read my previous posts about Cumulative Updates (all You can find here) You probably see the differences between previous posts and current post. I decided to not listing number of fixed bugs, based on conversation with Abhishek Sinha (from Microsoft SQL Server Team) and my friend Aaron Bertrand (from SQL Sentry). But of course I will publish official list of fixed bugs. See below:

VSTS BUG: 956227 | 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: 956228 | 2543687
FIX: Errors when a client application sends an attention signal to SQL Server 2008 or SQL Server 2008 R2

VSTS BUG: 956225 | 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: 969181 | 2618676
FIX: Transaction log backup is created even though the full backup is canceled in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 980532 | 2625768
FIX: A database page is copied into a database snapshot even though the page is not updated when you perform a read operation in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 956212 | 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: 980515 | 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: 969183 | 2661644
FIX: Access violation in the sqlservr!ReplicaToPrimaryPageCopier::ReadIoCompletionRoutine function in SQL Server 2008 R2

VSTS BUG: 956226 | 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: 969185 | 2667037
FIX: "The connection string format is not valid" error when you try to create a maintenance plan for a SQL Server 2008 R2 server

VSTS BUG: 980534 | 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: 980525 | 2674636
FIX: The size of a database file is not reduced when you use the DBCC SHRINKFILE command in SQL Server 2008 R2

VSTS BUG: 956218 | 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: 956213 | 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: 956224 | 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: 956221 | 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: 956229 | 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: 956204 | 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: 956230 | 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: 980517 | 2696161
FIX: Error message when you try to view a report in SSRS 2008 R2: "Different query parameters resulted in a same hash"

VSTS BUG: 969189 | 2697983
FIX: An incorrect value is stored in the TIME_ZONE column of the BACKUPSET table in SQL Server 2008 R2

VSTS BUG: 956215 | 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: 969191 | 2699013
FIX: SQL Server 2008 R2 or SQL Server 2008 stops responding and a "Non-yielding Scheduler" error is logged

VSTS BUG: 956206 | 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"

VSTS BUG: 980529 | 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: 969193 | 2703214
FIX: SQL Server 2008 R2 may not accept the client connection request when you perform a bulk insert and an OS error occurs

VSTS BUG: 969195 | 2706519
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

VSTS BUG: 969197 | 2706601
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

VSTS BUG: 969199 | 2707015
FIX: rsInternalError error when you export a report that contains a Tablix control in SSRS 2008 R2

VSTS BUG: 969201 | 2708027
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

VSTS BUG: 969203 | 2708726
FIX: Performance Monitor .dll files in the system32 folder are not updated after you apply updates to SQL Server 2008 R2

VSTS BUG: 969207 | 2713501
FIX: A deadlock occurs when you alter a partition and run a statement against the partition at the same time in SQL Server 2008 R2

VSTS BUG: 969209 | 2714634
FIX: SQL Server 2008 R2 takes a long time to generate scripts for a partitioned table that uses the data compression feature

VSTS BUG: 969213 | 2715289
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

VSTS BUG: 969211 | 2715312
FIX: Errors when you run a query that uses the FOR XML clause in the PATH mode in SQL Server 2008 R2


This time I have another interesting information. Before You start upgrade go to Abhishek’s post on MSDN blog to looking for important information:



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 1

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