Master Data with SQL Spreads Excel add-in
At last! You can now simply use Excel to send and update...
Data Wrangling - in Python
There’s so many tools and platforms for ETL (Extract, Transform & Load)...
Azure Data Factory - with Power Query?
The moral of this story is that: A: There's always another edge case!
AI ChatGPT conclusion to Linux under Windows
As a sideline (for our own website and clients), we sometimes need...
Databases – Compare Your Objects & Code
We can automatically transfer all your database tables, views, stored procedures and all their associated properties into our own database (on Azure SQL DB, Managed Instance, on-premises server etc) and follow that up with data.
Git & GitHub – your Code Version Control
We can now share our codebase, when developed for you, with GitHub....
Power Apps - Database Reality
Low-Code Apps? I love the idea of Power Apps, because we all...
Power Apps – limitations until SQL!
The Microsoft data roadmap has been relaid – focusing on Power Apps...
BI: Multidimensional vs In-Memory (MDX vs DAX)
Traditional “multidimensional OLAP BI” is disk based pre-processed aggregations of sliced and...
Power BI – Content too large for table?!
The Dreaded Message That offer in the ribbon to “create a new...