Home
Our Projects
Reports
Videos
Blog
Resources
Contact Us
Home
Our Projects
Reports
Videos
Blog
Resources
Contact Us
Blog
0
ADF
,
Azure
,
Azure Data Factory
,
SSIS
•
27th April 2020
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...
Read More
0
Data Warehousing
•
25th February 2019
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. ...
Read More
0
Data Warehousing
•
11th February 2019
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...
Read More
6
Data Warehousing
,
SQL Server
•
4th February 2019
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...
Read More
4
Data Warehousing
•
28th January 2019
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...
Read More
2
Data Warehousing
•
18th January 2019
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...
Read More
0
Data Warehousing
•
14th January 2019
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...
Read More
4
Data Warehousing
•
7th January 2019
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...
Read More
0
Data Warehousing
•
28th December 2018
Data Warehousing Tip #2 – What your data warehouse should be
I’ve seen data warehouses that nobody trusts, or are just too complex for end users to report on. ...
Read More
0
Data Warehousing
•
10th December 2018
Data Warehousing Tip #1 – Store fact data at the leaf level
My first data warehousing tip is to store fact data at the leaf level. If you aggregate your...
Read More
2
Replication Performance Tuning
•
20th October 2014
Reducing the size of the distribution database & improving transactional replication performance: Part 3
The final (and much delayed) part of this series focuses on the choice between replicating stored procedure calls...
Read More
4
Replication Performance Tuning
•
26th November 2012
Reducing the size of the distribution database & improving transactional replication performance: Part 2
The impact of having data sitting in the distribution database that doesn’t need to be there can be...
Read More
1
2
[ Placeholder content for popup link ]
WordPress Download Manager - Best Download Management Plugin