Data, Information and Analytics

April 26, 2021April 26, 2021Analytics Industry, Azure, Data, Microsoft, SQL

Query Store

This blog is an easy-to-read summary of the Query Store functionality available in Azure SQL and other versions of SQL Server.

November 14, 2020April 5, 2021Analytics Industry, Architecture, Build, Business Data Vault, Change, CICD, Data, Data Lake, Data Lakehouse, Data Quality, ELT, ETL, Framework, Informatica PowerCenter, IT, MATILLION, Maturity, SQL

So you need a framework?

In my career I have used and built many ‘frameworks’. Typically they are focused on Data Warehouses delivery involving the Extraction, Transformation […]

October 30, 2020November 22, 2021Data, Microsoft, Oracle, Power BI, SQL

Connecting Power BI to Oracle

Ok, a quick post on connecting Power BI to Oracle. I wanted to do some simple testing by looking at row counts […]

September 10, 2020March 14, 2023Build, Data, IT, SQL

SQL Dependency

I was faced with the challenge of visualising object dependency in a SQL Server based project and came across this handy approach