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.
Andrew Bilsdon
Data Flexibility
Data Flexibility is surely the goal. I can’t believe that it has taken me so long to write a post on this! How much time… Read More »Data Flexibility
Membership, how to engage, grow and retain
Business that operate on a Membership Business model have different objects compared to say a Distributor or Retailer Model. This post is about how analytics supports this type of business
Lack of Engagement
Oh, the discomfort of having a genuine need (i.e. not one that you have raised), access to budget, but a lack of engagement from whoever… Read More »Lack of Engagement
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 and Loading (ETL)… Read More »So you need a framework?
Data Reconciliation
Reconciliation is a component of integrated data solutions that will lead to the blame game if it is not attended to
Is Business Intelligence Still a ‘thing’? It seems so …
As an industry, like many others, we are very proficient at reinventing our selves. After all we are now in the middle of the modern… Read More »Is Business Intelligence Still a ‘thing’? It seems so …
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 across a Oracle… Read More »Connecting Power BI to Oracle
Effectively Delivering Data
If you are involved in a data project, or the delivery of data as a service, this post is pitched at you. The recommendations are… Read More »Effectively Delivering Data
SQL Dependency
I was faced with the challenge of visualising object dependency in a SQL Server based project and came across this handy approach
