[EN]/[NL] T-7 Days till my next session… at SDN Event in Zeist


Het SDN Event van vrijdag 11 september is het volgende SDN Event van 2015. We hebben dan een vol programma met uiteenlopende sessies. Deze keer hebben we als speciale gasten Claus Nielsen uit Denemarken met PowerShell gerelateerde sessies, Tobiasz Janusz Koprowski origineel uit Polen maar wonend in Engeland over SQL Azure databases en Stephen Ball uit Engeland over Delphi in de Cloud en IoT. Kortom een mooi gevuld event met super onderwerpen verdeeld over 4 volle tracks.

A week in advance announcement, I’m very happy to be one of the three foreign speakers at Autumn’ Conference of Software Development Network in Zeist (The Netherland). Everything began two months ago when Roel Hans BethlehemTechnical Director and SharePoint Architect at Rapid Circle {TWITTER|LINKEDIN|FACEBOOK|BLOG} send me kind request as a result of sending a birthday wishes. This case is a proof – be open, connect to community and you will be awarded sooner or later. I checked my calendar and said YES! It’s very good beginning for my new speakers season. Season Six. It’s not new event. This community – even brand new for me – is well known in The Netherlands.

Four rooms, several international speakers, Azure Services, PowerShell, Delphi, Security, XML, AML and more. Here is the list of all sessions:

Zaal 1
Microsoft Band | Roy Jansen
Een andere kijk op Microservices | Dennis van der Stelt
Reverse Engineering ten behoeve van security analyses | Michiel van der Sluis
DevOps and ALM
| Hassan Fadili

