[EN] FEB 2018 My Public Speaking And Presence

Second month of the 2018. The beginning of Chinese New Year – Year of the Earth Dog 戊戌 – and really busy month for me. First half of the month totally Down Under; it’s a new tradition (second time year by year) where I’m going to New Zealand. Some kind of busy holiday but not only. Plus few other events. So where You will be able to catch me?


Speaking is most important part of all my events. As many of us – The Speakers – we love it. So, of course, I will have some chance to increase my speaker’s skills here:


 Difinity Conference |Auckland, NZ |13th-14th Feb {SITE} {#DifinityConf|TW|FB}

–>> session: Secure your data at rest – on demand, now! | Feb 13th
–>> session: AD 2018. 2 AM. A New Disaster just began | Feb 14th
–>> Ask The Experts shift (one hour every day)

 Microsoft Tech Summit |Frankfurt, DE |21st-22nd Feb {SITE} {#MSTechSummit}

–>> discussion panel: MVP Theater: How to prepare for GDPR with Dux Raymond Sy , Nicki Borell , Mark Longton
–>> Ask The Experts Reception | Feb 21st afternoon
–>> MVP at the Data Platform Booth | Feb 21st 08:30 – 13:00
–>> Lab Proctor: Rapid low code app development with PowerApps and Microsoft Flow | Feb 22nd 14:00-17:30

 SQL Konferenz |Darmstadt, DE |26th-28th Feb {SITE} {#SQLKonferenz|FB}

–>> session: Secure your data at rest – on demand, now! | Feb 28th


In February I will be a part of the special training weekend:

UK MCT Train The Trainer Readiness Weekend|Manchester, UK|17th-18th Feb (in person)



Not only speaking. Sometimes I’m going to meet some people, to learn something, to share ideas:

User Groups:

Christchurch Dot NET User Group |Christchurch, NZ |07th Feb

The new monthly activity – which I really love, and trying to be apart from the beginning of this year is #CollabTalk > monthly one-hour discussion about SharePoint Office 365 and not only, functionality, features, problems, plans, future, development and more. This online (and freely available for everyone) monthly discussions are conducted and managed by Christian Buckley {S|T}

This month topic for #CollabTalk is: The Road to #SPC18 and Las Vegas | Feb 21st 09:00 AM PST |HERE|

The calendar is not closed. Is almost, but not in 100% full, so some events still can be added. As You can see, a lot of places and dates where you can meet me. Hope you will find a moment to say Hi!

[EN/DE] SQL Konferenz – Du Riechst So Gut!

LOGO__SQLKonferenz2016Der SQL Server 2016, der aktuell als Preview heruntergeladen werden kann, bietet viele neue Features und wird seitens Microsoft als Quantensprung in der Geschichte der Microsoft Plattform bezeichnet! Grund genug für uns, noch größer, noch spannender und mit noch mehr Inhalt als in den vorherigen 2 Jahren an den Start zu gehen:

  • PreCon mit 3 Deep Dive Workshops
  • 2 Tage MainCon mit 6 Tracks
  • mehr als 40 internationale und nationale Speaker
  • weit über 40 Vorträge

Neben dem “Was gibt es Neues?” und “Was sollte ich unbedingt wissen?” werden wir auch in diesem Jahr wieder Partner vor Ort haben, die sich mit ihren Produkten und Ideen ergänzend einbringen, und natürlich die PASS Deutschland e.V. – die SQL Server Community, die ihre Erfahrungen gerne mit allen teilt.

Wait! What? Five months ago I got message to my inbox:

we have closed the call for papers and our expert reviewers are going through all the sessions we received from the community. Thank you for your proposals! We are happy to confirm your session “SQL Security in the Cloud”. Further details concerning the conference which will be held on February 24th and 25th, 2016, in Darmstadt near Frankfurt, will follow within the next 2 weeks.

Today it’s just eve of my trip to Darmstadt. It will be my first big conference in this year and first focusing on Data Platform. SQL Konferenz is the biggest SQL Conference in Germany. This year attendees could attend for one of three great workshops:

  • Data Mining Algorithms in SSAS, Excel, R, and Azure ML by Dejan Sarka {TWITTER|BLOG}
  • Agile Data Warehousing: Start to Finish by Davide Mauri {TWITTER|BLOG}
  • SSIS Performance Design Patterns by Matt Masson {TWITTER|BLOG}

After pre-conference day (Tuesday) next two days wil be splitted for three different tracks with a lot of great speakers arround the world:

Régis Baccaro Julian Breunung Mark Broadbent Gerhard Brückl Hilmar Buchta Cedric Charlier Anat Dror Sascha Dittmann William Durkin Tillmann Eitelberg Oliver Engels Andre Essing Marcel Franke Frank Geisler Joachim Hammer Patrick Heyde Volker Hinz Guido Jacobs Tim Janitschke  Alexander Karl Peter Kirchner Stefan Kirner Constantin Klein Scott Klein Olivia Klose Jörg Knuth Jens Kröhnert Karen Lopez Matija Lah Thomas LaRock Matt Mason Davide Mauri Christoph Muthmann Niko Neugebauer Kenneth M. Nielsen Robert Panther Lars Platzdasch Markus Raatz Uwe Ricken Roland Rosenau Michael Rys Dejan Sarka Christoph Seck Frank Seiwerth Wolfgang Strasser Torsten Strauss Marcel Tilly Klaus Wagner Dandy Weyn Sven Wolf Andreas Wolter

On Thursday afternoon at SQL Konferenz I will present new version or my “SQL Server in the Cloud” session focusing on SQL Server, Cloud Services and of course newest of the new SQL Server 2016 CTP 3.3. But it’s not all!

Surprisingly, today I got invitation for another challenge with additional track SQL Data Exposed focusing on security. I will be one of the panelist in special Conference Video Studio where we will discuss about security arround Data Platform. I’m not sure about NDA of othe panelists – but I’m sure that I can announce our host – mein Freund aus Deutschland Herr Andreas Wolter {MVP, MCM, MCSM from Sarpedon Quality Labs}.


SQL Konferenz 23rd-25th February logistics:

See You in Darmstadt! 

[EN] SQL Server 2012 SP3 Cumulative Update #1 is available!

Two update packs has been released by Microsoft for SQL Server stack. Second package is for SQL Server 2012 Service Pack 3. In this Cumulative Update No 1 {build no 11.0.5644.2} Microsoft fixed seven bugs – all for SQL Service – listed below.

This update (VSTS BUG: 5285700 | 321185) introduces a new global property that exposes the latest CU number that is currently installed on the SQL Server. After you install this update, you can obtain the CU number information by executing either of the following queries:

          SELECT @@VERSION

Additionally, this update also adds the CU number information to the first line of the SQL Server error log.

VSTS BUG: 6200864 | 3052404
FIX: You cannot use the Transport Layer Security protocol version 1.2 to connect to a server that is running SQL Server 2014 or SQL Server 2012
SQL service

VSTS BUG: 6551412 | 3135750
FIX: SQL Server may crash when a request for execution of a remote stored procedure contains incomplete definition of arguments
SQL service

VSTS BUG: 6346687 | 3125526
FIX: You receive error messages when you run a query that uses tempdb in SQL Server
SQL service

VSTS BUG: 6372590 | 3132545
FIX: The STRelate and STAsBinary functions return unexpected results when trace flag 6533 is enabled in SQL Server 2012 Service Pack 3
SQL service

VSTS BUG: 6227298 | 3133055
An update to enable the “-k” startup parameter to control the rate that work files can spill to tempdb is available for SQL Server 2012 Service Pack 3
SQL service

VSTS BUG: 6223281 | 3125525
FIX: The CHANGETABLE function in a query returns incorrect results when Change Tracking is enabled for a SQL Server database
SQL service

VSTS BUG: 6609943 | 3100451
FIX: “Invalid cursor position” error when you retrieve spatial data by using SQLSetPos in SQL Server 2014 or SQL Server 2012
SQL service

This update could be applies to:

  • Microsoft SQL Server 2012 SP2

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 use any hybrid technology, such a Replication, AlwaysOn, Clustering:  If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP: step1: Install the service pack on the passive node / step2: Install the service pack on the active node (This step requests servicerestart).

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.

List ofpackages:

  • SQL12SP3QFECU1\x64\SQLServer2012-KB3123299-x64.exe | 585.8 MB

  • SQL12SP3QFECU1\x86\SQLServer2012-KB3123299-x86.exe | 309.7 MB

Small change which is already implemented for downloading prosess – you will get The Latest Update (by default):