First a little background. I’m working on a large fact table that behaves itself as a slowly changing type 2 dimension. Weird right? But I have a good reason for this: it’s a snapshot table and if I would create the snapshots like you’re supposed to (by exploding the fact table) I would end up […]
Month: December 2016
Master Data Services Error – Missing Temp Directory
I recently had to install SQL Server 2016 again on my Windows 10 machine. This also meant that I had to install and configure MDS as well. Last time it didn’t went so smoothly: Master Data Services error – Cannot read configuration file due to insufficient permissions. However, this time I had already applied Service […]
SSIS Naming Conventions 2.0
People who have been working for a while with Integration Services probably know the legendary blog post by SQL Server MVP Jamie Thomson: Suggested Best Practises and naming conventions. The blog post served as a guidance point for many SSIS projects regarding naming conventions of the various tasks and components. I still use them every […]
Problem where you can only browse Google websites
Note: not a SQL/BI related post like usual, but since it’s a common issue I want to share my solution here Quite recently I had a bizarre issue on my laptop: suddenly I could only browse Google websites (Google search, YouTube, Gmail …). All the other websites would time out or give error messages. On […]