MS Azure Cloud Database – MS Access Write Conflict Errors

April 4, 2020

After we created an MS Azure Cloud Database and finished the Database design.

All tables where populated with a data set. Where tested the access using an ODBC connection and MS Access.

So for so good, all data could be retrieved using MS Access Pass Through Queries.

Performance was going great and when the forms where done to retrieve the data.


We started designing the Update Forms based on the Linked Tables.

But here we started to encounter Write Conflict Errors Sad smile


Solution :

Whatever I tried i did not solve the issues… until this fix was applied.

on each table I added a Timstamp column.



The write Errors where gone Smile

Enjoy !

PowerShell – Azure Cloud Shell for PowerShell and Bash

November 3, 2017

Microsoft recently released a new feature called Azure Cloud Shell (for PowerShell and Bash).

To get started you need to log into the Azure Portal.

1. Click this icon


2. Choose Bash or PowerShell


3. Subscribe

This wil create an Azure File Storage to store your scripts


File Storage

Azure Files offers fully managed file shares in the cloud that are accessible via the industry standard Server Message Block (SMB) protocol.

Azure File shares can be mounted concurrently by cloud or on-premises deployments of Windows, macOS, and Linux.

Azure Files enable sharing files between applications running in your virtual machines using familiar Windows APIs or File REST API. Additionally,

Azure File Sync allows caching and synchronization of Azure Files shares on Windows Servers for local access.


Once created you can access all Azure resource using PowerShell or Bash resources.

And the scripts will be available online using your PC or even on a Mobile device !


Read more here :

Or watch this movie


QlikView – How to get MS Azure – Office365 BI Reports

February 3, 2016

QlikView Desktop is one of the leading BI In Memory Visualization Tools.

As I have shown in previous posts, this contains a VBScript host engine. And as well the Desktop Client is fully COM Compatible.

Giving these 2 nice bonus points for us scripters Smile

Let see how to use QlikView to provide BI Insights in your MS Azure and Office365 environment.

In the Office365 Admin portal, you can get nice statistics to analyze issues and performance if needed.


But QlikView can serve you better ! Because it is all centralized in your dashboard that is fully customizable Winking smile


Since it is all in memory, it is lightning fast to do your analysis. If you schedule the QVW you have it all ready each morning.

I built this proof of concept, and will be gradually ad more statistics.

See here for more info on Office365 Reporting web service

Happy Scripting !

Windows – AD Sync Msoidentitycrl Tracing Growing Rapidly

June 3, 2015

At some point I was surprised to see that my C: Drive on the production server was filling up rapidly ? Sad smile


After a quick analysis I saw that the reason was 40 Gb of msoidtrace tracing log files ?


After checking a bit deeper I could see that these where coming from the AD Sync Services we had installed lately.

Solution :

After applying the proper registry keys


And restarting the service “Microsoft Online Services Sign-in Assistant”


The problems where gone Smile

Read more here.

Enjoy !

QlikView – Access Data from SSRS

March 3, 2015

Since QlikView can’t access certain data sources like MS Analysis Services (SSAS) or other exotic data sources (SAP NetWeaver BI, Hyperion, TERADATA) natively.

We can fall back on the perfect middleware for this being MS SQL Reporting services


The approach is a simple as can be. Setup an SSRS server (can even be the MS SQL Express (Free) Edition & SSRS add-on)

The SSRS report server has natively a web service interface, exposing a SOAP and URL Interface.

Next develop your SSRS reports (which can handle multi data sources in 1 report Smile)


Like for example a SharePoint List combined with an Oracle database, or anything else.

Simular to PowerPivot that can access an SSRS Data Source. We can do the same with QlikView.

Use a Web File connection as Data Source


Fill in your report URL link and add the rs:Format=XML parameter to get an XML output from you report


If all goes well you will get the Report XML output and see the SSRS TABLIX and FIELDS Smile


That’s it, now you are ready to build your QlikView GUI

Once you know this technique you can as well use this to access an SSRS in the MS Azure cloud.Winking smile


PowerShell – Monitor MS Azure Status

February 22, 2015

If you are using MS Azure or MS Office 365 you are depending on the uptime of all the MS Cloud services.

Well to monitor this there is the Azure Status site.


This site offers for each service a RSS subscription to monitor the status.

In this case there was an issue, so we can kick in Powershell to grab the RSS output.

Here we go



$hsg = Invoke-WebRequest  ""


[xml]$ret = $hsg.Content.TrimStart("")

#$ | Select-Object *

write-host ""

if($ -eq $null){

        write-host $ " On : "  $
        write-host "All services are working properly"
        write-host ""

    write-host $ " On : "  $
    Write-Host "Issue Category : " $
    write-host ""
    Write-Host "Details : " $

    write-host ""


rv hsg, ret

As you can see the raw XML data is prefixed (deliberately or not?) by a few strange characters which we have to eliminate before PowerShell can dig it.

So the final output is like this.


So you can create a job to have this run at a frequency to check for uptime issues.