Zaal PowerShell
PowerShell and what is new in Version 5 | Claus Nielsen
Open your application to Powershell
| Eric Tummers
Speeding up PowerShell (Pro and ConsHow can you optimize your PowerShell scripts? | Claus Nielsen
Bouwen van een cross-platform app met één codebase | Klaas Polinder
A Lap around Chrome apps and extensionsGoogle Chrome | Fanie Reynders

Zaal 3
Using OWIN to build atonomous HTTP-based .NET components that you can host anywhere | Dennis Doomen
Distributed Systems principles | Dennis van der Stelt
Nieuwe mogelijkheden van Azure Websites
| Eelco Koster
Zaal Delphi
Client-server systeem gebaseerd op de classes TIdTCPClient | Herbert Schrama
REST Web Services met XML
| Bob Swart
Using Azure Translator Services with Delphi
| Stephen Ball
Getting Connected with IoT and Delphi | Stephen Ball
InterBase XE7 & Change Views | Stephen Ball


If you noticed only three sessions in Zaal 3 – that’s right. It is place for me. I will present two sessions (which is and obligation for foreign speakers and which in my opinion really good idea) both in Zaal 3:

  • Windows Azure SQL Database for Beginners … at 10:00 in the morning
  • SQL Server Source Control in the Cloud Beginners at 13:00

More details and registration are available at the conference page: http://www.sdn.nl/EVENTS/11-september-2015 

PS. Because I’m in Friends of Redgate Program I will bring special swags from RedGate to audience of this conference. So wait for final raffle!

[EN] SQL Relay Autumn Tour – Day Six

A series of short post about SQL Relay Autumn Tour in United Kingdom, where I speaking, networking, helping and doing more fun and business things. Sixth day in Leeds. I have been here on SQL Relay 2013, but in different place. We arrived on Monday evening and our good friend Martin Bell just ran on time to right place to help us unpacking our stuff. My great driver found strange place where I had accomodation – as always I sleps in different place that all other peoples. I had plan for work, but place was not very good, so I just went sleep – especially that I entered door not for my hostel but or private house – and a little drunk owner scream to me: “Get out. Next door, damned! Next door!” Morning, I woke up morning and went to Costa Caffee close to venue.


About eight I found Alex Whittles near wrong reception desk (on 2nd floor) and tried to help him with organizing room – especially with abnormal floating screen / really terrible effect for speaker and audience. Some help with organizing, unpacking and checking the rooms. I found amazing theatre-style grand room for DBA track and finally small room for Cloud track. Of course ss always I occupied table with working process. In Leeds we had only one keynote presented by Anthony Saxby but in really great treater room. leeds was biggesr event, another with three track (after Southampton and Cardiff). And here is the final agenda (after some unexpected changes):

Keynote | Microsoft
Sponsor Sessions by ProfiSee & Pure Storage

Dev/DBA Track
Dave’s Fun Time SQL Hour | David Morrison
SQL Server Unit Testing | John McLusky
Uncovering the hidden gems in execution plans | Kevan Riley
Business Insight: Structured data meets unstructured data | Stephan Lawson
Statistics, Estimation & Plan Caching – The Big Three | David Morrison

BI Track
Using PowerPivot and DAX to predict and win Fantasy F1 | Alex Whittles
A look at 3 Big Data Tools | Allan Mitchell
"But SSRS Can’t Do That" – How to make it do that! | Oz Locke
Intro to R | Stephanie Locke
MDS and DQS – Beyond the TLAs to Data Quality | Neil Hambly

Cloud Track
Building an automated database deployment pipeline | Alex Yates
Cloud Services for Microsoft Peoples | Chris Testa-O’Neill    
Using Windows Azure SQL Database with Windows Phone | Allan Mitchell
Windows Azure SQL Database – Tips and Tricks for beginners | Tobiasz K.
SQL Azure, from plan to backup to cloud | Tobiasz Koprowski

Leeds was a special day for me. Firstly – I presented two sessions about Azure SQL Database, one as introduction, second as backup deep looking. Secondly – now I owe a special coffee for Allan Mitchell. Thirdly – since this day I’m a owner of my own super special helicopter from Violin Memory. Cannot time for play it, yet… but cannot wait for that. After packaging process we stayed for two hours for dring and fantastic dinner at local indian restaurant. Amazing salad bar and grill table and kitchen readu for grilled stuff for vegetarian. I will back there!

[EN] Fridays with Azure Tools (01) – Azure Storage Explorer

One of my good colleagues – SQL Server MVP from Poland:  Damian Widera {TWITTER|LINKEDIN} asked me for sending few files, not very big, just about 20 GB. His request enforced me tow start writing a new series on my blog – series about Tools for Windows Azure Platform. I have a plan for writing about many different tools: for usung storage, database, programming, management, backup and other targets. I will try focusing on free tools, but if some tool will be not very expensive, I’ll write about it too. In this post I want to introduce You for Azure Storage Explorer.

First  phase –  download this app from CodePlex site {LINK}.

Second phase – install application:


Pict.1.1 | Welcome Setup Wizard.


Pict.1.2 | Choose installation folder.


Pict.1.3 | Confirm installation.


Pict.1.4 | Wait, sometimes pleeeease wait.


Pict.1.5 | Installation is complete.

Third phase – run application and play:


Pict.1.01 | Welcome screen


Pict.1.02 | Adding new starage account: we need name (from Azure Management Portal) and key (form Manage Access Key feature)


Pict.1.03 | Important information – be patient for first connection


Pict.1.04 | First fiew for my Blob Storage 


Pict.1.05 | First view for Container Folder


Pict.1.06 | We can download object from container


Pict.1.07 | We can get information: the format provided the path is not supported. And I don’t want downloading bacpac file via ASE now.


Pict.1.08 | We can look for details about this blob file


Pict.1.09 |And of course for metadata (with information about eg. database)


Pict.1.10 | Of course we can use ASE for managing vhd files – my plan is to delete old file.


Pict.1.11 | I’m asking my portal to delete this file…


Pict.1.12 | ..and I got an error with deleting process. In fact this file “is not free” so I moving for a moment to Windows Azure management Portal.


Pict.1.12.1 | As we see this machine (which is tored on blob which we want delete) is stopped. That means: she’s still alive a little.


Pict.1.12.2 | Execution ordered: Shut Down this machine


Pict.1.12.3 | Execution in progress


Pict.1.12.4 |Finally machine is stopped, but…

With this case it is not finish. Because one of vhd disks is still attached to this machine, we cannod delete it via ASE. Workarround for this problem is here: Error deleting VHD: There is currently a lease on the blob and no lease ID was specified in the request


Pict.1.13 | In the meantime we can delete something else – like bacpac file.


Pict.1.14 | next we can back for our blob, and delete file from menu: Blob/Delete


Pict.1.15 | Last step is deleting whole container