Are you getting value from your reporting?
Do you spend so long manipulating your data into something vaguely useful that you don’t have the time to focus on analysing the what the data is telling you?...
2026-02-14
14 reads
The fundamental requirements of a reporting system
There are some fundamental boxes that your reporting system must tick. ✅ The figures must be accurate A good reporting solution can be trusted. A bad one causes confusion...
2025-11-21 (first published: 2025-11-02)
422 reads
SSIS Azure Blob Source Text Qualifier Issue
The issue When migrating the solution I’m currently working on to Azure eight months ago I was initially looking at transferring the SSIS packages that performed the ETL. We...
2020-05-07 (first published: 2020-04-27)
312 reads
Data Warehousing Tip #9 – Test at Volume
My next tip is to test your BI solution with the volume of data that you are expecting. This is...
2019-03-13 (first published: 2019-02-25)
1,954 reads
Data Warehousing Tip #7 – How I build a time dimension
In this article I’m going to show you how I build my time dimensions. There are lots of different ways...
2019-02-26 (first published: 2019-02-04)
3,889 reads
Data Warehousing Tip #6 – Use a consistent unknown member key
In this article I’ll be discussing the benefits of using a consistent unknown member key across your data warehouse. And...
2019-02-18 (first published: 2019-01-28)
3,996 reads
Data Warehousing Tip #8 – Make it better
In this article I’ll discuss making your data warehouse better. I’ll admit that this is a pretty obvious aspiration, but...
2019-02-11
849 reads
Data Warehousing Tip #5 – Use surrogate keys
My fifth data warehousing tip is to always use surrogate keys for your dimension and fact tables.
Surrogate keys are keys...
2019-02-07 (first published: 2019-01-18)
3,057 reads
Data Warehousing Tip #4 – Trust your instinct
My fourth data warehousing tip is to trust your instinct when it comes to building solutions, and if to you...
2019-01-21 (first published: 2019-01-14)
2,901 reads
Data Warehousing Tip #3 – Build thin slice
My third data warehousing tip is to build thin slice. Deliver subsets of valuable functionality. Get feedback and buy in,...
2019-01-16 (first published: 2019-01-07)
2,836 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Which 'Where' statement conditional upon a variable
Thanks in advance for any clues on this. I am trying to write a...
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers