Remember when we diverted a Delimited Text dataset so the Azure Data Factory could read it as XML and dump it into the SQL Server? Fortunately our hack is obsolete by now. The Data Factory now natively supports XML files in Copy Activity and Data Flows. Let’s take a look! …

With the first release candidate of PHP 8 out in the public our previous post about a dev environment based on PHP 7 and MySQL 5.7 (!) is officially outdated. It’s time to update your WAMP stack! As we are aiming at a portable development environment will won’t “install” the…

Creating and maintaining high quality web components is hard work. You not only implement the crucial functionality but — for UI components — you also have to make it look nice. And while reusability is one core aspect of web components, it’s most often bound to the design language used…

For the best part of the last 12 months I am using the Azure stack in one of our clients Data Warehouse projects. Although the vast majority of our input files are comma separated (in some way), there are exceptions. One of these exceptions are XML files. Surprisingly enough they…

It does not necessarily need a major release to add NoSQL-like functionality to a relational database management system. MySQL 5.7.12 introduced to X Plugin without a buzz. It enables you to create, read, update and delete JSON documents without enforcing a schema to the data. Tooling support includes a MySQL…

With a variety of different browsers (and rapidly growing number of versions) out there feature detecting is a necessity for web developers. It keeps us from coding into the blue — while relying on the misbelief that all users regularly update their browser. In consequence adding checks into the code…

Seven currently is the magic number for all fans of the good old LAMP stack. Oracle released the general availability release of MySQL 5.7 in late octobre and PHP 7 just hit the road - leapfrogging from 5.6 and leaving out version 6. Time goes by and newer PHP /…